Browse by Tags

All Tags » Performance (RSS)

Disk Partition Alignment Best Practices for SQL Server whitepaper

This paper documents performance for aligned and nonaligned storage and why nonaligned partitions can negatively impact I/O performance; it explains disk partition alignment for storage configured on Windows Server 2003, including analysis, diagnosis...
Posted by sqldbatips | with no comments

Troubleshooting Performance issues with TokenAndPermUserStore in SQL2005 x64

I've recently seen quite a few performance issues related to the size of the TokenAndPermUserStore cache in x64 SQL2005 so wanted to share a simple technique to manage the size of this cache. The issues around this store are described in KB 92736 however...
Posted by sqldbatips | 8 comment(s)
Filed under:

SQL 2005 Best Practice Analyzer and DMVStats tool available for download

A couple of SQL tools are available for download this week. First off is the July 2007 release of SQL 2005 BPA (Best Practice Analyzer). New and updated BPA rules will now be released independent of SQL Service Packs (read more here ). Second of all is...
Posted by sqldbatips | with no comments
Filed under: ,

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)

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...

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

SQL Server 2005 Best Practices Analyzer (February 2007 CTP)

It has been a while in coming but you can now download the CTP of the SQL Server 2005 Best Practice Analyzer tool. The SQL Server 2005 Best Practices Analyzer (BPA) gathers data from Microsoft Windows and SQL Server configuration settings. BPA uses a...
Posted by sqldbatips | with no comments

Analysis Services 2005 Performance Tuning Whitepaper

This white paper describes how application developers can apply performance-tuning techniques to their Microsoft SQL Server 2005 Analysis OLAP solutions. It's a very interesting and thorough (and long!) paper and well worth a read. Download it here Also...
Posted by sqldbatips | with no comments

SQL Server - Best Practices Technet site

Get the real-world guidelines, expert tips, and rock-solid guidance to take your SQL Server implementation to the next level. Drawing on the extensive experience and expertise from respected developers and engineers at Microsoft as they walk you through...
Posted by sqldbatips | with no comments
Filed under: