Performance Tuning - Category Archive
The following is a list of all entries from the Performance Tuning category.
How to Script a Profiler Trace for Use as a SQL Trace Data Collection Set for the SQL Server 2008 Performance Data CollectorDatabase Maintenance,Performance Tuning | September 25, 2008 | 4:53 pm
In SQL Server 2008, a new feature called the Performance Data Collector was added. It has the ability to collect SQL Server-related performance data, store it in a database called the Management Data Warehouse, and then produce various performance reports based on the collected data. By default, the Performance Data Collector includes three different data ...read more