Search
Related topics are listed below.
Adding a SQLServer Instance
Using Control Center » Instance management » Adding a SQLServer Instance
How to get here To open the “Add Instance Wizard”, click on the “Plus (+)” sign on the bottom left of the dbWatch Client. Select Instance Type and Input Connection Details Specify the host and port number. dbWatch will attempt to…
Adding SQLServer instances with kerberos
Using Control Center » Instance management » Adding a SQLServer Instance » Adding SQLServer instances with kerberos
Using the kerberos authentication option requires some additional setup. We need dbwatch user added to the domain: First we create a dbwatch user that is a normal domain user. We set a passord, and make sure it dont expire. And we must add this user to the…
Jobs for MariaDB
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MariaDB
Control Center Jobs Description Availability DBMS uptime Collects uptime statistics in the database. Aborted connects alert Collects uptime statistics in the database. Maximum connections alert Collects uptime…
Jobs for PostgreSQL
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for PostgreSQL
Control Center Jobs Description Availability Backup check – pg_dump Checks that there exists an up to date backup file. Backup check – WAL Checks that the WAL files have been backed up. DBMS…
Jobs for Sybase
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Sybase
Control Center Jobs Description Availability Database backup Checks backup status of all databases. Database status Checks status of all databases defined on the system. The following incidents triggers a warning or an…
Jobs for Oracle
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle
Control Center Jobs Description Availability Alert log check This check reads and looks for errors in the database alert log. Alert log check This check reads and looks for errors in the database alert log. Alert…
Jobs for MySQL
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MySQL
Control Center Jobs Description Availability DBMS uptime Collects uptime statistics in the database. MySQL aborted connects Checking if there is many aborted connects MySQL max connections Checking if the system…
Editor for engine jobs
Customization » Monitoring » Editor for engine jobs
How to get here Example jobs We have some example jobs to make the development easier here. Edit Existing To edit an existing Task or Alert open the Task/Alert Editor by right clicking on any task or alert and select Edit task from the popup menu. Create new…
Blocking detector for RAC
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Blocking detector for RAC
Name: Blocking detector for RAC Platform: Oracle Category: Cluster and Replication Description: Checks if a session is waiting on a TX (transaction) lock. (RAC only) Long description: Task checks if a session is…
Memory session load for RAC
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Memory session load for RAC
Name: Memory session load for RAC Platform: Oracle Category: Cluster and Replication Description: Records the load memory of RAC active sessions over time. Long description: Task records the load memory of RAC…
Jobs for MS SQL Server
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server
Control Center Jobs Description Availability Agent Jobs Check Checks whether there exists jobs on the SQL server which have not been executed, or have failed during execution. Agent Jobs Check for MS2000 Checks whether there…
Alert log check (java for 10g)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Alert log check (java for 10g)
Name: Alert log check (java) Platform: Oracle Category: Availability Description: This check reads and looks for errors in the database alert log. Uses embedded java to read files. Long description: This check…
Segment size status for old style tablespaces
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Segment size status for old style tablespaces
Name: Segment size status for old style tablespaces Platform: Oracle Category: Capacity Description: Checks segment storage definitions in tablespaces where extent management is not set to local. Long…
SQL Server Agent status
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » SQL Server Agent status
Name: SQL Server Agent status Platform: Sqlserver Category: Availability Description: Checks if the SQL Server Agent is running. Long description: This alert checks the master.dbo.sysprocesses table for the…
Object size collector (all databases)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Object size collector (all databases)
Name: Objects size collector (all databases) Platform: Sqlserver Category: Capacity Description: Collects table and index size information for the largest objects for all databases. Long description: Collects…
Program status
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Program status
Name: Program status Platform: Sqlserver Category: Availability Description: Checks for any program connected to the SQL Server by checking the program_name column in the master.dbo.sysprocesses table. Long…
Backup All transaction logs
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Backup All transaction logs
Name: Backup All transaction logs Platform: Sqlserver Category: Maintenance Description: Takes backup of all transaction logs for databases running in FULL recovery mode. Long description: Takes backup of all…
Truncate transaction log
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Truncate transaction log
Name: Truncate transaction log Platform: Sqlserver Category: Capacity Description: This procedure truncates the transaction log for the dbWatch database. Long description: This procedure truncates the…
File IO statistics
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » File IO statistics
Name: File IO statistics Platform: Sqlserver Category: Performance Description: Collects I/O statistics for data and log files. Long description: Collects I/O statistics for data and log files baseed on dynamic…
Data file size check
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Data file size check
Name: Data file size check Platform: Sqlserver Category: Capacity Description: Checks the remaining space for all databases where the data files are set with limited growth rate (max size not unlimited). Long…
Replica states
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Replica states
Name: Replica states Platform: Sqlserver Category: Cluster and Replication Description: Checks role state for all alwayson groups. Long description: Version: 1.3 Default…
Framework (MS2000)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Framework (MS2000)
Name: Framework Platform: Sqlserver Category: Maintenance Description: dbWatch engine framework task (for internal use only). Used for patching or upgrading of dbWatch engine framework. Long…
Missing database log backup (noschema)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Missing database log backup (noschema)
Name: Missing database log backup Platform: Sqlserver Category: Availability Description: This alert checks if the instance has been restarted since the last check Long description: This job checks for each…
SQL statistics
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » SQL statistics
Name: SQL statistics Platform: Sqlserver Category: Performance Description: Collects performance statistics for the SQL statements. Long description: Collects performance statistics for cached query plans from…
Framework
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Framework
Name: Framework Platform: Sqlserver Category: Maintenance Description: dbWatch engine framework job (for internal use only). Used for patching or upgrading of dbWatch engine framework. Long…
Instance memory usage (MS2005 / MS2008)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Instance memory usage (MS2005 / MS2008)
Name: Instance memory usage Platform: Sqlserver Category: Performance Description: Collects total memory usage and data cache memory usage for SQL Server instance. This dbWatch task can be configured to automatically reduce…
Database growth rate (detailed)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Database growth rate (detailed)
Name: Database growth rate (detailed) Platform: Sqlserver Category: Capacity Description: Collects size of database files (including transaction log files) to visualize the growth rate for the largest…
Data cache memory usage (MS2005 / MS2008)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Data cache memory usage (MS2005 / MS2008)
Name: Data cache memory usage Platform: Sqlserver Category: Performance Description: Collects data cache memory usage per database (for top 10 databases). Long…
Version store space usage (tempdb)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Version store space usage (tempdb)
Name: Version store space usage (tempdb) Platform: Sqlserver Category: Capacity Description: Checks total space in tempdb used by version store records for each database. Long description: Checks total space in…
Missing database backup (noschema)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Missing database backup (noschema)
Name: Missing database backup Platform: Sqlserver Category: Availability Description: This alert checks if the instance has been restarted since the last check Long description: This job checks for each database…
MS SQL Server patch status
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » MS SQL Server patch status
Name: MS SQL Server patch status Platform: Sqlserver Category: Compliance Description: Checks latest updates for Microsoft SQL Server. Long description: Checks latest updates for Microsoft SQL…
Collation check
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Collation check
Name: Collation check Platform: Sqlserver Category: Availability Description: Checks if there is a collation conflict with temp tables and table variables. Long description: You may get a collation conflict when…
Index usage statistics (all databases)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Index usage statistics (all databases)
Name: Index usage statistics (all databases) Platform: Sqlserver Category: Performance Description: This procedure collects statistics from sys.dm_db_index_usage_stats performance view which gives information on how an…
Instance error log
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Instance error log
Name: Instance error log Platform: Sqlserver Category: Availability Description: Reads and checks the Instance error log file by using the sp_readerrorlog stored procedure. Long description: The sp_readerrorlog…
Data file size check (MS2000)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Data file size check (MS2000)
Name: Data file size check Platform: Sqlserver Category: Capacity Description: Checks the remaining space for all databases where the data files are set with limited growth rate (max size not unlimited). Long…
Data cache memory usage
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Data cache memory usage
Name: Data cache memory usage Platform: Sqlserver Category: Performance Description: Collects data cache memory usage per database (for top 10 databases). Long description: Collects data cache memory usage per…
Database backup (system databases)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Database backup (system databases)
Name: Database backup (system databases) Platform: Sqlserver Category: Availability Description: This procedure analyzes the FULL backup statistics for the system databases (master, model and msdb) using data from the…
Database statistics
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Database statistics
Name: Database statistics Platform: Sqlserver Category: Availability Description: This procedure gathers statistics per database. Long description: Version: 1.8 Default schedule: 0 5 6…
Database growth rate (detailed) (MS2000)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Database growth rate (detailed) (MS2000)
Name: Database growth rate (detailed) Platform: Sqlserver Category: Capacity Description: Collects size of all database files (including transaction log files) to visualize the growth rate for all databases. Long…
Database growth rate (aggregated) (MS2000)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Database growth rate (aggregated) (MS2000)
Name: Database growth rate (aggregated) Platform: Sqlserver Category: Capacity Description: Collects size of all database files (including transaction log files) to visualize the growth rate for all databases. Long…
Database growth rate (aggregated)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Database growth rate (aggregated)
Name: Database growth rate (aggregated) Platform: Sqlserver Category: Capacity Description: Collects size of all database files (including transaction log files) to visualize the growth rate for all databases. Long…
Instance memory usage
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Instance memory usage
Name: Instance memory usage Platform: Sqlserver Category: Performance Description: Collects total memory usage and data cache memory usage for SQL Server instance. This dbWatch task can be configured to automatically reduce…
Data hit ratio
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Data hit ratio
Name: Data hit ratio Platform: Sqlserver Category: Performance Description: Monitors the buffer cache hit ratio by extracting counter values from the master.dbo.sysperfinfo table for the counters ‘Buffer cache hit…
Health state
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Health state
Name: Health state Platform: Sqlserver Category: Cluster and Replication Description: Checks groups health state. Long description: Version: 1.2 Default…
Blocking detector
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Blocking detector
Name: Blocking detector Platform: Sqlserver Category: Performance Description: Checks whether there exists blocked session. Long description: Version: 1.2 Default…
JDBC Properties
Using Control Center » Instance management » Instance Configuration » JDBC Properties
It is possible to set properties for the JDBC driver on specific instances. You can find this under “Advanced Driver Setup” when adding SQL instances or under “Edit parameters” in the JDBC panel in the Configure Instance dialog. The driver…
Replication status
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Replication status
Name: Replication status Platform: Sqlserver Category: Cluster and Replication Description: The following check provides general info in regards to any replication going on in a server. Long description: This…
Data file size check (noschema)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Data file size check (noschema)
Name: Data file size check Platform: Sqlserver Category: Capacity Description: This procedure collects space usage in all filegroups defined in each database. The undocumented ‘sp_MSforeachdb’ Stored Procedure…
Platforms supported
About dbWatch Control Center » Platforms supported
Platforms supported for the main product. Current release supports the following platforms, versions, and setups: On-premise support Supports* Express edition, Standard edition, Standard edition one, Standard edition two, and Enterprise edition of the following…
Database backup (SIMPLE)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Database backup (SIMPLE)
Name: Database backup (SIMPLE) Platform: Sqlserver Category: Availability Description: This procedure analyzes the backup statistics (type D) from the msdb.dbo.backupset table for databases in SIMPLE recovery model…
Database backup (system dbs)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Database backup (system dbs)
Name: Database backup (system dbs) Platform: Sqlserver Category: Availability Description: This procedure analyzed the system database backups statistics from msdb.dbo.backupset table. Long…
Backup All databases
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Backup All databases
Name: Backup All databases Platform: Sqlserver Category: Maintenance Description: Takes backup of all application and system databases. Long description: Takes backup of all application and system…
SQL Server performance counters
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » SQL Server performance counters
Name: SQL Server performance counters Platform: Sqlserver Category: Maintenance Description: Checks if SQL Server performance counters are missing. Long description: Version: 2 Default…
Restricted Enterprise edition features (MS2005)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Restricted Enterprise edition features (MS2005)
Name: Restricted Enterprise edition features 2005 Platform: Sqlserver Category: Availability Description: Checks if there are any restricted features in use (supported only by Enterprise or Developer SQL Server…
Restricted Enterprise edition features
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Restricted Enterprise edition features
Name: Restricted Enterprise edition features Platform: Sqlserver Category: Availability Description: Checks if there are any restricted features in use (supported only by Enterprise or Developer SQL Server…
Filegroups growth rate
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Filegroups growth rate
Name: Filegroups growth rate Platform: Sqlserver Category: Capacity Description: This procedure collects space usage for the largest filegroups defined in each database. The undocumented ‘sp_MSforeachdb’ Stored…
Auto growth event collector
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Auto growth event collector
Name: Auto growth event collector Platform: Sqlserver Category: Capacity Description: Collects statistics on how often an auto-growth event has occurred. Long…
Suspect pages
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Suspect pages
Name: Suspect pages Platform: Sqlserver Category: Maintenance Description: Monitors suspect pages statistics in suspect_pages table. Long description: This alert monitors suspect pages by parsing statistics…
Instance status
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Instance status
Name: Instance status Platform: Sqlserver Category: Availability Description: This alert checks if the instance has been restarted since the last check Long…
Instance error log (AWS)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Instance error log (AWS)
Name: Instance error log (AWS) Platform: Sqlserver Category: Availability Description: Reads and checks the Instance error log file by using the AWS rdsadmin.dbo.rds_read_error_log stored procedure. Long…
Check database recovery mode
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Check database recovery mode
Name: Check database recovery mode Platform: Sqlserver Category: Availability Description: Checks if all databases are running in FULL or SIMPLE recovery mode. Long description: Checks if all databases are…
dbWatch engine alert
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » dbWatch engine alert
Name: dbWatch engine alert Platform: Sqlserver Category: Internal Internal Description: This procedure gathers statistics per database. Long description: This alert returns warning/alarm if there are several…
Check database and server principal mapping
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Check database and server principal mapping
Name: Check database and server principal mapping Platform: Sqlserver Category: Maintenance Description: Checks if the database owner (dbo) is maped into any Server Login (server principal). Long…
Database Server uptime (MS2000)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Database Server uptime (MS2000)
Name: Database Server uptime Platform: Sqlserver Category: Availability Description: Collects database server uptime statistics. Long description: Version: 1.9 Default schedule: * *…
Database status (MS2000)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Database status (MS2000)
Name: Database status Platform: Sqlserver Category: Availability Description: Checks if all databases have status ONLINE Long description: Version: 2 Default schedule: 0 * *…
Database log backup
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Database log backup
Name: Database Log backup Platform: Sqlserver Category: Availability Description: This procedure checks the database transaction log backups from the msdb.dbo.backupset table (excluding system databases: master, model and…
External fragmentation (all databases)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » External fragmentation (all databases)
Name: External fragmentation (all databases) Platform: Sqlserver Category: Maintenance Description: External (logical) fragmentation occurs when an index leaf page is not in logical order. It occurs when the logical…
Lazy writer and checkpoint statistics
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Lazy writer and checkpoint statistics
Name: Lazy writer and Checkpoint statistics Platform: Sqlserver Category: Performance Description: Monitors ‘Checkpoint pages/sec’, ‘Lazy writes/sec’ and ‘Page life expectancy’ by…
Database server uptime (MS2005)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Database server uptime (MS2005)
Name: Database Server uptime Platform: Sqlserver Category: Availability Description: Collects database server uptime statistics. Long description: Version: 2.2 Default schedule: * *…
Instance error log file size check
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Instance error log file size check
Name: Instance error log file size check Platform: Sqlserver Category: Capacity Description: Checks the size og the Instance error log file by using the extended stored procedure xp_cmdshell. Long…
Blocking statistics
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Blocking statistics
Name: Blocking statistics Platform: Sqlserver Category: Performance Description: Checks whether there exists any blocked sessions. Long description: Version: 1.7 Default…
dbWatch Server activity alert
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » dbWatch Server activity alert
Name: dbWatch Server activity alert Platform: Sqlserver Category: Internal Internal Description: This procedure gathers statistics per database. Long description: This alert returns warning/alarm if the dbWatch…
Agent Jobs Check (MS2000)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Agent Jobs Check (MS2000)
Name: Agent Jobs Check (MS2000) Platform: Sqlserver Category: Availability Description: Checks whether there exists jobs on the SQL server which have not been executed or have failed during execution. Long…
Disk space check
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Disk space check
Name: Disk space check Platform: Sqlserver Category: Capacity Description: Checks the amount of free space on the available disk drives. Long description: Checks the amount of free space on the available disk…
AlwaysOn transaction log backup alert
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » AlwaysOn transaction log backup alert
Name: AlwaysOn transaction log backup alert Platform: Sqlserver Category: Cluster and Replication Description: Checks the status of each member node of the current WSFC cluster based on Dynamic Management Views…
High activity monitor (MS2005)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » High activity monitor (MS2005)
Name: High activity monitor Platform: Sqlserver Category: Performance Description: Collects SQL instance CPU usage, CPU usage of other processes, logical and physical reads, and active processes count on the SQL Server…
Transactions log flushed bytes load (MS2000)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Transactions log flushed bytes load (MS2000)
Name: Transactions log flushed bytes load Platform: Sqlserver Category: Performance Description: Shows bytes flushed to transaction logs over time, total and top 5 databases. Long description: Shows bytes…
Database backup (noschema)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Database backup (noschema)
Name: Database backup Platform: Sqlserver Category: Availability Description: This alert checks if the instance has been restarted since the last check Long description: This job checks the backup statistics…
Query store status
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Query store status
Name: Query Store status Platform: Sqlserver Category: Capacity Description: Checks Query Store space usage in every database where it is enabled. Long description: Checks Query Store space usage in every…
Database backup (MS2000)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Database backup (MS2000)
Name: Database backup (2000) Platform: Sqlserver Category: Availability Description: This procedure analyzed the backup statistics from msdb.dbo.backupset table (excluding system databases: master, model and…
Database server uptime
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Database server uptime
Name: Database Server uptime Platform: Sqlserver Category: Availability Description: Collects database server uptime statistics. Long description: Version: 2.2 Default schedule: * *…
Member state
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Member state
Name: Member state Platform: Sqlserver Category: Cluster and Replication Description: Checks the status of each member node of the current WSFC cluster based on Dynamic Management Views…
Log shipping monitor (secondary)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Log shipping monitor (secondary)
Name: Log shipping monitor (secondary) Platform: Sqlserver Category: Cluster and Replication Description: Monitor the secondary database in each log shipping configuration. Long description: Monitor the…
Test DML-DDL performance
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Test DML-DDL performance
Name: Test DML-DDL performance Platform: Sqlserver Category: Performance Description: Runs performance test on the database. The procedure executes SELECT, INSERT, UPDATE, DELETE (and TRUNCATE) statements on the test…
Databases NOT IN USE collector
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Databases NOT IN USE collector
Name: Databases NOT IN USE collector Platform: Sqlserver Category: Capacity Description: Collects information about most inactive databases. Long description: Version: 2 Default…
Transactions load
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Transactions load
Name: Transactions load Platform: Sqlserver Category: Performance Description: Shows the transactions load over time, total and top 5 databases. Long description: Shows the transactions load over time, total and…
Update statistics
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Update statistics
Name: Update statistics Platform: Sqlserver Category: Maintenance Description: Update statistics in all (non system) databases. Long description: Version: 1.2 Default schedule: 15 22 3…
Instance memory check
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Instance memory check
Name: Instance memory check Platform: Sqlserver Category: Performance Description: This job checks the target memory value of the SQL Server instance, and gives a warning/alarm if the instance is not able to allocate a…
Report Server status
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Report Server status
Name: Report Server status Platform: Sqlserver Category: Availability Description: Checks if the program ‘Report Server’ is connected to the SQL Server by checking the program_name column in the…
Database status (noschema)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Database status (noschema)
Name: Database status Platform: Sqlserver Category: Availability Description: This alert checks if the instance has been restarted since the last check Long description: Version: 2 Default…
Agent Jobs Check
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Agent Jobs Check
Name: Agent Jobs Check Platform: Sqlserver Category: Availability Description: Checks whether there exists jobs on the SQL server which have not been executed, or have failed during execution. Long description: …
Database disk space usage
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Database disk space usage
Name: Database disk space usage Platform: Sqlserver Category: Capacity Description: Checks free space on drives where all data and transaction log files are defined. Drives where no data files exist will be…
Restricted Enterprise edition features (MS2000)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Restricted Enterprise edition features (MS2000)
Name: Restricted Enterprise edition features (2000) Platform: Sqlserver Category: Availability Description: Checks if there are any restricted features in use (supported only by Enterprise or Developer SQL Server…
AlwaysOn database backup alert
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » AlwaysOn database backup alert
Name: AlwaysOn database backup alert Platform: Sqlserver Category: Cluster and Replication Description: Checks the status of each member node of the current WSFC cluster based on Dynamic Management Views…
Rebuild indexes in table
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Rebuild indexes in table
Name: Rebuld indexes in table Platform: Sqlserver Category: Maintenance Description: Rebuilds fragmented indexes in all tables listed in the ‘table list’ parameter. Long description: Rebuilds…
Temporary database space usage
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Temporary database space usage
Name: Temporary database space usage Platform: Sqlserver Category: Capacity Description: Checks space usage in tempdb database, and collects statistics including size of data and transaction log files. Long…
Blocking detector (noschema)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Blocking detector (noschema)
Name: Blocking detector Platform: Sqlserver Category: Performance Description: This task collects the size of memory objects that are currently allocated by the SQL Server Long description: Checks whether there…
Database log backup (noschema)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Database log backup (noschema)
Name: Database log backup Platform: Sqlserver Category: Availability Description: This alert checks if the instance has been restarted since the last check Long description: This job checks the transaction log…
Database mirroring
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Database mirroring
Name: Database mirroring Platform: Sqlserver Category: Cluster and Replication Description: Checks state information of all mirrored databases. Long description: Checks state information of all mirrored…
Session load
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Session load
Name: Database session load Platform: Sqlserver Category: Performance Description: Shows the number of connections over time per database, host and application. Long description: Each time the procedure is…