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.
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.