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

Archives: February 2011

Don’t Be Afraid of Windows Failover Clustering!

One of the more exciting features in SQL Server code-named “Denali” (which is the current official name for the next major version of SQL Server) is called SQL Server AlwaysOn, which Microsoft describes like this:

The new SQL Server AlwaysOn will provide a set of capabilities to help businesses maximize…

Read more

0 comments, 857 reads

Posted in Glenn Berry's SQL Server Performance on 28 February 2011

Some Suggested SQL Server 2008 R2 Instance Configuration Settings

Depending on your anticipated workload and which SQL Server components you have installed, there are a number of instance level settings that you should consider changing from their default values. These include Max Server Memory, optimize for ad-hoc workloads,  default backup compression, max degree of parallelism, and the number of…

Read more

11 comments, 7,488 reads

Posted in Glenn Berry's SQL Server Performance on 25 February 2011

New SQL Server 2005 Cumulative Updates

Microsoft has released two new Cumulative Updates for SQL Server 2005. The first one is SQL Server 2005 SP3 CU14, which is Build 9.00.4317. The second one is SQL Server 2005 SP4 CU2, which is Build 9.00.5259. There are only two fixes for SP3 and nine fixes for… Read more

1 comments, 233 reads

Posted in Glenn Berry's SQL Server Performance on 23 February 2011

New Version of CPU-Z (1.57) has Been Released

On February 18, Franck Delattre released version 1.57 of the very useful CPU-Z Utility. Here is a list of the new features:

  • Intel Xeon “Westmere-EX” support
  • GPU frequency report on Intel Sandy Bridge processor
  • AMD Zacate/Ontario processors support
  • Report TDP on main page when available
  • Cores clocks on floating…

Read more

0 comments, 1,146 reads

Posted in Glenn Berry's SQL Server Performance on 20 February 2011

Is CPU-Z Risky To Run on a Production Server?

There was a conversation on Twitter recently (with the #sqlhelp hashtag) about whether it was completely safe to run the popular CPU-Z utility on a Production database server. The questioner was concerned about possible instability or even a Blue Screen of Death (BSOD) that might occur if you ran CPU-Z… Read more

4 comments, 844 reads

Posted in Glenn Berry's SQL Server Performance on 19 February 2011

How to Interpret SELECT @@VERSION in SQL Server

One common point of confusion that I often see when people run the SELECT @@VERSION query is how to properly understand the results that are returned. I have seen many people mix up the SQL Server portion of the results with the Operating System portion of the results.

Everything in… Read more

0 comments, 849 reads

Posted in Glenn Berry's SQL Server Performance on 17 February 2011

Windows Server 2008 R2 SP1 Released and Installed

Microsoft has made Windows Server 2008 R2 Service Pack 1 (and Windows 7 SP1) available on MSDN and TechNet earlier today. They are using the Akamai Download Manager for these, and I was able to download them very quickly with no problems.

They also have slipstream installs that incorporate SP1… Read more

1 comments, 631 reads

Posted in Glenn Berry's SQL Server Performance on 16 February 2011

Recent AMD Processor News

AMD has released five new specific models in their Opteron 6100 series line. Of these, the one you should be interested in (from a performance viewpoint) is the 2.5GHz twelve-core Opteron 6180 SE, which becomes the new top of the line Opteron processor, with a 200MHz speed bump over the… Read more

0 comments, 219 reads

Posted in Glenn Berry's SQL Server Performance on 15 February 2011

SQL Server and the “Lock pages in memory” Right in Windows Server

Another Windows setting you might want to enable is “Lock pages in memory”. There is some controversy within the SQL Server community and within Microsoft about whether and when you should enable this setting. Before you decide whether you want to do this, let me give you some background. When…

Read more

1 comments, 892 reads

Posted in Glenn Berry's SQL Server Performance on 14 February 2011

Presentation Slides For Hardware 201 at SQLSaturday #66 in Colorado Springs

I will be giving my Hardware 201: Selecting and Sizing Hardware for OLTP Performance presentation at SQLSaturday #66 at 1:30PM today in Colorado Springs. Here is the abstract:

The foundation of database performance is the underlying server hardware and storage subsystem. Even the best designed and optimized database application can…

Read more

0 comments, 318 reads

Posted in Glenn Berry's SQL Server Performance on 12 February 2011

Windows Instant File Initialization and SQL Server

One Windows setting that I think is extremely important for SQL Server usage is the “Perform volume maintenance tasks” right, which enables Windows Instant File Initialization. On a Windows Server 2003 or newer operating system, using SQL Server 2005 or newer, you can take advantage of this feature to dramatically

Read more

1 comments, 849 reads

Posted in Glenn Berry's SQL Server Performance on 11 February 2011

Service Pack 1 for Windows Server 2008 R2 and Windows 7

Microsoft’s Brandon LeBlanc announced the upcoming availability of Service Pack 1 for Windows Server 2008 R2 and Windows 7 on “The Windows Blog”.

It will be available for download on MSDN and TechNet on February 16, and on Windows Update on February 22.

The two main new features… Read more

0 comments, 794 reads

Posted in Glenn Berry's SQL Server Performance on 9 February 2011

Promoted to MSDB Rockstar Blogger

I just found out this morning that I was promoted from TempDB to MSDB on Thomas LaRock’s (blog|Twitter) Rockstar blogger rankings.

It is very nice to get some public recognition for your efforts, so I really appreciate this. It is hard to believe that I am… Read more

3 comments, 207 reads

Posted in Glenn Berry's SQL Server Performance on 7 February 2011

Five DMV Queries That Will Make You a Superhero in 2011!

Way back in January, 2008, I wrote a blog post called  “Five DMV Queries That Will Make You A Superhero!” which continues to get lots of hits three years later. I thought it was time to update this with a new version that you can download from here Read more

20 comments, 1,676 reads

Posted in Glenn Berry's SQL Server Performance on 4 February 2011

February 2011 Version of SQL Server 2005 and 2008 Diagnostic Information Queries

Wow, it is already February 2011, so here are the February 2011 versions of the SQL Server 2005 Diagnostic Information Queries and the SQL Server 2008 Diagnostic Information Queries.

To go with them are the matching blank results spreadsheets for SQL Server 2005 and SQL Server 2008. The…

Read more

4 comments, 987 reads

Posted in Glenn Berry's SQL Server Performance on 2 February 2011