Browse by Tags

All Tags » Performance » Service Pack (RSS)
13 March 2007 23:35

Windows 2003 Service Pack 2 released

Windows Server SP2 has been released. The download page is here . There is a performance improvement for SQL Server 2005 around the winsock API but it's most noticeable in higher end (>8CPU + multi NIC) hardware running workloads that show a high kernel...
Posted by sqldbatips | 1 comment(s)
Filed under: ,
08 March 2007 07:23

SQL 2005 Performance Dashboard Custom SSMS Reports available

As I've previously blogged about, SQL 2005 SP2 allows users to write custom reports that are hosted in SSMS and are available via the Reports context menu in Object Explorer. Microsoft have now released a group of reports that can be used to troubleshoot...
Posted by sqldbatips | with no comments
Filed under: , ,
25 February 2007 21:04

Estimating vardecimal storage savings in all databases

One of the new features in SQL Server SP2 is the vardecimal storage format which can be used to significantly reduce the space required by decimal and numeric columns in a table at the cost of a small CPU overhead. The storage savings must be balanced...
Posted by sqldbatips | with no comments
Filed under: , ,