Print this page
Thursday, 16 February 2012

VMWare SQL Instance

Written by
Rate this item
(0 votes)

Vmware VCentre uses a SQL Express instance by default.

We recently had a issue with a High Availability (HA) VCentre system that had been upgraded to allow more hosts to be added, and ever since the system was slow. The performance of the Virtual environment was dire and plans to P2V more machines had to be delayed.

Virtualisation can be great, but one thing is wrong every Virtual Server suffers!

 

The solution was really simple the SQL Express instance had had no maintenance for 18 months, and hence the database was bloated, never been backed up to commit truncate logs, badly organised, badly indexed and simply needed some maintenance.

We carried out a full 5 point maintenance plan on the database, and the scheduled this to run.

The client now has a system they are confident in, and none of their staff are waiting for everything to happen.

Read 65845 times Last modified on Monday, 10 June 2013