Monthly Archives: February 2010

Cumulative Update Package 8 for SQL Server 2005 Service Pack 3

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

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

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

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

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

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

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

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

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)

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