Monthly Archives: August 2010

How Old Are Your Database Statistics?

Posted on August 30, 2010 by Glenn Berry

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

Posted on August 30, 2010 by Glenn Berry

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

Posted on August 23, 2010 by Glenn Berry

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

Posted on August 23, 2010 by Glenn Berry

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

Posted on August 23, 2010 by Glenn Berry

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

Posted on August 23, 2010 by Glenn Berry

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

Posted on August 17, 2010 by Glenn Berry

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

Proper Usage of MAXDOP Setting When Compressing Indexes in SQL Server 2008/2008 R2

Posted on August 17, 2010 by Glenn Berry

I am a pretty big fan of SQL Server Data Compression, especially the enhanced version found in SQL Server 2008 R2 that includes Unicode compression. If you have tables or indexes that are good candidates for data compression (because they … Continue reading →

Posted in SQL Server 2008 R2 | Leave a comment

SQL Server 2008 and R2 Diagnostic Information Queries

Posted on August 15, 2010 by Glenn Berry

It has been a couple of months since I have posted an update to my  “SQL Server 2008 and R2 Diagnostic Information Queries”, which are a series of mostly DMV queries that are used to gather information about the configuration, … Continue reading →

Posted in SQL Server 2008 R2 | 2 Comments

Using the Windows Experience Index as a Shopping Tool

Posted on August 11, 2010 by Glenn Berry

One easy to use and useful tool that you can use to compare relative performance between different machines that are running any version of Windows 7 is the Windows Experience Index (WEI) that comes with the operating system. After you … Continue reading →

Posted in Computer Hardware | Leave a comment