• Adam Thurgar

Datto snapshots

I was asked to look at a SQL Server by a business software solution company. Performance issues. I did a current system state assessment and found that there were no backups or maintenance occurring. This seems to be a common and consistent problem, especially with companies who do not have any DBA skills. But what I did find was that every 2 hours they were taking a snapshot of the whole VM using Datto. This did have a performance impact and chewed up a lot of disk space.

We implemented backups and maintenance using Ola Hallengren's scripts and the VM snapshots became 3 a day - one before business starts, one at lunch and the last at close of business. I still think this is overkill, but a big improvement. Plus doing index optimisation is such a no brainer.

6 views0 comments

Recent Posts

See All

Cardinality estimator

Recently I was asked by a software vendor to review a particular query that ran in under a second on a SQL Server 2014 installation at a compatibility level of 110 (SQL Server 2012), but when run unde

Index fragmentation

A law firm client, occasionally has issues with their legal software, that is provided by the global leader in this field. The response from the software provider is always the same - you have index f

Deleting large amounts of data

I had a client call me about wanting to delete a large amount of data from their database. They knew what tables they wanted to delete from. They also knew that deleting large amounts of data causes t