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

Archives: December 2011

SQL Server 2008 Diagnostic Information Queries (December 2011)

Here is a fresh set of diagnostic information queries for SQL Server 2008 and 2008 R2 for December 2011. Some of the queries (which are labeled) will only work with SQL Server 2008 R2 Service Pack 1 or later. Most of the queries will also work with SQL Server 2012,… Read more

3 comments, 1,515 reads

Posted in Glenn Berry's SQL Server Performance on 29 December 2011

SQL Server 2008 R2 RTM Cumulative Update 11

On December 19, 2011, Microsoft released SQL Server 2008 R2 RTM Cumulative Update 11 (CU11), which is Build 10.50.1807.0. I count 22 fixes in this Cumulative Update. This CU is only for the SQL Server 2008 R2 RTM branch, so it will not work if you have already installed SQL… Read more

0 comments, 1,080 reads

Posted in Glenn Berry's SQL Server Performance on 26 December 2011

SQL Server 2008 R2 SP1 Cumulative Update 4

On December 19, 2011, Microsoft released SQL Server 2008 R2 SP1 Cumulative Update 4 (CU4), which is Build 10.50.2796. I count 52 fixes in the fix list for this Cumulative Update, which is an unusually high number for a CU. Keep in mind that this CU is only for SQL… Read more

2 comments, 2,189 reads

Posted in Glenn Berry's SQL Server Performance on 26 December 2011

SQL Server 2012 Diagnostic Information Queries (December 2011)

Since the final RTM release of SQL Server is getting ever closer, I thought it was a good time to release an updated version of my SQL Server 2012 Diagnostic Information Queries. These queries are meant to be used with SQL Server 2012, but many of them will also… Read more

3 comments, 2,971 reads

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

CPU-Z 1.59 Released

One of my favorite free tools for getting some processor and memory specific information from a Windows computer (whether is is a laptop or a database server), is CPU-Z.  It gives you a lot of very useful, accurate information about your processor(s) and memory, including what the current core speed… Read more

2 comments, 891 reads

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

Scaling SQL Server – SQL Saturday #104 Precon

I will be presenting a day long preconference session on Scaling SQL Server for SQLSaturday #104 on Friday, January 6, 2012 from 8:00 AM to 5:00 PM (MT) in Colorado Springs, CO. This will be a revised and expanded version of the half-day session I gave at the PASS 2011…

Read more

0 comments, 556 reads

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