Platinum Sponsors
 

13th September 2008 Hatfield, Hertfordshire

Session Details - Performance Monitoring Using SQL Server Management Studio - power of Management Data Warehouse

SQL Server introduces the Data Collector and Management Data Warehouse for troubleshooting common performance issues for a SQL Server database engine instance. This session demonstrates how to troubleshoot various problem scenarios using the new tools within SQL Server Management Studio (SSMS). It demonstrates how to plan for a deployment of the data collection tools taking into account lessons learned from deploying the tools within Microsoft IT. Learn how you can create your own collection sets and get the data out of the Management Data Warehouse.

Satya Shyam K Jayanty
Knowledge is the power and you will gain by sharing it; I'm an Independent Database expert, with over 16 years of experience in application designing, developing and managing database technologies using industry famous technologies & software. I have been working with SQL Server since version 4.2 (1996) and active member & moderator in Technet, MSDN, SQL-Server-Performance.com forums/websites and also writing for http://www.sql-server-performance.com website. I'm a regular speaker and volunteer (Ask The Experts) at SQL Server events such as SQLPASS, Tech-ed etc. and I was awarded as SQL Server MVP since the year 2006. I also update content & manage the website http://www.sqlserver-qa.net.

To view the presentation below in full screen double click on it.


Click here to view in local media player

Due to the size of these files we can only provided streamed versions.


Other sessions from this conference

A Testing Time... (Downloads) (Video)
A walk down memory lane (Downloads) (Video)
Advanced T-SQL (2005 and 2008) (Downloads) (Video)
Choices, Choices - Loading and Modelling Slowly Changing Dimensions in the SQL Server 2008 Suite (Downloads) (Video)
Data Vizualisation - Make your reports useful to business - No more "Speed Dials" (Downloads) (Video)
Does your cube support your users reporting needs? (Downloads) (Video)
Don't try this at work ! (Downloads) (Video)
End to End Report Creation and Management using Microsoft SQL Server 2008 (Downloads) (Video)
Getting more value from your data through data mining. (Downloads) (Video)
Head in the Cloud... (Downloads) (Video)
How to approach zero downtime database upgrades (Downloads) (Video)
Indexes Basically (Downloads) (Video)
Microsoft's integrated end-to-end BI offering. (Downloads) (Video)
Small Problem - Simple Solution: Lookup Tables (Downloads) (Video)
SQL Server – Under New Management (Downloads) (Video)
SQL Server 2008 for Developers (Downloads) (Video)
Understanding Query Cache and Query Plans (Downloads) (Video)
Useful Sql'y stuff that I've picked up over the years (Downloads) (Video)
Where’s my data? An introduction to Spatial Queries in SQL Server 2008 (Downloads) (Video)