Category: All

Wait Statistics and FileIO Delta Capture Utilities Updated
Posted by Rob Risetto on February 26, 2015

Reviewing the deltas of Wait Statistics and Database File IO gives you a better indication of what is happening now on your SQL Server now and are not skewed by the historical accumulated values.

Continue Reading →

2014 Predictions for SQL Server
Posted by Rob Risetto on February 05, 2015

At the beginning of each year I always like to check on what the head honchos/big hitters are predicting for the coming year, and then for gags I also come up with my own predictions. So here goes :

Continue Reading →

Migrating Database Mirroring to an Availability Group
Posted by Rob Risetto on January 20, 2015

Recently I had to develop a migration plan to move a two server SQL Server 2008 R2 database mirroring environment to a two server SQL Server 2012 Availability Group (AG). The challenges were to minimise down time where possible, avoid transferring 40+ GB of database backups to the second server in the disaster recovery site and to perform the upgrade in line (i.e. no new equipment or VMs).

Continue Reading →