|
|
|
|
|
DBArtisan 5.03 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 The process monitor is something I use religiously. I use it to get a quick idea of the traffic occurring against my servers. I also use it as the first step in analyzing performance and detecting blocking. The best part is that it is hands off for the monitoring. There is no need to perform a manual refresh. By setting the spinner at the left of the toolbar, the screen will refresh at whatever interval you want. I normally set it at 1 second when monitoring for blocks. I set it at 5 seconds - 10 seconds when getting a quick gauge on activity. Setting it to 0 stops the refresh. Active processes are shown in green, sleeping in yellow, and blocked in red. Clicking any of the grid headings will sort the grid on that column. I normally sort on the status column such that blocked or running processes appear at the top of the grid.
In previous versions if you wanted to get an idea of what a particular connection was executing, you had to double click on that PID. When you have a refresh rate of 1 second and you are trying to catch where blocking is occurring, this can become a very big pain and PIDs can move around in the grid right underneath your double click. As noted above, I sort by the status. Processes can be blocked for a small amount of time. When they are no longer blocked, they will relocate in the grid according to their current status. DBArtisan 5.03 introduced a very easy to use feature. You will notice a second pane below the process pane. Simply clicking a process will highlight that process and run a dbcc inputbuffer on that process. The results of dbcc inputbuffer will be displayed in the lower pane. This makes it very easy to grab processes that are blocked for only a brief period of time to see what they are executing. Without this functionality, it was almost like playing an arcade game to get this information.
Under the blocking locks tab, improvements have been made as well. You will notice a split pane underneath the grid. This split pane will display the command for the selected process on the left and the command for the process blocking it on the right.
DBArtisan 5.03 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 |
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.
