Features

This section provides detailed descriptions of QMonitor’s features and capabilities. Each feature is designed to help you effectively monitor and manage your SQL Server instances.

Overview

QMonitor provides a comprehensive set of features for monitoring, analyzing, and maintaining SQL Server instances across your entire estate, whether on-premises, in the cloud, or in hybrid environments.

Core Features

Monitoring & Dashboards

Visual monitoring through pre-built Grafana dashboards that provide real-time and historical insights into your SQL Server health and performance.

• Performance Dashboards: Track CPU, memory, disk I/O, and other critical metrics
• Query Stats: Analyze workload characteristics and identify expensive queries
• Storage Analysis: Monitor database size, file growth, and space utilization
• Custom Views: Filter and focus on specific time ranges, instances, or databases

Explore Dashboards

Issues & Alerts

Proactive monitoring that notifies you when your instances need attention.

• Issue Tracking: Centralized view of all detected problems
• Alert Configuration: Customize thresholds and notification rules
• Severity Levels: Prioritize critical, warning, and informational issues
• Historical Records: Track issue resolution and patterns over time

Explore Issues

Jobs & Maintenance

Automated maintenance tasks to keep your SQL Server instances healthy and compliant.

• Backup Scheduling: Configure and monitor backup jobs
• Integrity Checks: Schedule DBCC checks and consistency validation
• Index Maintenance: Automate index rebuild and reorganization
• Job History: Track execution status and troubleshoot failures

Jobs

Inventory Management

Centralized repository of information about your SQL Server estate.

• Instance Catalog: Maintain details about all monitored servers
• Database Tracking: Document ownership, purpose, and metadata
• Configuration Management: Store connection strings, credentials, and settings
• Documentation: Link to runbooks, contacts, and operational notes

Inventory

Compliance Checks

Validate your SQL Server instances against industry best practices and organizational standards.

• Best Practice Rules: Automated checks based on Microsoft and community guidelines
• Custom Policies: Define organization-specific compliance requirements
• Audit Reports: Generate compliance reports for review and remediation
• Remediation Guidance: Get recommendations for resolving non-compliant settings

Settings & Configuration

Centralized configuration for all aspects of QMonitor.

• Instance Registration: Add and configure SQL Server instances for monitoring
• Data Collection: Control what metrics and events are captured
• User Management: Define roles and permissions
• Integration Settings: Configure external systems and notifications

Getting Started

New to QMonitor? Start with these resources:

1. Getting Started Guide - Set up your first monitored instance
2. Dashboards Overview - Learn to navigate and interpret dashboards
3. Common Tasks - Follow step-by-step guides for common operations

Architecture

QMonitor is a 100% cloud-based solution with the following characteristics:

• No On-Premises Infrastructure: No servers or databases to install and maintain
• Lightweight Agent: Minimal footprint on monitored SQL Server instances
• Secure Communication: Encrypted data transmission and storage
• Multi-Tenant: Isolates customer data with role-based access control
• Scalable: Monitors from a single instance to hundreds across your enterprise

Support

Need help? Check out the Troubleshooting section or contact support from the Support page.