Monthly Archives: August 2010

How Old Are Your Database Statistics?

Unlike fine wine, database statistics do not improve with age. I recently helped out with a client who was having issues with poor query performance on a SQL Server 2005 instance on very good hardware. After having them run my … Continue reading

Posted in SQL Server 2005 | Leave a comment

Hardware Performance Research

I am trying to gather some information about some of the newer Intel and AMD processors as part of my research for some upcoming presentations.  I am looking at the possible correlation between TPC-E scores and Geekbench scores. Matching TPC-E … Continue reading

Posted in Computer Hardware | Leave a comment

SQL Server 2008 R2 Diagnostic Queries from SQL Saturday #51 Nashville

Here are the diagnostic queries that I ran during my presentation at SQL Saturday #51 in Nashville on August 21, 2010. — SQL Server 2008 and R2 Diagnostic Information Queries — Glenn Berry — August 2010 — http://glennberrysqlperformance.spaces.live.com/ — Twitter: … Continue reading

Posted in SQL Server 2008 R2 | Leave a comment

DMV Emergency Queries From SQL Saturday #51 in Nashville

I wanted to post the first T-SQL script from my DMV Emergency Room presentation on August 21 in Nashville. This is designed to help you gather initial triage information about what is happening on your database instance, and then start … Continue reading

Posted in SQL Server 2008 R2 | Leave a comment

Estimating Data Compression Savings in SQL Server 2008 and 2008 R2

Since I finished upgrading the last of my Production environment to SQL Server 2008 R2 running on Windows Server 2008 R2 a couple of weeks ago, I have been spending some time re-evaluating which indexes can take advantage of data … Continue reading

Posted in SQL Server 2008 R2 | 1 Comment

Fall Speaking Schedule

I just got back from speaking at SQL Saturday #51 in Nashville, which was a lot of fun. I’ll write some more about SQL Saturday #51 later today.  In the meantime, I wanted to compile a list of the different … Continue reading

Posted in Teaching | Leave a comment

SQL Server 2005 SP3 Cumulative Update 11 (CU11) Available

Microsoft has released Cumulative Update 11 for SQL Server 2005 SP3, which is Build 9.0.4309. There are only four fixes in this cumulative update, which could mean that SQL Server 2005 SP3 is a very mature, stable product, or it … Continue reading

Posted in SQL Server 2008 R2 | Leave a comment