vCenter 4.0 SQL Database tweaks

VMware just released a killer whitepaper on how to optmize SQL 2008 performance for vCenter 4.0. It has quite a few details that I was not aware of and will result in changes to my production environment. Tips that were new to me included:

– Optimizing the clustered index fill factor
– Setting database retention policy
– Enable automatic statistics
– Montioring buffer cache hit ratio

You can read the entire whitepaper here.

Print Friendly, PDF & Email

Related Posts

Subscribe
Notify of
0 Comments
Inline Feedbacks
View all comments