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 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 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…
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 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 Agresso (part of the Agresso Application Package) Agresso reports queue Monitors and checks pending or running reports. Returns warning or alarm if the elapsed time exceeds defined…
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…
Scan for startup procs
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Scan for startup procs
Name: Scan for startup procs Platform: Sqlserver Category: Security Premium package: Security and compliance package Description: Check if MS SQL Server automatically scan and run all stored procedures that are…
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 Agresso (part of Agresso Application Package) Agresso report queue Monitors and checks pending or running reports. Returns warning or alarm if the elapsed time exceeds defined…
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…
Supported Web Browsers for dbWatch Dashboard
Customization » Web server » Supported Web Browsers for dbWatch Dashboard
As of the current version, dbWatch Dashboard supports the following web browsers: Google Chrome Microsoft Edge Firefox Why These Browsers? Our focus on Google Chrome and Microsoft Edge is driven by several factors: Advanced Features and Standards These…
Configuring email extension for Service Now
Customization » Extensions and 3rd party integrations » Email and SMS » Configuring email extension for Service Now
Integration with Servicenow In this example we will configure dbWatch and Servicenow so that alarms from dbWatch, can create incidents in Servicenow. To integrate the alerts from dbWatch with Servicenow incident creation, there are two parts that needs to be setup.…
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…
Management on SQL Server
Using Control Center » Management » Management on SQL Server
When opening the management module in its initial state, you get the status dashboard: This will give an overview of the system, displaying some instance information, the largest databases, logical reads, session load, and memory usage. When a graph indicates…
[Database name] (database server)
Using Control Center » Management » Management on SQL Server » Configuration » Uptime statistics » [Database name] (database server)
This gives an overview of up and down periods for the database server. You can right-click on the screen to switch between different ways to display uptime: Like uptime per week: ← Uptime statistics / (instance) →
Maintenance periods
Using Control Center » Management » Management on SQL Server » Configuration » Uptime statistics » Maintenance periods
This is where you can add maintenance periods to correct the uptime report for known scheduled maintenance periods that should not count as part of the report. Right click on the maintenance periods to create a new known maintenance period. This allows you fine…
Uptime statistics
Using Control Center » Management » Management on SQL Server » Configuration » Uptime statistics
Control Center provides uptime statistics reports, and this is the interface to look at uptime periods for an instance and add scheduled maintenance periods that will be taken into consideration when uptime statistics is generated for this report. ← Registry…
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…
Sessions history
Using Control Center » Management » Management on SQL Server » Sessions » Sessions history
This view shows historic statistics for sessions on this instance. ← Sessions / Sessions performance →
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…
SQL performance
Using Control Center » Management » Management on SQL Server » SQL performance
SQL performance is an extra cost module, that might not be available if your license has not enabled it. For more details look at the documentation for this module here ← Maintenance periods / Internal repository →
[Instance name] (instance)
Using Control Center » Management » Management on SQL Server » Configuration » Uptime statistics » [Database name] (database server) » [Instance name] (instance)
This gives an overview of when the database instance has been up or down. ← [Database name] (database server) / Maintenance periods →
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…
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…
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…
Sessions performance
Using Control Center » Management » Management on SQL Server » Sessions performance
The Sessions performance view is part of the SQL performance package, which is an extra cost module, that might not be available if your license has not enabled it. For more details look at the documentation for this module here ← Sessions history / Disk…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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 (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 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…
dbWatch alerts
Using Control Center » Management » Management on SQL Server » dbWatch alerts
dbWatch alerts is a list of monitoring jobs in the database in warning or alarm state for this database instance. Example: This is handy so you know you are working on the right database instance when you are correcting issues. You can interact with the…
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 (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…
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…
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 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…
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…
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…
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 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 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…
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…
Security
Using Control Center » Management » Management on SQL Server » Security
Security is where you configure users and privileges. ← Databases / SQL Server Agent →
Active processes
Using Control Center » Management » Management on SQL Server » Server activity » Active processes
Active processes are the current running SQL statements along with statistics. ← Locks / Performance test →
Configuration
Using Control Center » Management » Management on SQL Server » Configuration
Configuration gives an overview of the current setup of the database instance, including parameters and uptime statistics. ← dbWatch alerts / Parameters →
SQL Server Error logs
Using Control Center » Management » Management on SQL Server » SQL Server Error logs
This view allows you to look at the SQL Server error logs and search and filter data. ← Backups / Databases →
Databases
Using Control Center » Management » Management on SQL Server » Databases
This view allows you to drill down into each database and its underlying data. ← SQL Server Error logs / Security →
Parameters
Using Control Center » Management » Management on SQL Server » Configuration » Parameters
First the basic parameters are showed. You can right_click on any of these to configure new values. ← Configuration / Advanced dynamic parameters →
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 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…
Performance test
Using Control Center » Management » Management on SQL Server » Server activity » Performance test
Performance test displays statistics gathered from the DML performance test job that runs a performance test on the database instance. ← Active processes / Sessions →
Registry parameters
Using Control Center » Management » Management on SQL Server » Configuration » Registry parameters
Registry parameters are primarily directory defaults that are saved in the registry. You can change these by right-clicking and choosing configure. ← Advanced static parameters / Uptime statistics →
Audit
Using Control Center » Management » Management on SQL Server » Audit
Audit is where you control what is being audited on the SQL Server ← Operating System Manager / SQL Worksheet →
Advanced dynamic parameters
Using Control Center » Management » Management on SQL Server » Configuration » Parameters » Advanced dynamic parameters
Advanced dynamic parameters are more advanced, but they can be configured by right-clicking and choosing configure. They take effect immediately. ← Parameters / Advanced static parameters →
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…
Agresso framework
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Agresso framework
Name: Agresso framework Platform: Sqlserver Category: Agresso Premium package: Agresso application package Description: Checks whether there is an installation of the agresso application in any of the…
Internal repository
Using Control Center » Management » Management on SQL Server » SQL performance » Internal repository
The internal repository is a dashboard to see how the gathering process of SQL performance data is working, finetune and analyze load and statistics. ← SQL performance / Server activity →
Backups
Using Control Center » Management » Management on SQL Server » Backups
Backups is where you can drill down into any details about the backups on this SQL Server ← Disk and Memory usage / SQL Server Error logs →
SQL Server Agent
Using Control Center » Management » Management on SQL Server » SQL Server Agent
SQL Server agent allows you to check the status of the agent, look into agent jobs and its statistics, and create new agent jobs. ← Security / Operating System Manager →
Operating System Manager
Using Control Center » Management » Management on SQL Server » Operating System Manager
Operating System Manager allows some interaction with the OS underneath, such as a CMD shell and file browser. ← SQL Server Agent / Audit →
Advanced static parameters
Using Control Center » Management » Management on SQL Server » Configuration » Parameters » Advanced static parameters
Advanced static parameters will need an instance restart to take effect. You can configure these by right-clicking on the parameter and choose configure. ← Advanced dynamic parameters / Registry parameters →
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…
Integration with SSMS
Installing and using premium packages » SQL Performance package » Using SQL Performance package on SQL Server » Integration with SSMS
When analyzing a SQL statement, the choice “Show query plan (using SSMS)” appears on SQL Server. This is for opening a query plan in SQL Server Management Studio. Clicking on this will not open anything, if it is not setup correctly. There is a monitor.xml…
Using OS Authentication
Using Control Center » Instance management » Adding a SQLServer Instance » Using OS Authentication
When connecting to Microsoft SQL Server instances it is possible to login with Windows Authentication (called OS Authentication in dbWatch). The accout used is the same account as the dbWatch Control Center service runs as. Per default the dbWatch Control Center…
Locks
Using Control Center » Management » Management on SQL Server » Server activity » Locks
Locks view current locks in the database and statistics. There is also a menu to get more session details. ← Blocking sessions history / Active processes →
Agent error log
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Agent error log
Name: Agent error log Platform: Sqlserver Category: Availability Description: Reads and checks the Agent error log file by using the sp_readerrorlog stored procedure. Long description: The sp_readerrorlog stored…
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 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: * *…
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…
Server activity
Using Control Center » Management » Management on SQL Server » Server activity
Server activity is a dashboard to get an overview of current sessions and statistics from multiple performance counters viewed together. There is also a menu to kill sessions or view last sql statements. ← Internal repository / Blocking sessions…
Management
Using Control Center » Management
In this section, we’ll be familiarized with how the Management Module works. Examples in this documentation are from Microsoft SQL Server, but this is available on all platforms, however, contents are platform and license dependent. When opening the management…
Asymmetric Key size
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Asymmetric Key size
Name: Asymmetric Key size Platform: Sqlserver Category: Security Premium package: Security and compliance package Description: Checks that at least a 2048-bit encryption key size is used for asymmetric keys.…
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: * *…
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: * *…
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…
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…
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 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…
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…