Deadlocks event collector - Control Center - 1.0

About dbWatch Control Center
- Release notes
- Find your version
- Platforms supported
Getting Started
- Installing on Windows
- Installing on Linux
  - Console installation on Ubuntu
- 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
- 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
- Domain Configuration
- Monitoring
- Management
  - Management on SQL Server
- Worksheet
- Autodiscover
  - Defining Autodiscover Ports
  - Auto-discover with different default port
- Reporting
Customization
- Importing resources
- Monitoring
- Property System
- Management
- Reports
- Extensions and 3rd party integrations
  - Email and SMS
    - Configuring email extension for Service Now
- Web server
Advanced Topics
- FDL – Farm Data Language
  - Functions
  - Available properties
- Application Modules
  - Unit4 Agresso
- The FString format
- Product Security
- Auditing
- Control Center Commandline
- 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

Download as PDF

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 triggered when a deadlock is detected.
Long description:	SQL Server Extended Events has a configurable architecture that allows to collect information to troubleshoot or identify a
Version:	2
Default schedule:	0 * * *
Requires engine install:	Yes
Compatibility tag:	[CDATA[.[type=‘instance’ & databasetype=‘sqlserver’]/.[maj_version > ‘2012’ & hasengine=‘YES’ & engine_edition = ‘Microsoft SQL Server’

Parameters
Name	Default value	Description
history threshold	180	The number of days before the history record will be removed from the history table.
return status	0	Return status value (ALARM – 2, WARNING – 1, or OK – 0) when a deadlock is detected.
target	c:\tmp	Path value where the target file will be created.

← Table size collector / Database backup (2005-2012) →

Feedback

Post your comment on this topic.