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.
