|
|
|
|
|
|
SQL Probe 7.0.44 1 2 3 4 5 6 7 8 9 The settings tab gives access to some powerful filtering capabilities. Raise your hand if you have ever had to walk down a blocking chain to determine where the blocking is ultimately coming from. This is rather easy if you have 2 or 3 processes blocked. Try doing this quickly when you have several thousand processes on the server and several hundred are blocked. I've had blocking chains that reach as much as 12 levels deep. This gets really nasty to untangle. The blocked processes button will filter out everything except those blocked processes. If you want to see which processes are blocking other processes, you can filter out all but those. What you are normally after is the process that is ultimately blocking everything. This would be a process that is actually running in most cases and would normally be filtered out otherwise. If you select the item labeled Blocking Processes Which Are Not Themselves Blocked, you have quickly narrowed down your culprit. You can then take appropriate action on that process to get thing moving again.
Clicking over the procedure cache item will display a graphical breakdown of how the procedure cache is being used.
|
All content on this site, except where noted, represents an original work of Michael R. Hotek and is protected by applicable copyright laws. The SQL Server FAQ is the sole work of Neil Pike. No page, portion of a page, or download may be used for commercial purposes in whole or in part without the express, written permission of the applicable author.
