Monthly Archives: February 2010

Cumulative Update Package 8 for SQL Server 2005 Service Pack 3

Posted on February 17, 2010 by Glenn Berry

Microsoft has released CU8 for SQL Server 2005 SP3, which you can get here. This is Build 4285. This CU has five listed fixes, including two for database mirroring. Interestingly, there does not seem to be a “matching” CU for … Continue reading →

Posted in SQL Server 2005 | 4 Comments

Mirroring a Large Number of Databases in a Single SQL Server Instance

Posted on February 17, 2010 by Glenn Berry

Microsoft SQLCAT team members Sanjay Mishra and Prem Mehra have published a new Technical Note called Mirroring a Large Number of Databases in a Single SQL Server Instance on the SQLCAT web site. This paper explores what happens to performance … Continue reading →

Posted in SQL Server 2008 | 2 Comments

MVP Summit Impressions From Day 1

Posted on February 16, 2010 by Glenn Berry

Well, today was the opening day of the 2010 MVP Global Summit in Bellevue, WA. There were a few “side sessions” with content that I cannot discuss (not because anything secret was discussed), but because Microsoft is really cracking down … Continue reading →

Posted in Microsoft | 4 Comments

Presenting in Colorado Springs on May 19, 2010

Posted on February 15, 2010 by Glenn Berry

I will presenting at the Colorado Springs SQL Server User’s Group (CSSQLUG) on Wednesday, May 19, 2010. I will be doing my Dr. DMV: How to Use Dynamic Management Views to Monitor and Diagnose Performance Issues With High Volume OLTP … Continue reading →

Posted in SQL Server 2008 | 4 Comments

SQL Server 2005/2008 Servicing Plans

Posted on February 13, 2010 by Glenn Berry

Microsoft Group Program Manager Matthias Berndt has a post up on the Microsoft SQL Server Release Services blog (which is a good blog to subscribe to in your favorite RSS reader) regarding Microsoft’s plans for releasing both SQL Server 2005 … Continue reading →

Posted in SQL Server 2008 | 2 Comments

Round Two of Insert Benchmark Tests

Posted on February 9, 2010 by Glenn Berry

After seemingly exhausting my physical file layout and instance configuration options in Round One of testing, I decided to “throw some hardware” at the problem, and cheat by using SQL Server data compression. I increased the physical RAM from 6GB … Continue reading →

Posted in SQL Server 2008 | Leave a comment

Speaking at the Rocky Mountain Tech Trifecta on February 27

Posted on February 8, 2010 by Glenn Berry

I will be giving my Dr. DMV: How to Use Dynamic Management Views to Monitor and Diagnose Performance Issues With High Volume OLTP Workloads presentation at the Rocky Mountain Tech Trifecta event on February 27, 2010 at Metro State College … Continue reading →

Posted in SQL Server 2008 | 3 Comments

Some Initial Insert Test Benchmarks on SQL Server 2008 R2

Posted on February 7, 2010 by Glenn Berry

They say that imitation is the sincerest form of flattery. I have been following along as Paul Randal has been doing a series of blogs illustrating some benchmarks on a collection of actual server hardware he has at his house. … Continue reading →

Posted in SQL Server 2008 | 9 Comments

Detecting and Troubleshooting Non-Yielding Worker Threads in SQL Server 2005/2008

Posted on February 4, 2010 by Glenn Berry

I had a little bit of excitement with one of my production servers couple of days ago, that I thought I would document (especially since it turned out well in the end).  I have a little VB.NET WinForms application that … Continue reading →

Posted in SQL Server 2008 | 2 Comments

Three Engine Improvements in SQL Server 2008 R2 (Updated)

Posted on February 2, 2010 by Glenn Berry

The upcoming release (by May 2010) of SQL Server 2008 R2 has been primarily focused on enhancements in the BI area to support the upcoming releases of Office 2010 and SharePoint 2010. This left precious little development resources to devote … Continue reading →

Posted in SQL Server 2008 | Leave a comment