Link to home
Start Free TrialLog in
Avatar of compdigit44
compdigit44

asked on

vCenter 5.1 SQL 2012 Maintenance Plan

I have trying to improve the performance of our vCenter server which I have inherited. There are daily backups which are successfully but that is it.

I have read the following article on creating a maintenance plan for vCenter DB's.   http://blogs.vmware.com/kb/2013/05/the-inside-scoop-maintenance-tips-for-your-vsphere-database.html 

My question is in regards to the index rebuild, can this be done online and if so should I do I reorg first then since nothing has ever been done on the DB then ease into a rebuild. I know you only do one or the other.
ASKER CERTIFIED SOLUTION
Avatar of Andrew Hancock (VMware vExpert PRO / EE Fellow/British Beekeeper)
Andrew Hancock (VMware vExpert PRO / EE Fellow/British Beekeeper)
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of compdigit44
compdigit44

ASKER

I have actually implement the recommendation in the blog except I decided to go for the reorg inset of reindex

The DB has never been groomed and is fragmented. I know a reindex is the best fix for this but I wanted to start smaller..
So far the maintenance plan seems to be running ok