Sybase Health Check Tool

Features Requirements Example Install

The reports generated are easy to read and quite informative but usually run to a few pages in length. Literally 100's of checks are made and each database will produce a different set of warnings. The following examples have been taken from a real report though the names have been changed to protect the innocent.

Analysis of Example_DB on OurServer at 16 Feb 08 13:53
                Limited to 200 warnings

Naming Standards issues
=======================
   Proc TradeDelOldTableContents   - may be temporary
   Proc Trade_6640_984065997 - underscores unusual - may be temporary
   Table Log_tmp   - may be temporary

Performance issues
==================
   Proc EODPop - uses cursors
   Table DirectBond   - no unique index
   Table TdData - no indexes (115k rows)
   Table RshData - no indexes (1m rows)

Field definition issues
=======================
   Field code is defined as DataCode in 9 tables/procs but ...
      1 procs use varchar(50) NULL
      1 tables use altCodeVal
      1 tables use altcode
      1 tables use reportCodes
      1 tables use shortname
      1 tables use varchar(40) NULL
      1 tables use varchar(6) NULL
      8 procs use reportCodes

Field buySell is defined as ind in 34 tables/procs but ...
      1 tables use char(5) NULL
      11 tables use char(4) NULL
      2 tables use BuySellIndicator
      3 tables use ExecutionTypes
      6 tables use char(1) NULL
      8 tables use varchar(4) NULL

Fields texnId, Texn_id, TexnId, TexnID & TEXN_id seem the same
   Fields counterparty_id, counterpartyId & CounterpartyID seem the same
   Fields cpty_id, Cpty_id, Cpty_Id & CptyID seem the same

Note
====
   22% of the procedures have no comments
   Consider using (fewer) functional user accounts
   There are 72 databases on this server!
   Proc EODPop has been created in the past 6 weeks
   Proc RtlData has been created in the past 6 weeks
   Table TdData contains 24 duplicate rows

Overall score for database Example_DB is 55%

By Michael Robinson