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.
No comments:
Post a Comment