SQL Aloha

SQL Server 2008: Performance Data Collector

SQL Server 2008’s Performance Data Collector lets us create a central repository to store performance data and includes three built-in Data Collection sets that can be used to collect and store this data. Three built-in reports can then be used to access the stored data, so we can identify and troubleshoot SQL Server performance problems. Want to find out how the Performance Data Collector works and how it can help you? Read more…

1. How to Script a Profiler Trace for Use as a SQL Trace Data Collection Set for the SQL Server 2008 Performance Data Collector
2. An Introduction to Data Compression in SQL Server 2008
3. An Introduction to SQL Server 2008 Change Data Capture
4. Getting the Most Out of SQL Server Profiler Using Templates
5. SQL Server 2008 Transparent Data Encryption