WIKI
|
Control Center
About dbWatch Control Center
[+]
Release notes
Find your version
Platforms supported
Getting started
[+]
Installing on Windows
Installing on Linux
[+]
Console installation on Ubuntu
Console installation on Redhat
Initial Domain Setup
Multi server setup
Product overview
[+]
Architecture
[+]
Example architecture designs
Cloud router
[+]
Cloud router security
File Structure
Network and communications
Database operations philosophy
Monitor dashboards and overview screens
Installing and using premium packages
[+]
Sql performance package
[+]
Installation of SQL Performance package
Using SQL Performance package on SQL Server
[+]
Integration with SSMS
Using SQL Performance package on Oracle
Using SQL Performance package on PostgreSQL
Using SQL Performance package on MySQL
Repository management and monitoring
[+]
Troubleshooting issues in sql performance package
Security and compliance package
[+]
Installation of the security and compliance package
Security and compliance package on sql server
Automated maintenance package
Using control center
[-]
The modules of control center
Disabling and enabling views
Instance management
[+]
Instance configuration
[+]
Jdbc properties
Monitoring engine
Adding a sqlserver instance
[+]
Using os authentication
Adding sqlserver instances with kerberos
Adding an Oracle instance
Adding a PostgreSQL instance
Adding a MySQL instance
Bulk installing instances
Groups configuration
[+]
Changing instance group
Service groups
Domain configuration
[+]
Adding or changing license
Managing nodes
Managing roles
Managing users
[+]
Creating a user
User integration with active directory
2 factor authentication
Managing security groups
Privileges and actions map
Upgrade dbwatch
Monitoring
[+]
Tree navigation
Instance details
Pause
Job details
Job menus
Job concepts
[+]
Schedule
Acknowledgement system
Versioning
Status
Report
Parameters
Notes
Job types
[+]
Engine jobs
No engine jobs
Control Center Jobs
[+]
Jobs grouped by platform
[+]
Jobs for Mariadb
[+]
Aborted_clients
Aborted_connections
Aborted_connects_alert
Binlog_cache_check
Database_growth_rate_(aggregated)
Database_growth_rate_(detailed)
DBMS_uptime
Framework
Galera_Cluster_node_count
Galera_Cluster_node_receive_queue
Galera_Cluster_node_send_queue
Galera_Cluster_node_state
Gelera_Cluster_network_statistics
InnoDB_buffer_pool_check
Instance_memory_statistics
Lock_statistics
Maximum_connections_alert
MyISAM_key_cache_check
Network_statistics
Replica_count
Replica_delay
Replica_state
Session_load
SQL_statistics
Temporary_table_check
Threads_statistics
Jobs for Mysql
[+]
Aborted_clients
Aborted_connections
Aborted_connects_alert
Binlog_cache_check
Database_growth_rate_(aggregated)
Database_growth_rate_(detailed)
DBMS_uptime
Framework
InnoDB_buffer_pool_check
InnoDB_cluster_status
InnoDB_cluster_switch
Instance_memory_statistics
Lock_statistics
Maximum_connections_alert
MyISAM_key_cache_check
MySQLd_process_alert
NDB_data_memory_usage_check
NDB_data_node_status
Network_statistics
Query_cache_hitrate
Replica_count
Replica_delay
Replica_state
Session_load
SQL_statistics
Statement_load
Temporary_table_check
Threads_statistics
Jobs for Oracle
[+]
Agresso_CON$_system_table
Agresso_help_and_temp_tables
Agresso_reports_queue
Alert_log_check
Alert_log_check_(java)
Analyze_tables
Applied_archive_log_gap_status
Archive_status_Check
ASM_disk_statistics
ASM_diskgroup_space
Audit_basic_login_anomalies_detector
Audit_local_repository_framework
Audit_login_anomalies_detector
Audit_remote_repository_framework
AUDIT_TABLE
Audit_source_framework
Autoextensible_data_files
Backup_log_Check_10g_('old_style'_backups)
Backup_log_Check_8i('old_style'_backups)
Backup_log_Check_9i_('old_style'_backups)
Blocking_detector
Blocking_detector_for_RAC
Buffer_cache_statistics
CPU_load
Data_Guard_Archive_Status
Data_Guard_Archive_Status_Check
Data_Guard_role_switch
Database_link_check
Database_mount_state
Database_network_statistics_(SQLNET)
Database_uptime
Datafile_status
Dataguard_apply_time
Dataguard_archive_sequence_apply_lag
Dataguard_standby_archivelog_gap
Dataguard_startup_time
Dataguard_transport_time
Dba_Jobs_check
DBMS_uptime
Delete_SYS.AUD$_data
Disk_read_statistics
Disk_space_check
Export_log_Check_('old_style'_backups)
Extent_fragmentation
File_IO_statistics
File_status_check
Flash_Recovery_Area_Usage
Flash_recovery_space_usage
Framework
Free_extents
Index_fragmentation
Index_status_check
Instance_alert_log
Instance_memory_statistics
Invalid_objects_check
Job_scheduling_check
Latch_statistics
Listener_log_check
Listener_log_check_(java)
Listener_status_check
Long_running_queries
Max_datafiles
Max_datafiles_check
Max_processes
Memory_session_load_for_RAC
Monitor_SYS.AUD$_table_size
MV_Refresh_Group(s)
Open_cursors
PDB_status
Password_expire
RAC_instances_status
Rebuild_indexes
Redo_statistics
Restore_uptodate_status
RMAN_ARCHIVELOG_backup_status_alert
RMAN_archivelog_backup_status
RMAN_backup_status
RMAN_backup_status_alert
RMAN_incremental_backup_status
RMAN_recovery_area_backup_status
Segment_size_collector_(all_segments_ _aggregate)
Segment_size_collector_(large_segments_ _detail)
Segment_size_status_for_old_style_tablespaces
Session_load
Session_load_Rac
Snapshot_Log(s)_rows_count
SQL_statement_statistics
Snapshot_Log(s)_size
SQL_statistics
SQL_waits
SYS.AUD$_size
SYS.AUD_size
Statistics_migration
Table_fragmentation
Table_statistics_check
Tablespace_free_space
Tablespace_free_space_check
Tablespace_in_BEGIN_BACKUP_mode
Temporary_tablespace_free_space_check
Test_alert
Test_alert_db
TNSping_check
Test_DML_performance
Top_user_memory_usage
Undo_statistics
User_memory_statistics
Wait_statistics
Jobs for Postgres
[+]
Analyze_tables
Backup_check_ _pg_dump
Backup_check_ _WAL
Backup_job_ _pg_dump_all_(ssh)
BDR_Replication_lag
Blocking_statistics
Buffer_cache_reads_per_database
Buffer_cache_statistics
Database_growth_rate_and_info
DBMS_uptime
DbWatch_engine_alert
Disk_block_hitrate
Disk_block_reads_per_database
Framework
Index_block_hitrate
Locks_held_and_statistics
Log_size_statistics
Max_connections
Replication_delay_alert
Replication_slave_client_alert
Schema_growth_collector
Schema_growth_statistics
Session_load
SQL_statistics
Table_and_index_scan_collector
Table_and_index_scan_statistics
Tablespace_growth_and_information
Test_DML_performance
Transaction_statistics
Vaccum_tables
Vacuum_alert
Jobs for Sqlserver
[+]
AG_synchronization_lag
Ad_Hoc_Distributed_Queries
Agent_Jobs_Check
Agent_error_log
Agent_Jobs_Check_(MS2000)
Agresso_ _missing_system_indexes
Agresso_ _missing_user_indexes
Agresso_ _not_registered_indexes
Agresso_blob_size_collector
Agresso_framework
Agresso_help_and_temp_tables
Agresso_report_queue
AlwaysOn_database_backup_alert
AlwaysOn_differential_database_backup_alert
AlwaysOn_transaction_log_backup_alert
Asymmetric_Key_size
Auto_close_database
Auto_growth_event_collector
Autogrowth_settings
Autoshrink_settings
Backup_All_databases
Backup_All_transaction_logs
Blocking_detector
Blocking_statistics
Cached_query_statistics
Check_database_and_server_principal_mapping
Check_database_recovery_mode
Cleanup_MSDB_history_tables
CLR_Assembly_permission
CLR_Enabled
Collation_check
Command_shell_setting
Contained_database_credentials
Cross_DB_Ownership_Chaining
Cycle_error_log
Data_cache_memory_usage
Data_file_size_check
Data_hit_ratio
Database_backup
Database_backup_(2000)
Database_backup_(SIMPLE)
Database_backup_(system_databases)
Database_backup_(system_dbs)
Database_compatibility
Database_disk_capacity
Database_disk_space_usage
Database_growth_rate_(aggregated)
Database_growth_rate_(detailed)
Database_Log_backup
Database_Mail_XPs
Database_Server_uptime
Database_mirroring
Database_session_load
Database_statistics
Database_status
Databases_NOT_IN_USE_collector
DBCC_CHECKDB
DBCC_UPDATEUSAGE
DbWatch_Server_activity_alert
DbWatch_engine_alert
Deadlocks_event_collector
Default_trace_enabled
DEMO_blocking_sessions
Disabled_sa_account
Disk_space_check
External_fragmentation_(all_databases)
Failover_cluster_host_switch
File_IO_statistics
Filegroups_growth_rate
First_Responder_Kit
Full Text_service_account
Framework
Guest_database_users
Health_state
Hide_Instance
High_activity_monitor
Index_usage_statistics_(all_databases)
Instance_Authentication_Mode
Instance_error_log
Instance_error_log_(AWS)
Instance_error_log_file_size_check
Instance_memory_check
Instance_memory_usage
Instance_status
Internal_fragmentation_check
Lazy_writer_and_Checkpoint_statistics
Log_shipping_monitor_(primary)
Log_shipping_monitor_(secondary)
Login_audit_setting
Login_failed_and_successful_setting
Logins_default_database_check
Member_state
Memory_objects_statistics
Missing_database_backup
MS_SQL_Server_patch_status
Missing_database_log_backup
MS_SQL_service_account
Number_of_ERRORLOG_files
Objects_size_collector_(all_databases)
Ole_Automation_Procedures
Orphaned_database_users
Page_verify_option
Password_expiration_(sysadmin)
Password_policy
Program_status
Public_role_(msdb)
Public_server_role
Query_Store_status
Rebuild_indexes
Rebuild_indexes_in_table
Remote_access
Remote_admin_connections
Renamed_sa_account
Reorganize_indexes
Reorganize_indexes_in_table
Replica_states
Replication_status
Report_Server_status
Restricted_Enterprise_edition_features
Restricted_Enterprise_edition_features_(2000)
Restricted_Enterprise_edition_features_2005
Scan_for_startup_procs
Security_and_Compliance_framework
Server_memory_statistics
Session_load
Session_statistics
Sessions_per_database
Shrink_transaction_logs
Sp_BlitzCache
Sp_BlitzIndex
Sp_BlitzLock
Sp_BlitzWho
SQL_Agent_service_account
SQL_Browser
SQL_Server_Agent_status
SQL_Server_performance_counters
SQL_Server_Protocols
SQL_statements_(Logical_reads)
SQL_statistics
Standard_ports
Statistics_migration
Suspect_pages
Symmetric_Key_encryption
Table_size_collector
Temporary_database_space_usage
Test_alert
Test_DML DDL_performance
Transaction_log_size_check
Transaction_log_space_usage
Transactions_load
Transactions_log_flushed_bytes_load
Truncate_transaction_log
Trustworthy
Update_index_statistics
Update_statistics
Version_store_space_usage_(tempdb)
Wait_statistics
Windows_BUILTIN_groups
Windows_LOCAL_groups
Jobs for Sybase
[+]
Blocking_detector
Data_cache_monitor
Data_cache_statistics
Database_backup
Database_growth_rate_(detailed)
Database_space_check
Database_status
DBMS_uptime
Disk_activity_monitor
Dump_database
Engine_CPU_monitor
Memory_statistics
Procedure_cache_check
Session_load
SQL_statistics
System_monitor_collector
Temp_cache_statistics
Test_DML DDL_performance
Transaction_log_space_check
User_connections_check
Jobs grouped by category
[+]
Availability
Capacity
Cluster and replication
Compliance
Consolidation
Maintenance
Migration
Performance
Agresso
Security and complicance
Jobs by artifact id
[+]
CLR assembly permission
Ad hoc distributed queries status
Applied achive log gap status
Asymmetric key size
Auto close database
Clr enabled status
Cmd shell setting
Contained db credentials
Cross db ownership chaining status
Database mail xps status
Default trace enabled
Disabled sa account
Error log file count
Full text service account
Guest database user
Hide instance status
Instance authentication mode
Login audit setting
Login failed and successful setting
Mariadb aborted clients check
Mariadb aborted clients check info sch
Mariadb aborted connects check
Mariadb aborted connects check info sch
Mariadb binlog cache
Mariadb binlog cache inf sch
Mariadb db growth rate aggr
Mariadb db growth rate det
Mariadb dbms uptime
Mariadb framework
Mariadb galera cluster network statistics
Mariadb galera cluster node count
Mariadb galera cluster node receive queue
Mariadb galera cluster node send queue
Mariadb galera cluster node state
Mariadb innodb buffer pool
Mariadb instance memory statistics
Mariadb instance memory statistics info schema
Mariadb lock statistics
Mariadb lock statistics info schema
Mariadb myisam key cache
Mariadb myisam key cache info sch
Mariadb network statistics
Mariadb network statistics info sch
Mariadb noschema aborted connects
Mariadb noschema max connections
Mariadb replica count
Mariadb replica delay
Mariadb replica state
Mariadb session load
Mariadb session load inf sch
Mariadb sql statistics
Mariadb sql statistics 10 4
Mariadb threads statistics
Mariadb tmp table
Ms 2000 database server uptime
Ms agent error log
Ms agent jobs check 2000
Ms agent jobs check job
Ms agent status job
Ms agresso acrrepord check job
Ms agresso acrrepord not registered indexes job
Ms agresso blob size check job
Ms agresso framework job
Ms agresso help tabs check
Ms agresso missing system indexes job
Ms agresso missing user indexes job
Ms alwayson database backup job
Ms alwayson differential database backup job
Ms alwayson transaction log backup job
Ms autogrow settings
Ms auto growth event collector
Ms autoshrink settings
Ms backup all databases
Ms backup all transaction logs
Ms blocking detector 8 9 10
Ms blocking statistics
Ms cached query statistics
Ms cleanup msdb history tables
Ms collation check
Ms cycle error log
Ms database 2000 backup check job
Ms database 2000 status
Ms database backup 2005 20012 check job
Ms database backup check job
Ms database disk capacity
Ms database growth rate aggr
Ms database growth rate aggr 2000
Ms database growth rate detailed
Ms database growth rate detailed 2000
Ms database log backup 2005 2012 check
Ms database log backup check
Ms database mirroring
Ms database recovery mode
Ms database server uptime
Ms database server uptime 2005
Ms data cache memory usage
Ms data cache memory usage 2005 8
Ms database session load job
Ms database status
Ms databases not in use collector
Ms data file size check
Ms data file size check 2000
Ms data hit ratio
Ms dbcc checkdb
Ms dbcc updateusage
Ms db disk space usage job
Ms dbw engine alert job
Ms dbw server activity alert job
Ms deadlocks event collector
Msdb public role
Ms demo blocking sessions
Ms disk space check
Ms external fragmentation all db
Ms failover cluster switch
Ms filegroups growth rate job
Ms file io statistics
Ms filegroups growth rate job 2000
Ms framework 2000
Ms framework job
Ms gather database statistics job
Ms health states job
Ms high activity monitor
Ms high activity monitor 9
Ms index usage statistics all db
Ms instance error log
Ms instance error log aws
Ms instance error log file size check
Ms instance memory check
Ms instance memory usage
Ms instance memory usage 9 10
Ms instance status
Ms internal fragmentation check
Ms lazy writer and checkpoint statistics
Ms log shipping monitor primary
Ms log shipping monitor secondary
Ms member state job
Ms memory objects statistics
Ms migration from dbwatch12
Ms noschema blocking detector
Ms noschema database backup alert
Ms noschema data file size check
Ms noschema database log backup alert
Ms noschema database status
Ms noschema disk space check
Ms noschema instance memory check
Ms noschema missing database backup alert
Ms noschema missing database log backup alert
Ms noschema transaction log space usage
Ms objects size collector all db
Ms page verify option
Ms principal mapping
Ms program status
Ms query store status
Ms rebuild indexes
Ms rebuld indexes in table
Ms reorganize indexes
Ms reorganize indexes in table
Ms replica states job
Ms replication status
Ms report server status
Ms restricted enterprise edition features 2000 job
Ms restricted enterprise edition features 2005 job
Ms restricted enterprise edition features job
Ms security framework job
Ms server first responder kitk blitz
Ms server memory statistics
Ms server run sp blitzIndex
Ms server run sp blitzcache
Ms server run sp blitzlock
Ms server run sp blitzwho
Ms session load job
Ms session statistics
Ms sessions per database
Ms shrink transaction log
Ms simple database backup check
Ms sql db compatibility
Ms sql login default database check
Ms sql patch status
Ms sql server performance counters
Mssql service account
Ms sql sql statements logical reads
Ms sql statistics
Ms standard ports
Ms suspect pages
Ms synchronization lag job
Ms system database 2000 backup check job
Ms system database backup check
Ms table size collector
Ms temporary database space usage
Ms test DML performance
Ms test status job
Ms transaction log size check
Ms transaction log size check 2000
Ms transaction log space usage
Ms transaction log space usage 2008 2016
Ms transaction log space usage 8 9
Ms transactions load
Ms transactions log flushed bytes load
Ms transactions log flushed bytes load 2000
Ms truncate transaction log
Ms update index statistics
Ms update statistics
Ms version store space usage
Ms wait statistics
Mysql aborted clients check
Mysql aborted clients check info sch
Mysql aborted connects check
Mysql aborted connects check info sch
Mysql binlog cache
Mysql binlog cache inf sch
Mysql db growth rate aggr
Mysql db growth rate det
Mysql dbms uptime
Mysql dbms uptime info schema
Mysql dbms uptime info schema 55
Mysql framework
Mysql innodb buffer pool
Mysql innodb buffer pool inf sch
Mysql innodb cluster status
Mysql innodb cluster switch
Mysql instance memory statistics
Mysql instance memory statistics info schema
Mysql lock statistics
Mysql lock statistics info schema
Mysql myisam key cache
Mysql myisam key cache info sch
Mysql ndb data mem check
Mysql ndb data node status
Mysql network statistics
Mysql network statistics info sch
Mysql noschema aborted connects
Mysql noschema max connections
Mysql noschema mysqld process
Mysql query cache
Mysql replica count
Mysql replica delay
Mysql replica state
Mysql session load
Mysql session load inf sch
Mysql sql statistics
Mysql statement load
Mysql statement load info schema
Mysql threads statistics
Mysql threads statistics info schema
Mysql tmp table
Mysql tmp table inf sch
Ole automation procedures status
Oracle agresso acrrepord check
Oracle agresso con check
Oracle agresso help tabs check
Oracle alert log check
Oracle alert log check 10g
Oracle alert log check 8i
Oracle alert log check 9i
Oracle analyze tables
Oracle archive status check
Oracle asm disk statistics
Oracle asm diskgroup
Oracle audit basic login anomalies detector
Oracle audit local repo framework
Oracle aud tabe ddl
Oracle aud table size
Oracle audit login anomalies
Oracle audit remote repo framework
Oracle audit source framework
Oracle autoextensible files check
Oracle backup log old style 10g
Oracle backup log old style 8i
Oracle backup log old style 9i
Oracle blocking detector
Oracle blocking detector rac
Oracle buffer cache statistics
Oracle cpu load check
Oracle database uptime
Oracle dataguard archive status
Oracle data guard role switch
Oracle dataguard archive status old
Oracle db alert log
Oracle db link check
Oracle dba jobs check
Oracle dbms uptime
Oracle delete audit records
Oracle disk read statistics
Oracle disk read statistics 8i
Oracle disk space check
Oracle dml performance
Oracle export log
Oracle file io statistics
Oracle file status
Oracle flash recovery area usage
Oracle flash recovery area usage 10
Oracle framework
Oracle free extents check
Oracle index status check
Oracle index status check 8i
Oracle instance memory statistics
Oracle invalid objects check
Oracle java alert log
Oracle java alert log 10g
Oracle java listener log check 10g
Oracle job scheduling check
Oracle latch statistics
Oracle listener log check 10
Oracle listener log check 11
Oracle listener log check 12
Oracle listener log check 8
Oracle listener log check 9
Oracle listener log check java
Oracle listener status check
Oracle long running queries
Oracle max datafiles check
Oracle max processes
Oracle memory session load rac
Oracle mv refresh group
Oracle network statistics
Oracle noschema asm diskgroup
Oracle noschema database mount state
Oracle noschema datafile status
Oracle noschema dataguard apply time
Oracle noschema dataguard archive sequence apply lag
Oracle noschema dataguard gap
Oracle noschema dataguard startup time
Oracle noschema dataguard transport time
Oracle noschema extent fragmentation
Oracle noschema flash recovery space
Oracle noschema max datafiles
Oracle noschema max processes
Oracle noschema restore uptodate status
Oracle noschema rman archivelog backup
Oracle noschema rman backup
Oracle noschema sys aud size
Oracle noschema tablespace free space
Oracle open cursors check
Oracle password expire
Oracle pdb status
Oracle rac instance status
Oracle rebuild indexes
Oracle redo statistics
Oracle redo statistics 8
Oracle rman backup archivelog status
Oracle rman backup status 10
Oracle rman backup status 10 1
Oracle rman backup status 11
Oracle rman backup status 19
Oracle rman backup status 8
Oracle rman backup status 9
Oracle rman incr backup status
Oracle rman recvr area backup status
Oracle segment size collector aggregate
Oracle segment size collector aggregate 9
Oracle segment size collector detail
Oracle segment size status
Oracle session load
Oracle session load 8 9
Oracle session load rac
Oracle snapshot log rows count
Oracle snapshot log size
Oracle sql statement statistics 10
Oracle sql statement statistics 11
Oracle sql statement statistics 12
Oracle sql statement statistics 18
Oracle sql waits
Oracle statistics migration dbw12
Oracle tablespace free space check
Oracle tablespace free space check 8 9 10
Oracle table statistics
Oracle temp free space check
Oracle test alert db
Oracle test alert instance
Oracle tnsping check
Oracle top user memory usage
Oracle ts begin backkup mode
Oracle undo statistics
Oracle user memory statistics
Oracle wait statistics
Ora index fragmentation check
Ora sql statistics
Ora sql statistics cdb
Ora sql statistics pdb
Ora sql statistics rds
Ora table fragmentation check
Ora table fragmentation check 10g
Orphan database user
Password policy
Pg table and index scan collector
Postgres backup check pgdump
Postgres backup wal check
Postgres bdr replication lag
Postgres blocking statistics
Postgres buffer cache reads per db
Postgres buffer cache stat
Postgres database growth and info
Postgres dbms uptime
Postgres disk block hitrate
Postgres disk block reads per db
Postgres dml performance
Postgres framework job
Postgres index block hitrate
Postgres job noschema analyze tables
Postgres job noschema schema growth collector
Postgres job noschema vacuum alert
Postgres job noschema vacuum tables
Postgres locks held type3
Postgres log size statistics
Postgres max connections
Postgres pg dump all ssh maintenance
Postgres replication delay
Postgres replication slave client
Postgres scan statistics
Postgres schema growth statistics
Postgres session load
Postgres sql statistics 14
Postgres sql statistics12
Postgres standard alert dbw engine
Postgres tablespace growth and info
Postgres transaction statistics
Public server role
Pwd expiration sysadmin
Remote access status
Remote admin connections status
Renamed sa account
Scan for startup procs status
Sql browser
Sql server protocols in use
Sqlagent service account
Syb blocking detector
Syb database backup status
Syb database space check
Sybase dump database
Sybase sql statistics
Syb data cache monitor
Syb data cache statistics
Syb database space check 12
Syb database status
Syb db growth rate detl
Syb dbms uptime
Syb disk activity monitor
Syb engine CPU monitor
Syb memory statistics
Syb procedure cache check
Syb procedure cache check v12
Syb session load
Syb system monitor collector
Syb temp cache statistics
Syb test DML perf
Syb trans log space check
Syb user connections check
Syb user connections check v12
Symmetric key encryption
Trustworthy status
Windows builtin groups
Windows local groups
Management
[-]
Management on sql server
[-]
Dbwatch alerts
Configuration
[+]
Parameters
[+]
Advanced dynamic parameters
Advanced static parameters
Registry parameters
Uptime statistics
[+]
Database name database server
[+]
Instance name instance
Maintenance periods
SQL performance
[+]
Internal repository
Server activity
[+]
Blocking sessions
[+]
Blocked sessions history
Blocking sessions history
Locks
Active processes
Performance test
Sessions
[+]
Sessions history
Sessions performance
Disk and Memory usage
Backups
SQL Server Error logs
Databases
Security
SQL Server Agent
Operating System Manager
Audit
SQL Worksheet
Worksheet
Autodiscover
[+]
Defining Autodiscover Ports
Auto discover with different default port
Discovering Database Instances
FDL console
Reporting
[+]
Generate Reports
Scheduled Reports
Edit Report Templates
Customization
[+]
Importing resources
Monitoring
[+]
Editor for engine jobs
[+]
Properties
Metadata
Internal objects
External dependencies
Configuration parameters
Installation variables
Pre implementation
Implementation
[+]
Main procedure SQL Server
Post implementation
Upgrade
Report
Example engine jobs
Job templates
Customize View using FDL
No engine jobs
Property System
[+]
Metadata properties
Dynamic properties
Javascript property
The property file format
Management
[+]
Formatting table results
Result types
[+]
Graphical
[+]
Stacked area chart
Line chart
Pie chart
Category chart
Category line chart
Item active
Reports
Extensions and 3rd party integrations
[+]
Email and SMS
[+]
Configuring email extension for Service Now
Web server
[+]
Web configuration
Dashboards
Web data export
Web dashboard editor
Anonymous webaccess
Supported Web Browsers for dbWatch Dashboard
Advanced Topics
[+]
FDL Farm Data Language
[+]
Functions
[+]
Add function
Sub function
Abs function
Until function
Groupby function
Avg function
Capitalize function
Concat function
Containsall function
Containsnone function
Containssome function
Count function
Difference function
Distinct function
Div function
Empty function
Hash function
Indexof function
Intersect function
Length function
Lower function
Max function
Min function
Mkstring function
Mult function
Nicedb function
Nonempty function
Orderby function
Replace function
Round function
Substring function
Sum function
Todate function
Tomillis function
Toperiod function
Trim function
Upper function
Union function
Available properties
[+]
Properties on dbWatch Servers
Properties on Instances
Properties on Jobs
Properties on Internal
Application Modules
[+]
Unit4 Agresso
The FString format
Product Security
[+]
Product Description
Hardware Specifications
Operating System
Network Ports and Services
Sensitive Data Transmitted
Sensitive Data Stored
Certificate infrastructure
Crypto catalog
Network Controls
Encryption
Audit Logging
Remote Connectivity
Disclaimer
Node to Node communication
Auditing
Control Center Commandline
[+]
Setting up a CCC node
FDL with CCC
Add instance with CCC
Set metadata with CCC
Install jobs with CCC
Get instance configuration with CCC
Register instance configuration with CCC
Instance action script with CCC
Start stop webservice with CCC
Exporting configuration from 12 to CC
Internal Control Center firewall
Troubleshooting Guide
[+]
Backup of dbWatch
Adding MySQL instance with Super Privilege Error
Restore configuration backup
Issues and troubleshooting
Definition Mapping
Resetting dbWatch Control Center Admin Account
Fresh Installation of dbWatch Control Center
Remote Support
Additional Resources
[+]
Database Farm Management Additional Resources
Licensing terms
SQL
Worksheet
SQL
Worksheet allows for direct
SQL
commands on the database instance.
wiki.dbwatch.com - © 2025
