Checks status of all databases defined on the system
Database growth rate (detailed)
Collects database growth rates statistics.
Database space check
Checks the amount of free space in all databases.
Transaction log space check
Checks the amount of free space in all transaction logs.
Blocking detector
This check helps identify processes that are blocking other processes. The “time_blocked” column in system table master..sysprocesses is checked for processes with status “lock sleep”.
Data cache statistics
Collects data cache statistics.
Procedure cache check
Checks the procedure cache.
Session load
Shows session statistics.
Temp cache statistics
Collects temp cache statistics.
Test DML-DDL performance
Runs performance test on database.The procedure executes SELECT, INSERT, UPDATE and DELETE statements on dbwatch engine schema test tables.
User connections check
Checks the configuration setting of the “number of user connections” from the master.dbo.syscurconfigs table against the number of connections on the instance (processes with suid != 0 in from the master.dbo.sysprocesses table).
Post your comment on this topic.