30th September - 2nd October 2010

University of York

Gold sponsors
Silver sponsors
Bronze sponsors

Introduction to SQL 2008 Performance Data Collector

SQL 2008 includes a new Data Collector infrastructure that expands on the work done with the Performance Dashboard custom reports introduced in SQL2005 SP2 to allow you to easily configure and collect performance data from your SQL instances and store them in a Management Data Warehouse. In this session I'll cover the architecture and system data collection sets and demonstrate how to create your own custom collections. I'll also cover how to create custom reports hosted in SSMS to display and report on the collected data.

Speaker focus

Jasper Smith

Jasper is a member of the Database Services team at Nationwide Building Society focussed on High Availability, Scalability, Performance Tuning and Monitoring. He has been a SQL Server MVP since 2003 and runs www.sqldbatips.com with a focus on providing free tools for the SQL Server community including ExpressMaint, SQL 2005 Service Manager and Reporting Services Scripter.

Jasper Smith's blog http://sqlblogcasts.com/blogs/sqldbatips



Downloads

No items to download

Other sessions from this conference

"SELECT TOP(@x) Name FROM MyFavouriteDMVs ORDER BY MyRanking"
2005 SQLCMD Scripting
Administering SQL Server 2008 and 2005 with Windows PowerShell
Development Life Cycle using Visual Studio Team Edition for DB Professionals
Extending SSIS with custom Data Flow components
Getting to grips with Service Broker.
I/O! I/O! It’s off to disk we go...
Making more of SSIS in 2008
Making the leap into Advanced SQL
Master Data Management (MDM)
New Product Demos
Recruitment Open Panel
Reporting in SQL Server 2008
SQL Server 2008 – Declarative Management Framework concepts & database problem solutions with policy management.
SQL Server 2008 TSQL Enhancements
SQL Server High Availability and Disaster Recovery Overview
Transient data in SQL Server
Understanding LINQ in .NET Framework V3.5 and Beyond
Using Analysis Services as a data source for Reporting Services reports
What Are You Waiting For?
Where do you live? Intro to spatial indexing