With this exercise we have effectively increased performance at the expense of maintenance. Well worth the change.
We presented the solution to the business owners, with multiple sample reports generated by SSMS, Regular Pivot Tables and PowerPivot for Excel. We sliced and diced at the client level, server level and the results were coming back pretty fast. They were extremely happy as they just found a way to slice “everything by everything”. I even heard the statement ”This will be the company’s biggest asset”.
It turned out that the issue was not Hyper Threading related, but a Bios misconfiguration instead.
Today we had a production migration and brought over one of our legacy applications from a data center located up north to one located in South Florida. The challenges: 1. The locations are disconnected and far from eachother 2. We are going up 3 releases. From 2000 to 2008 R2… Read more »
Over 3 weeks ago we solved the issue we were having with one particular cluster node running SQL Server 2008 R2. We have been going back and forth with Microsoft to obtain an explanation on why the erratic behavior of the RDBMS engine.