sql server 2008 R2

Database
SQL Server

VCenter Server 4.1 Running under SQL Server pushes tempdb storage allocation through the roof

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. More information about it this […]

Read More
Database
SQL Server

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 More
Analytics
Database
Operating Systems
SQL Server
Storage
Technology
Windows

What’s happening in 2011

So what is happening next year? Many exiting things, with a core focus on HA, DR, Analytics, SharePoint 2010, and VMware on production databases

Read More
Database
Operating Systems
SQL Server
Windows

I/O Issues on a newly deployed SQL Server cluster attached to a SAN [Windows 2008 R2]

We executed the migration of stand-alone database servers to an active/active cluster. This was for our enterprise-wide reporting solution which includes a scaled-out deployment of Reporting Services implementing F5 BIGIP as a load balancer.

Read More