Monthly Archives: 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 … Continue reading

Posted in Computer Hardware | Tagged , | 1 Comment

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 … Continue reading

Posted in SQL Server 2005, SQL Server 2008, SQL Server 2008 R2 | Tagged | 58 Comments

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 … Continue reading

Posted in Computer Hardware, Teaching | Tagged | Leave a comment

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 … Continue reading

Posted in SQL Server 2005, SQL Server 2008, SQL Server 2008 R2 | Tagged | 16 Comments

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 … Continue reading

Posted in Windows 7, Windows Server 2008 R2 | Tagged | Leave a comment

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 … Continue reading

Posted in Microsoft Training, Teaching | Tagged , | Leave a comment

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 … Continue reading

Posted in SQL Server 2008, SQL Server 2008 R2 | Tagged | 10 Comments