Professional
« Upgrading to SQL 2008 ServicePack 3 - problems | Main | Reporting on Exchange NDR/Undeliverable E-mails »
Sunday
Oct232011

Analyzing SQL Server Performance:  MDW

I recently discovered a tool that gives me a heads-up into performance across my SQL boxes:  MDW.  MDW provides graphical reports that allow me to quickly delve into the top waits in my system and what's causing them.  Rather than rehash what's already been said about getting MDW configured in your environment I'll hit some of the things that came up in my configuration that haven't been exhaustively covered in other areas of the web.  Check out my MDW link under the SQL heading to the right.

PrintView Printer Friendly Version

EmailEmail Article to Friend

Reader Comments

There are no comments for this journal entry. To create a new comment, use the form below.

PostPost a New Comment

Enter your information below to add a new comment.

My response is on my own website »
Author Email (optional):
Author URL (optional):
Post:
 
Some HTML allowed: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <code> <em> <i> <strike> <strong>