Speaking at the Wisconsin SQL Server User Group
I’m speaking at the Wisconsin SQL Server User Group in Waukesha, WI this Tuesday (8/12). If you are interested, RSVP to SQLDBA@new.rr.com
Presentation: SQL Server 2008 – What do you want to know about it?
SQL Server 2008 introduces a framework for collecting, storing and reporting on server, database, and query performance data. In order to store and persist performance information, SQL Server 2008 includes a Management Data Warehouse designed to house performance metrics from multiple instances of SQL Server. In addition, SQL Server 2008 provides Data Collectors to facilitate scheduled capture of common system and database performance measures including DMVs, Windows Performance Counters, T-SQL queries, and SQL Trace. Microsoft completes the picture with a series of reports and views into the system and database performance.
In this session, we will take a closer look at the SQL Server 2008 Management Data Warehouse capabilities including:
· Setup and structure of the Management Data Warehouse database
· approaches Review the standard data collection types included with SQL Server 2008
· Demonstrate the reporting and analysis capabilities
· Discuss to defining and creating custom data collectors