Blogs

SQL 2008 R2 Performance Issues

One of our largest customers has attempted to move to SQL 2008 R2 as part of a Hardware and Software upgrade project, however we have since discovered certain issues with the SQL query performance of SQL 2008R2 against older versions of Microsoft SQL

Thankfully the customer in question has employed a very helpful and willing IT Team who have assisted in re-installing the new SQL Server machine with the older version SQL Server 2005 SP4 using an idenitical database in order to prove for certain that the performance issues are solely down to the Microsoft SQL Server version

Hotfixes have been suggested online:

 

Original post suggesting Hotfix for SQL Server on Windows Server 2008 R2

unexplained slowness

Hotfix from Microsoft

http://support.microsoft.com/default.aspx?scid=kb;EN-US;976700

 

However we did not experience any improvement in performance after installing these.  We will continue to research and investigate these issues with our customers, but in the meantime based on this experience we would hesitate to recommend SQL Server 2008 R2 for running TriSys software until this issue has been acknowledged and resolved by Microsoft

Add comment




  Country flag
biuquote
  • Comment
  • Preview
Loading



Archives
Search