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

Archives: December 2010

Updated SQL 2005 and 2008 Diagnostic Queries

Since it is almost January 2011, I thought I would post the January 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 Read more

1 comments, 1,188 reads

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

The Importance of Windows Power Plans for Server Performance

This is a subject I have written about a couple of times before, here and in much more depth here.  Much more recently, fellow SQL Server MVP Brent Ozar (blog| twitter) has also blogged about this subject.  I thought I would show you how to… Read more

1 comments, 470 reads

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

SQL Server Workload Types and Hardware Selection

There are two primary relational workload types that SQL Server commonly has to deal with, the first being Online Transaction Processing (OLTP) and the second being Decision Support (DSS)/Data Warehouse (DW). OLTP workloads are characterized by numerous, short transactions, where the data is much more volatile than in a DSS/DW…

Read more

2 comments, 1,449 reads

Posted in Glenn Berry's SQL Server Performance on 28 December 2010

A Collection of Good Information About Controlling VLFs in SQL Server

Because of the default settings in SQL Server (for the model database), and a lack of understanding about how the transaction log should be sized and maintained, I run into many databases that have a high number of virtual log files inside the transaction log file.

Even though I have… Read more

0 comments, 215 reads

Posted in Glenn Berry's SQL Server Performance on 27 December 2010

Intel Sandy Bridge Processor Machines Coming Soon!

If you are in the market to buy or build a new laptop or desktop computer, you might want to wait a few weeks, for several reasons. First, Intel is going to formally roll out the brand new Sandy Bridge family of processors at the Consumer Electronics Show on January… Read more

0 comments, 252 reads

Posted in Glenn Berry's SQL Server Performance on 22 December 2010

SQL Server 2005 SP3 Cumulative Update 13 Released

Microsoft has released SQL Server 2005 SP3 Cumulative Update 13, which is Build 4315. It was actually released on Monday, but the “View and request hotfix downloads” link was broken until earlier today.  I waited to blog about it until you could actually request it.

I have… Read more

0 comments, 276 reads

Posted in Glenn Berry's SQL Server Performance on 22 December 2010

SQL Server Scripts Manager From Redgate Software

Redgate Software has released a useful free tool called SQL Server Scripts Manager. I was happy to be included as one of the nine authors of the included scripts. It is always nice to get a free tool that does something useful.

This is how Redgate describes the tool: Read more

5 comments, 861 reads

Posted in Glenn Berry's SQL Server Performance on 22 December 2010

SQL Server 2008 R2 RTM Cumulative Update 5 Released

Microsoft has released SQL Server 2008 R2 RTM Cumulative Update 5 (CU5), which is Build 1753.  I count 40 separate fixes in this Cumulative Update, with quite a few SSAS fixes.


Read more

1 comments, 430 reads

Posted in Glenn Berry's SQL Server Performance on 21 December 2010

SQL Server 2005 Service Pack 4 RTM Released

Last Friday afternoon (December 17, 2010), Microsoft released the final RTM build of Service Pack 4 (SP4) for SQL Server 2005. This is scheduled to be the last Service Pack for SQL Server 2005, which is not that surprising, since SQL Server 2005 is a little over five years old… Read more

0 comments, 328 reads

Posted in Glenn Berry's SQL Server Performance on 20 December 2010

SQL Server Hardware Book

One reason (besides laziness) that I have been fairly light on my blogging lately is that I have been working to finish my first solo book, SQL Server Hardware, which is due to be published in February 2011 by Simple Talk Publishing. You can read the blurb on their… Read more

4 comments, 511 reads

Posted in Glenn Berry's SQL Server Performance on 14 December 2010

SQL Server 2008 Diagnostic Information Queries (Dec 2010)

I have been quite the slacker (by my usual standards) for blogging over the past few weeks, but my excuse is that I have been working on finishing my book for Redgate Publishing.

Here is the December 2010 version of my SQL Server 2008 Diagnostic Information Queries. I have… Read more

2 comments, 263 reads

Posted in Glenn Berry's SQL Server Performance on 14 December 2010

Presenting to the PASS Database Administration Virtual Chapter

I will be giving a presentation and demo to the PASS Database Administration Virtual Chapter on Wednesday, December 8 2010 at Noon, Mountain Time. I will be giving my Dr. DMV presentation, and here is the abstract:

Dr. DMV: How to Use Dynamic Management Views to Monitor and Diagnose Performance…

Read more

3 comments, 340 reads

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