dbWatch Server activity alert


Job details

Name: dbWatch Server activity alert
Platform: Sqlserver
Category: Internal
Internal
Description: Creates tables that can be used to simulate blocked sessions in the database.
Long description: This alert returns warning/alarm if the dbWatch Server is using consumes a lot of cpu over a period of time.
Version: 1.6
Default schedule: 2m
Requires engine install: No
Compatibility tag: .[type=‘instance’ & databasetype=‘sqlserver’]/instance[maj_version > ‘2000′ & engine_edition = ‘Microsoft SQL Server’ & eng_inst_priv = 0]

Parameters

Name Default value Description
warning_threshold NO CPU warning threshold
alarm_threshold NO CPU alarm threshold
history_threshold NO Number of day to collect statistics for.

Job Summary

Detailed Monitoring Aspects

The job tracks several server properties, which are checked regularly:

Historical Data Management

Further, this job manages historical data through the creation and maintenance of tables that store such information:

Alerting and Reports

Based on the performance metrics:

Predefined threshold values allow the job to transition from normal monitoring to alerting status, triggering notifications for administrators to take potential corrective actions.

Reporting Mechanisms

The job includes an XML configuration setup for dbWatch server which allows:

Feature Description
CPU Utilization History Visual representation of CPU load over time
Memory Utilization Report Tracks how memory usage varies
Thread Activity Report Monitors thread usage and pool sizes
Server Activity Details Summarizes server operations within the last registered period

These reports are important for providing a concise overview of the system’s health and activity, which helps in decision-making regarding server management and scaling.