And to alleviate the problem temporarily we needed to bounce the instance and clear up the temp database files. But luckily there is a patch. More information provided in this article. We also needed to disable the Read Committed Snapshot Isolation Level in order to keep the growth under control…. Read more »
So what is happening next year? Many exiting things, with a core focus on HA, DR, Analytics, SharePoint 2010, and VMware on production databases
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”.