SP2 for SQL Server 2005 is released
Posted by decipherinfosys on February 20, 2007
The second service pack for SQL Server 2005 was released yesterday by Microsoft. There are a lot of very good fixes in this one. We had faced a major issue in the SP1 version where the CPU utilization went to 100% when the system was put under heavy load and it was related to query parameterization issues and parallel query plan generations when the optimzier should have been using a serial plan. The hack was to use the MAXDOP hint or to set the max degree of parallelism to be less than the number of processors on the system (we set it to 1 in order to avoid the issue) – since all our queries in the system were small in nature, a serial execution plan was much more favorable. In addition, the parameterization was changed to forced and that way we got around this issue in SP1. However, this issue is fixed in SP2. Here are the links:
Main SP2 Page: http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/servicepacks/sp2.mspx
Download SP2: http://www.microsoft.com/downloads/details.aspx?FamilyId=d07219b2-1e23-49c8-8f0c-63fa18f26d3a&DisplayLang=en
KB 921896 (the fix list): http://support.microsoft.com/?kbid=921896
As always, please apply these on the test system(s) and do regression and benchmark tests of your applications prior to rolling it out in production.
SP2a released for SQL Server 2005 « Systems Engineering and RDBMS said
[...] by decipherinfosys on March 7th, 2007 We had previously posted about SP2 release for SQL Server 2005. If you recall, in SQL Server 2000, when SP3 was released, it [...]