|
|
|
|
|
SQL Probe 7.0.44 1 2 3 4 5 6 7 8 9 The detail statistics will break that down at a more granular level across 13 counters. This will display a breakdown across an entire day. Stats are kept for 365 days and you have the ability to select which day you want to view. There is currently no capability to look at multiple days or multiple counters. In order to do this, you have to export the stats to a text file, open them in something like Excel and graph them yourself. The stats package and in particular the stats that are kept for the server are the main failings of SQL Probe. It is designed to give you information about what is happening at the moment that you look at the server. There is almost no historical capability in the statistics that are tracked. Getting useful comparison on the meager stats that are stored is only useful when viewed as a trend. SQL Probe does not offer any capability to trend data and instead forces me to export stats and work with them in another application.
Clicking on the Oldest Open Transaction data will display the figure below. If you have open transactions on the server, the oldest open transaction per database will be displayed here. This will help you diagnose things such as runaway transaction logs and poorly structured transactions.
|
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.
