Database Optimizations on Microsoft SQL Server - Customer Study
The database optimization recommendations are based on the tuning that was carried out at one of our customer sites.
For recommending Microsoft SQL performance optimization, start by running the SQL diagnosis, identify the bottlenecks, and then change any configuration changes to the Microsoft SQL server.
Follow the same approach in tuning the database at the customer location. Iteratively, TIBCO ran the SQLdiag utility and highlighted top bottlenecks and addressed the heavy input/output contentions on the TEMPDB files common items first.
These configuration changes may or may not be applicable to other customers.
The following information lists some of the bottlenecks that TIBCO identified and fixed after running the Microsoft SQL diagnosis or Microsoft SQL profiler.