LinkedIn | FaceBook | Twitter
I'm continuing my series on the Standard Reports in SQL Server Management Studio, and today we’re in the Management reports. You can find these reports by starting SQL Server Management Studio and right-clicking the Management node. From the menu that appears, click the Standard Reports, and then select the title at the top of this post.
This report shows information about the tasks that are running on your system, and some useful blocking information.
The first section of the report is a graph showing a comparison of the running versus suspended tasks.
The second section of this report shows tasks according to their state:
The next band of the report shows information about blocking by tasks:
PingBack from http://outdoorceilingfansite.info/story.php?id=5110
Good stuff, but why BOL does not have anything about wait types? I would like to use wait types to performance tunning, but I never found a official MS complete descritpion of wait types. I had already found technet article about that, but it was about SQL Server 2k.Is there any link to SQL Server 2005 and 2008 waity types?
Have you posted a "comment" on those BOL pages? If you do, it opens a bug in the doc team's folder and they'll respond to you about that.