Migration to 2008 R2. Not as easy as Copy & Paste [Performance]
Better hardware and the latest SQL Server release does not always mean that things will run faster.
Read moreTag: performance
Table Structure, Trading Maintenance with Performance [SQL Server]
With this exercise we have effectively increased performance at the expense of maintenance. Well worth the change.
Read moreIncorrect Bios Settings Can Reduce Database Performance [SQL Server]
It turned out that the issue was not Hyper Threading related, but a Bios misconfiguration instead.
Read moreSummarizing Performance issues and workarounds after migrating from 2005 to 2008 R2 [SQL Server]
We were able to tune the offending processes and go from 85% sustained CPU utilization to almost nil.
Read moreMicrosoft Says there is nothing wrong with SQL Server 2008 R2
Over 3 weeks ago we solved the issue we were having with one particular cluster node running SQL Server 2008[…]
Read morePlaying with Page Level Compression and Indexes
Row and Page Compression are features added to SQL Server 2008 and there are plenty of articles/blogs that discuss about[…]
Read more