Optimizing Insight and Teamcenter SQL Server Performance in a Virtual Environment

SQL Server Pro has a great post by Denny Cherry with seven tips for optimizing SQL Server on the vSphere and Hyper-V virtual platforms.  Given that many Insight and Teamcenter customers are running SQL Server databases for their PLM backbone this article is a must read:

Optimizing SQL Server Performance in a Virtual Environment

Improving Your Insight SharePoint and Teamcenter SQL Server Performance By 460% with Index Defragmentation

Courtesy of the SQL Fool an awesome script to defragment the SQL Server indexes.   This is a maintenance script and can be useful for improving your overall SQL Server performance issues.

SQL utility and maintenance scripts can be applicable for both Insight and TCX installations running SQL Server.

So does index defragmentation matter?  From Microsoft SQL Server 2000 Index Defragmentation Best Practices: 

"The workload performance increase realized in the small-scale environment ranged from 60 percent at the low level of fragmentation to more than 460 percent at the highest level of fragmentation. The workload performance increased realized for the large-scale environment ranged from 13 percent at the low fragmentation level to 40 percent at the medium fragmentation level."

So how to use this defragmentation script?