Tag Archives: “SP 2”

Microsoft SQL Server 2008 R2 Service Pack 2 Released

Microsoft SQL Server 2008 R2 Service Pack 2 has now been released and can be downloaded from the following link:

http://www.microsoft.com/en-us/download/details.aspx?id=30437

Important Note

If you are upgrading from SQL Server 2008 R2 SP1 Cumulative Update 6 to SQL Server 2008 R2 SP2 then you must apply a post-SQL Server 2008 R2 SP2 cumulative update after you upgrade to SQL Server 2008 R2 SP2 to obtain all the fixes.

Cumulative update package 1 for Microsoft SQL Server 2008 R2 Service Pack 2  can be downloaded from the following link and should be installed straight after you have applied Microsoft SQL Server 2008 R2 Service Pack 2

http://support.microsoft.com/kb/2720425

Windows Vista, Server 2008 and SBS 2008 Service Pack 2 – You may find that Memory Manager can no longer commit Memory Pages resulting in applications and services experiencing performance and reliability issues

If you are running Windows Vista, Windows Server 2008 or Windows Small Business Server 2008 with Service Pack 2 you may find that Memory Manager can no longer commit Memory Pages resulting in applications and services experiencing performance and reliability issues.

This issue occurs because the Memory Manager incorrectly attempts to return more memory pages than have actually been allocated.

The issue can be resolved by applying the hotfix KB 2619529 http://support.microsoft.com/kb/2619529