Permissions and requirements
Configuration and setup
- Installing ApexSQL Monitor
- ApexSQL Monitor installation terms, definitions, and network topography
- ApexSQL Monitor setup and configuration: best practices, recommendations and options
- ApexSQL Monitor components
- How to configure ApexSQL Monitor
- ApexSQL Monitor for a first-time user
- How to add servers to ApexSQL Monitor
- Organizing monitored servers into groups
- How to add AlwaysOn Availability Groups for monitoring
- Monitoring AlwaysOn Availability Groups
- How to set up and activate custom performance metrics
- How to include and exclude databases in ApexSQL Monitor
- How to manage monitored queries
- Purging repository data
- How to configure ApexSQL Monitor SSL web access (https) manually
- How to use encrypted connections to SQL Server within ApexSQL tools
- How to migrate the repository database to a different SQL Server
- How to change the idle timeout of the web client
- Performance metrics quick guide
- How to customize the calculated SQL Server baseline threshold
- How to calculate baseline for less than seven days of historical data
- Using the query waits feature
- How to configure and use deadlock monitoring
- Using and scheduling SQL Server performance monitoring reports
- How to configure and use SQL Server Wait statistic monitoring
- How to use and interpret the SQL Server Activity monitor
Licensing and activation
Alerts
- ApexSQL Monitor alerts
- How to create and schedule maintenance periods in ApexSQL Monitor
- How to suppress excessive alerting using Alert periods
- Resolving alerts in ApexSQL Monitor
Alerting profiles
- Working with email notifications and email profiles in ApexSQL Monitor
- How to use custom SQL script alerts in ApexSQL Monitor
- How to use custom command alert actions in ApexSQL Monitor
- Configuring and setting up the SNMP trap in ApexSQL Monitor
- How to set up SMS alert notifications in ApexSQL Monitor
Custom reporting
- ApexSQL Monitor ad hoc reporting functions (inventory, descriptions and examples)
- ApexSQL Monitor ad hoc reporting Helper functions (inventory, descriptions and examples)
- How to create custom SQL Server performance reports – Part 1 (Performance & status metrics)
- How to create custom SQL Server performance reports – Part 2 (alerts, Indexes and databases)
- How to create custom SQL Server performance reports – Part 3 (Wait statistics and Query waits)
- Custom reports basics
Index monitoring
