Search
  Home
  Articles
  Backup
  Books
  Certification
  FAQ
  Products
  Replication
  Scripts
  Seminars
  Training
  TSQL

MSDN Fourms
Philippine SSUG

  Resume

MHS Enterprises
FilAm Software
AcrylicAcetate.com
Bargain Humidors
Western Humidor

SQL Probe 7.0.44 1 2 3 4 5 6 7 8 9

Clicking on the replication area will display the figure below.  This will give you a quick view of all of the problem transactions in your replication system.

Clicking on a database gives you some very detailed information on that database.  The date of the last tran log along with the compatibility level are displayed.

This is one of the areas where the interface design choices have me baffled.  It would be one thing if they were consistent.  On the initial screen, a 6.5 server will show full text searching as not installed when in fact that option is not available.  But if you open up the database stats screen on a 6.5 server, the compatibility level will show as N/A.  This is accurate and at least makes sense.  The state of all of the database options will be displayed in the top right.  Again a 6.5 server will display a NO for things such as auto create statistics, auto update statistics, torn page detection, auto-close, auto-shrink, and full text which do not exist on a 6.5 server instead of showing N/A.

Telling me something is on/off, installed/not installed means that I have the capability to turn it on/off or install/uninstall it.  Telling me something is N/A means that it is an option that is unavailable for that particular version of the DBMS.  If I can't possibly install/uninstall or turn on/off something, tell me it is not available instead of indicating it is something that I may have missed.

A list of all tables in the database, their size, and number of rows is displayed along with options to include system table or only pinned tables.  The last 31 days of backups for that database along with pertinent information about the backup are listed in the left middle grid.  The bottom half of the screen displays graphical information about the data device(s)/file(s) and the tran log.  Settings are not maintained from one time to another.  I never want to look at system tables when monitoring servers.  This means that every time I drill into a database, I have to deselect the Include System Tables checkbox.

SQL Probe 7.0.44 1 2 3 4 5 6 7 8 9

Michael R. Hotek

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.