Tasks and Alerts Description
DBMS uptime Collects database uptime statistics.
Database backup Checks backup status of all databases.
Database status 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).


Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Post Comment