Monthly Archives: September 2010

SQL Server 2008 and 2008 R2 Diagnostic Information Queries

Posted on September 18, 2010 by Glenn Berry

Here is the latest version of my Diagnostic Information Queries for SQL Server 2008 and SQL Server 2008 R2. These are very useful for determining the configuration, health, and performance of a SQL Server instance and individual database. I have … Continue reading →

Posted in SQL Server 2008 R2 | Leave a comment

SQL Saturday #52 in Denver

Posted on September 17, 2010 by Glenn Berry

Its only about a week until SQL Saturday #52 in Denver. This is an all day, free event, being held at Cherry Creek Presbyterian Church 10150 E. Belleview Avenue Englewood, CO 80111. There are a number of great speakers, and … Continue reading →

Posted in Teaching | Leave a comment

Hardware 201:Selecting and Sizing Database Hardware for OLTP Performance

Posted on September 15, 2010 by Glenn Berry

I did a presentation for the fourth hour of 24 Hours of PASS – Fall 2010 today, which was a lot of fun. We had about 450 attendees for the session, which was a pretty decent turnout. A recording of … Continue reading →

Posted in Computer Hardware | Leave a comment

Some Moderately Big Iron on x64

Posted on September 8, 2010 by Glenn Berry

Here is a screenshot from a Dell PowerEdge R910 with four 2.27GHz Intel Xeon X7560 processors and 256GB of RAM. The Intel Xeon X7560 processor has eight cores, plus hyper-threading, for 16 logical cores per physical CPU. This gives you … Continue reading →

Posted in Computer Hardware | Leave a comment

Discount Code For SSWUG Ultimate Virtual Conference

Posted on September 2, 2010 by Glenn Berry

If you are interested in watching some high quality SQL Server content from the comfort and convenience of your own computer, you should consider attending the SSWUG Ultimate Virtual Conference on October 20, 21, and 22. The are a number … Continue reading →

Posted in Teaching | Leave a comment