Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

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 standard SQL Server 2005 Diagnostic Information queries, nothing glaringly obvious… Read more

20 comments, 5,766 reads

Posted in Glenn Berry's SQL Server Performance on 30 August 2010

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 scores to Geekbench scores, I see some indications of a…

Read more

0 comments, 846 reads

Posted in Glenn Berry's SQL Server Performance on 30 August 2010

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: GlennAlanBerry

-- Instance level queries *******************************

-- SQL and OS…

Read more

0 comments, 673 reads

Posted in Glenn Berry's SQL Server Performance on 24 August 2010

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 to gather more detailed information about a particular aspect (such… Read more

0 comments, 1,036 reads

Posted in Glenn Berry's SQL Server Performance on 23 August 2010

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 compression in SQL Server 2008 R2. By design, there is… Read more

5 comments, 1,539 reads

Posted in Glenn Berry's SQL Server Performance on 23 August 2010

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 events where I will be speaking, either physically or… Read more

1 comments, 284 reads

Posted in Glenn Berry's SQL Server Performance on 23 August 2010

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 could mean that Microsoft is not investing as many… Read more

1 comments, 463 reads

Posted in Glenn Berry's SQL Server Performance on 17 August 2010

SQL Server 2008 R2 RTM Cumulative Update 3 (CU3) Available

Microsoft has released Cumulative Update 3 for SQL Server 2008 R2 RTM, which is Build 10.50.1734. I count 29 fixes in this cumulative update, including several for SSMS and for managing SQL Azure databases from SSMS.

Read more

1 comments, 452 reads

Posted in Glenn Berry's SQL Server Performance on 17 August 2010

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

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 are large, relatively static, and show good compression savings), you… Read more

4 comments, 1,133 reads

Posted in Glenn Berry's SQL Server Performance on 17 August 2010

SQL Server 2008 and R2 Diagnostic Information Queries

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, health, and performance of an instance of SQL Server 2008… Read more

0 comments, 850 reads

Posted in Glenn Berry's SQL Server Performance on 16 August 2010

Using the Windows Experience Index as a Shopping Tool

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 install Windows 7, this tool runs for several minutes to… Read more

0 comments, 615 reads

Posted in Glenn Berry's SQL Server Performance on 11 August 2010

Speaking at 24 Hours of PASS on September 15, 2010

I will be one of the presenters for the 3rd installment of the 24 Hours of PASS: Summit Preview, which will be held on September 15-16, 2010. This free event will be held in two twelve hour blocks on two consecutive days (instead of 24 hours straight for the previous… Read more

0 comments, 395 reads

Posted in Glenn Berry's SQL Server Performance on 11 August 2010

Windows Azure Platform One Month Pass

According to all of their public pronouncements and the flurry of recent activity, Microsoft seems extremely serious about Windows  Azure and SQL Azure. If you are interested in playing around with Windows Azure and SQL Azure for free, you can try the Windows Azure Platform One Month Pass, by following… Read more

0 comments, 428 reads

Posted in Glenn Berry's SQL Server Performance on 6 August 2010

Testing Native Backup Compression in Combination with SQL Server 2008 R2 Data Compression

SQL Server 2008 introduced native backup compression and data compression as features that were only available in the Enterprise Edition SKU. In SQL Server 2008 R2, native backup compression was added to the Standard Edition SKU, while data compression remains an Enterprise Edition feature, although it was improved with the… Read more

2 comments, 1,930 reads

Posted in Glenn Berry's SQL Server Performance on 4 August 2010

SSWUG Ultimate Virtual Conference October 20-22, 2010

I will be presenting four sessions for the SSWUG Ultimate Virtual Conference that will be held online October 20-22, 2010. I get to fly down to the studio in Tucson in a couple of weeks to record my sessions. During the actual conference, I will be available in a chat… Read more

0 comments, 327 reads

Posted in Glenn Berry's SQL Server Performance on 2 August 2010

A Small Collection of DBCC Commands

There are a number of pretty useful DBCC Commands that have nothing to do with checking the consistency of a database (and thus were probably not written by Paul Randal).  I have put together a few of them in the script below.  The first command is the only one that… Read more

3 comments, 895 reads

Posted in Glenn Berry's SQL Server Performance on 2 August 2010