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.

Satya Shyam K Jayanty's blog http://sqlblogcasts.com/blogs/ssqanet/

---

Downloads

File Type Ext ContentName Zip File .zip Sample Code

<< 1 >>

---

Other sessions from this conference

A Testing Time...

A walk down memory lane

Advanced T-SQL (2005 and 2008)

Choices, Choices - Loading and Modelling Slowly Changing Dimensions in the SQL Server 2008 Suite

Data Vizualisation - Make your reports useful to business - No more "Speed Dials"

Does your cube support your users reporting needs?

Don't try this at work !

End to End Report Creation and Management using Microsoft SQL Server 2008

Getting more value from your data through data mining.

Head in the Cloud...

How to approach zero downtime database upgrades

Indexes Basically

Microsoft's integrated end-to-end BI offering.

Small Problem - Simple Solution: Lookup Tables

SQL Server – Under New Management

SQL Server 2008 for Developers

Understanding Query Cache and Query Plans

Useful Sql'y stuff that I've picked up over the years

Where’s my data? An introduction to Spatial Queries in SQL Server 2008