New Cumulative Updates for SQL Server 2008 SP1 and SP2

Microsoft has released new cumulative updates for both SQL Server 2008 SP1 and SQL Server 2008 SP2. Remember, both of these are completely separate from SQL Server 2008 R2 (which is considered a separate, major release from SQL Server 2008).

The first cumulative update is SQL Server 2008 SP1 CU12, which is Build 2808. It has 14 fixes, by my count.  The second cumulative update is SQL Server 2008 SP2 CU2, which is Build 4272. This CU has 28 fixes, by my count.

This is one of the more relevant fixes:

FIX: Slow performance when you recover a database if there are many VLFs inside the transaction log in SQL Server 2005 or in SQL Server 2008

Of course, I would argue that you should be monitoring and controlling your VLF counts in each of your user databases to avoid this issue completely, but it is nice to see a fix that addresses the issue at least somewhat.

This entry was posted in Microsoft, SQL Server 2008 and tagged , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s