Performance Monitoring using SQL Server Management Studio - Power of Management Data Warehouse

How many tools do you (need/use0 to monitor the performance of your SQL Server instance(s)?

Well, I'm not asking any count on the x number of tools you require to monitor the SQL Server instances within your environment, and Performance Tuning using Management Studio unlike any other tool to figure out to monitor the performance tuning. With SQL Server 2008 tools such as Management Studio (SSMS) can do all on the  management, performance tuning and monitoring etc. aspects. Then it comes a flurry of questions to ask yourself that :

• How many times you have used the Database tuning advisor?
• How many times you have used the Profiler (on day to day/weekly/monthly)?
• How often you use and depend on the DMVs?
• How many times you use the Performance Reports (Standard) in SSMS?
• Do you know how to monitor the performance on your SQL Server?

If you are not a DBA then don't worry, today the amount of resources we have on the cyber-world can get you on wheels to act like a DBA to take hands-on work to monitor your SQL platform. You may be aware that there are new reports to the standard reporting tool on SSMS, check them out and we will see them in the end... 2005 and 2008.

Management Data Warehouse is new kid on SQL Server 2008 town that is loaded with new performance monitoring features, you need a good understanding on the architecture of how SQL Server 2008 collects performance and diagnostic data and presents the information in Management Studio.  For an automated performance monitoring you should develop a plan for enabling performance data collection and analyzing the results for troubleshooting and diagnostics.

For all such questions in addition to the SQL Server 2008 Books ONline and online resources on web about SQL Server 2008 I would like to refer the presentation "Performance Monitoring Using SQL Server Management Studio - power of Management Data Warehouse" that was delivered at SQLBits conference on 13th September in United Kingdom.

I'm sure this will help you to learn how to create your own collection sets and manage the performance data collection warehouse database.

Here is the presentation file (stream) and thanks to Camtasia for making this happen.

Also the powerpoint show - http://sqlserver-qa.net/Satya_SQL2008_PoweofMDW.pps for  your reference.

Format: avi
Duration: 01 Hour 11 Minutes