Search
Related topics are listed below.
SQL Worksheet
Using Control Center » Management » Management on SQL Server » SQL Worksheet
SQL Worksheet allows for direct SQL commands on the database instance. ← Audit / Worksheet →
Worksheet
Using Control Center » Worksheet
One of the truly unique features of dbWatch is its integrated SQL Worksheet, which, although easy to use has sophisticated applications, including cross-database queries. The SQL Worksheet is meant to give responsible DBA’s the ability to locate any problems and…
SQL waits
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » SQL waits
Name: SQL waits Platform: Oracle Category: Performance Description: Collects SQL wait statistics. Long description: Task collects SQL wait statistics. Version: 2.8 Default schedule: 50…
SQL statistics
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » SQL statistics
Name: SQL statistics Platform: Oracle Category: Performance Description: Collects SQL statements statistics from V$SQLAREA and V$SQL_PLAN dynamic performance views. Long description: Collects SQL statements…
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…
SQL statistics
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for PostgreSQL » SQL statistics
Name: SQL statistics Platform: Postgres Category: Performance Description: Collects performance statistics for the SQL statements. Long description: Collects performance statistics for SQL statements from…
SQL statistics
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for PostgreSQL » SQL statistics
Name: SQL statistics Platform: Postgres Category: Performance Description: Collects performance statistics for the SQL statements. Long description: Collects performance statistics for SQL statements from…
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 →
Using SQL Performance package on SQL Server
Installing and using premium packages » SQL Performance package » Using SQL Performance package on SQL Server
Navigating to the SQL Performance package dashboard Once the SQL statistics job is installed and have collected data, you can navigate to the dashboard. It is located in the management interface for that database instance. The pictures and descriptions are from SQL…
SQL statistics (RDS)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » SQL statistics (RDS)
Name: SQL statistics Platform: Oracle Category: Performance Description: Collects SQL statements statistics from V$SQLAREA and V$SQL_PLAN dynamic performance views. Long description: Collects SQL statements…
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 →
SQL statistics (CDB)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » SQL statistics (CDB)
Name: SQL statistics Platform: Oracle Category: Performance Extra cost package: SQL Performance package Description: Collects SQL statements statistics (for container database) from V$SQLAREA and V$SQL_PLAN…
SQL statistics (PDB)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » SQL statistics (PDB)
Name: SQL statistics Platform: Oracle Category: Performance Extra cost package: SQL Performance package Description: Collects SQL statements statistics (for pluggable database) from V$SQLAREA and V$SQL_PLAN…
SQL Performance package
Installing and using premium packages » SQL Performance package
SQL Performance package SQL Performance module is an optional extra cost module in dbWatch Control Center that allows for historical monitoring and analysis of SQL Statements in the database instance. Currently supported platforms: MS SQL Server 2014 and…
Main procedure SQL Server
Customization » Monitoring » Editor for engine jobs » Implementation » Main procedure SQL Server
We will use the “Test alert” as example code, as its only purpose is to generate alarms and warnings, but uses many underlying functions. We go through it in steps, and include the full routine at the end. For historical reasons some code will refer to…
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…
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…
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…
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 →
Installation of SQL Performance package
Installing and using premium packages » SQL Performance package » Installation of SQL Performance package
Requirements for installation dbWatch Control Center release 2022-09-29 / 501 or newer License that includes SQL Performance module. It can be as the separate “SQL Performance Package” license or as part of a larger licence package. It is included in…
Database network statistics (SQL*NET)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Database network statistics (SQL*NET)
Name: Database network statistics (SQL*NET) Platform: Oracle Category: Performance Description: Checks database network SQL*NET statistics. Long description: Task checks database network SQL*NET…
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…
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…
Using SQL Performance package on Oracle
Installing and using premium packages » SQL Performance package » Using SQL Performance package on Oracle
Navigating to the SQL Performance package dashboard Once the SQL statistics job is installed and have collected data, you can navigate to the dashboard. It is located in the management interface for that database instance. The pictures and descriptions are from…
Using SQL Performance package on PostgreSQL
Installing and using premium packages » SQL Performance package » Using SQL Performance package on PostgreSQL
Navigating to the SQL Performance package dashboard Once the SQL statistics job is installed and have collected data, you can navigate to the dashboard. It is located in the management interface for that database instance. The pictures and descriptions are from…
Troubleshooting issues in SQL Performance package
Installing and using premium packages » SQL Performance package » Repository management and monitoring » Troubleshooting issues in SQL Performance package
Graph issues with monitoring has been switched off If for some reason dbWatch Control Center has not been connected to a database instance running SQL Performance package for an extended time, you can get odd statistics errors in the graphs. It will look like a linear…
Using SQL Performance package on MySQL
Installing and using premium packages » SQL Performance package » Using SQL Performance package on MySQL
Navigating to the SQL Performance package dashboard Once the SQL statistics job is installed and have collected data, you can navigate to the dashboard. It is located in the management interface for that database instance. The pictures and descriptions are from…
Security and Compliance package on SQL Server
Installing and using premium packages » Security and Compliance package » Security and Compliance package on SQL Server
The Security and Compliance package The Security and Compliance package provides a detailed evaluation of your Microsoft SQL Server’s security and compliance, managed via dbWatch Control Center. It offers in-depth insights into your server’s security and…
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 →
The modules of Control Center
Using Control Center » The modules of Control Center
We have seven default modules available when you start dbWatch Control Center. This article will only introduce you to what these instances are and give a brief description of them. You need to be familiar with the navigation tree to better understand how these modules…
Sensitive Data Transmitted
Advanced Topics » Product Security » Sensitive Data Transmitted
Sensitive Data Transmitted dbWatch Control Center will, by its nature log into database instances and run queries on the database instances it manages. Key data accessed is primarily data related to statistics on the behavior of the database instance, and not actual…
Architecture
Product Overview » Architecture
Architecture components The dbWatch installation consists of three components: dbWatch Monitor/Client serves as the front-end GUI dbWatch Server is the core business logic and central hub of the system dbWatch Framework contains stored objects in the registered…
Autodiscover
Using Control Center » Autodiscover
Discovering Database Instances The dbWatch Autodiscover feature scans your network and locates database instances that are available. You will find the Autodiscover feature under the “Autodiscover” tab on the left-most side of the dbWatch Monitor. In…
Release notes
About dbWatch Control Center » Release notes
dbWatch Control Center (2024-11-26) Download New features DBW – Bulk setting of SQL Worksheet authentications DBW – SQL Worksheet query timeout parameter DBW – AD integration now handles LDAP Signing DBW – CCC can now connect to non DC…
Repository management and monitoring
Installing and using premium packages » SQL Performance package » Repository management and monitoring
Introduction The SQL Performance package creates tables in the dbWatch schema/database on each database instance where the SQL Statistics job is installed and scheduled. The process combines two parts of dbWatch Control Center. The monitoring is used to schedule the…
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…
Security and Compliance package
Installing and using premium packages » Security and Compliance package
Security and Compliance package The Security and Compliance package is an optional extra cost module in dbWatch Control Center that allows automated detection and reporting on security and compliance-related issues where database instances are not conforming to best…
High activity monitor
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » High activity monitor
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…
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…
Category chart
Customization » Management » Result types » Graphical » Category chart
A catagory chart example The specification for this chart GRAPHICAL SELECT top 10 case when len(DB.name) > 30 then substring(DB.name,1,30)+'_DBID_' +cast(DB.database_id as varchar(4)) +' (alias)' else DB.name end AS "Database name", (SELECT…
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…
Compliance
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by category » Compliance
Jobs in the Compliance category Control Center Jobs Description MS SQL Server Optional MS SQL Server patch status Checks latest updates for Microsoft 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…
Filegroups growth rate (MS2000)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Filegroups growth rate (MS2000)
Name: Filegroups growth rate Platform: Sqlserver Category: Capacity Description: This procedure collects space usage in all filegroups defined in each database. The undocumented ‘sp_MSforeachdb’ Stored Procedure…
Pie chart
Customization » Management » Result types » Graphical » Pie chart
Pie chart example The specification for this chart select top 10 'type' = replace(A.type, 'MEMOBJ_', ''), 'value' = A.value from ( SELECT type, SUM (cast((pages_in_bytes/1024) as int) )/1024 as "value" from master.sys.dm_os_memory_objects group by…
Line chart
Customization » Management » Result types » Graphical » Line chart
A line chart example The specification for this chart: select (SELECT cntr_value FROM sys.dm_os_performance_counters where counter_name = 'Index Searches/sec') as "Index Scans", (SELECT cntr_value FROM sys.dm_os_performance_counters where counter_name…
Hide Instance
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Hide Instance
Name: Hide Instance Platform: Sqlserver Category: Security Premium package: Security and compliance package Description: Checks if the instance is hidden (not exposed by SQL Browser). Long…
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…
Unit4 Agresso
Advanced Topics » Application Modules » Unit4 Agresso
Installation guide for Microsoft SQL Server and Oracle platforms The dbWatch Agresso Module is based on the dbWatch Engine Framework and can be installed during the initial installation of the dbWatch Framework. If the MS SQL Server or Oracle instance where the…
Item active
Customization » Management » Item active
You can hide or disable elements (typically nodes or menu items) by using the item-active tag You can specify multiple item-active tags, and all of them have to resolve to “active” in order for the element to be classified as active. The item-active tag…
Category line chart
Customization » Management » Result types » Graphical » Category line chart
A category line chart example The specification for this chart SELECT rtrim(ltrim(instance_name)) "Type", cntr_value "Value" FROM sys.dm_os_performance_counters where counter_name like 'Lock Requests/sec%' and instance_name in ( select top 6…
Windows BUILTIN groups
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Windows BUILTIN groups
Name: Windows BUILTIN groups Platform: Sqlserver Category: Security Premium package: Security and compliance package Description: Checks that Windows BUILTIN groups are not SQL Logins. Long…
Windows LOCAL groups
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Windows LOCAL groups
Name: Windows LOCAL groups Platform: Sqlserver Category: Security Premium package: Security and compliance package Description: Checks that Windows LOCAL groups are not SQL Logins. Long…
Login audit setting
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Login audit setting
Name: Login audit setting Platform: Sqlserver Category: Security Premium package: Security and compliance package Description: Checks if the SQL Server login audit is set to value ‘2’ (none = 0,…
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…
Disk space check (noschema)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Disk space check (noschema)
Name: Disk space check Platform: Sqlserver Category: Capacity Description: This procedure collects space usage in all filegroups defined in each database. The undocumented ‘sp_MSforeachdb’ Stored Procedure is…
Server memory statistics
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Server memory statistics
Name: Server memory statistics Platform: Sqlserver Category: Performance Description: This tasks collects statistics from the sys.dm_os_sys_info performance view about the memory resources available to and consumed by the…
Installing and using premium packages
Installing and using premium packages
Premium packages dbWatch Control Center also provides additional premium packages to cover specific areas. They may be specific only to one or a few of the platforms supported by dbWatch Control Center. More details are found on the pages specific to the package.…
Stacked area chart
Customization » Management » Result types » Graphical » Stacked area chart
Here is an example of a stacked area chart showing the relationship between active and inactive sessions over time. The specification for this chart: select number_of_processes_active as "Active", number_of_processes_total - number_of_processes_active as…
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 →
Transaction log space usage (noschema)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Transaction log space usage (noschema)
Name: Transaction log space usage Platform: Sqlserver Category: Capacity Description: This procedure collects space usage in all filegroups defined in each database. The undocumented ‘sp_MSforeachdb’ Stored…
Cycle error log
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Cycle error log
Name: Cycle error log Platform: Sqlserver Category: Maintenance Description: This task cycle MS SQL Server error log and Agent error log files. Long description: By default, there are seven SQL Server error logs…
CLR Enabled
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » CLR Enabled
Name: CLR Enabled Platform: Sqlserver Category: Security Premium package: Security and compliance package Description: Checks if the assemblies can be run by SQL Server. Long description: Checks if…
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…
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…
Orphaned database users
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Orphaned database users
Name: Orphaned database users Platform: Sqlserver Category: Security Premium package: Security and compliance package Description: Checks if there are orphaned database users (users for which the corresponding…
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…
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…
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…
Instance memory check (noschema)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Instance memory check (noschema)
Name: Instance memory check Platform: Sqlserver Category: Performance Description: This task collects the size of memory objects that are currently allocated by the SQL Server Long description: The alert checks…
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: …
Issues and troubleshooting
Troubleshooting Guide » Issues and troubleshooting
High CPU usage on database Occasionally when investigating resource-consuming SQL statements running on your system, you may find that some of them belong to the dbWatch application. For example, a SQL statement that has the highest value of spent CPU time. In most…
Database disk capacity (noschema)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Database disk capacity (noschema)
Name: Database disk capacity Platform: Sqlserver Category: Capacity Description: This procedure collects space usage in all filegroups defined in each database. The undocumented ‘sp_MSforeachdb’ Stored Procedure…
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…
Memory objects statistics
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Memory objects statistics
Name: Memory objects statistics Platform: Sqlserver Category: Performance Description: This task collects the size of memory objects that are currently allocated by the SQL Server Long description: This task…
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…
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…
Default trace enabled
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Default trace enabled
Name: Default trace enabled Platform: Sqlserver Category: Security Premium package: Security and compliance package Description: Checks that ‘Default Trace Enabled’ server configuration option is set…
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…
Password expiration (sysadmin)
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Password expiration (sysadmin)
Name: Password expiration (sysadmin) Platform: Sqlserver Category: Security Premium package: Security and compliance package Description: Checks that CHECK_EXPIRATION option is set to ‘ON’ for all…
Database Mail XPs
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Database Mail XPs
Name: Database Mail XPs Platform: Sqlserver Category: Security Premium package: Security and compliance package Description: Checks the ability to generate and transmit email messages from SQL Server.…
Agresso reports queue
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for Oracle » Agresso reports queue
Name: Agresso reports queue Platform: Oracle Category: Agresso Description: Monitors and checks pending or running reports. Returns warning or alarm if the elapsed time exceeds defined threshold. Long…
Formatting table results
Customization » Management » Formatting table results
When you are displaying a table result based on an SQL query, you have the same render hints that are offered as part of dbwql. To use these hints, add a “result-table-format” tag to the result. select a, b, c from sometable TABLE …
Sessions per database
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Sessions per database
Name: Sessions per database Platform: Sqlserver Category: Performance Description: This task returns aggregate performance statistics based on sessions connected to the SQL Server instance. Long…
Security
Using Control Center » Management » Management on SQL Server » Security
Security is where you configure users and privileges. ← Databases / SQL Server Agent →
Performance
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by category » Performance
Jobs in the Performance category Control Center Jobs Description Oracle Blocking detector Checks if a session is waiting on a TX (transaction) lock. Buffer cache statistics Gets data cache statistics for buffer cache in…
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 →
Cached query statistics
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Cached query statistics
Name: Cached query statistics Platform: Sqlserver Category: Performance Description: This task returns aggregate performance statistics based on cached query plans in SQL Server. Long description: This task…
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 →
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…
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…
Post implementation
Customization » Monitoring » Editor for engine jobs » Post implementation
“Post implementation “is used to do actions after implementation steps. It can be recompiling code, fixing issues in data, or adding data to tables. In this example, it is a procedure that goes through the parameters configured and makes sure they are…
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…
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…
Deadlocks event collector
Using Control Center » Monitoring » Control Center Jobs » Jobs grouped by platform » Jobs for MS SQL Server » Deadlocks event collector
Name: Deadlocks event collector Platform: Sqlserver Category: Availability Description: Collects deadlocks event statistics from Microsoft SQL Server Extended Event Log files. If configured a warning or an alarm can be…
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…