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 Collector

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


Copyright 2009-2012 Brad M McGehee