|
|
|
|
|
SQL Probe 7.0.44 1 2 3 4 5 6 7 8 9 Clicking on the process, threads, or read ahead items will display the figure below. This will give you detailed stats on all of the processes currently connected to the server.
Clicking a particular process will allow you to drill into that process for very granular information. This will give you a listing of all of the read/write activity, options, language setting, and isolation level. The center of this screen will also display a full trace of the currently executing command. In the bottom right corner, you will see two icons. The garbage can allows you to kill the process. If you can't kill the process, you would resort to the bomb. The bomb icon will kill the NT thread that the process is running under.
|
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.
