Analytics & Diagnosing
Alerting System for Windows Server Monitoring
Windows Server alerting in SQL Planner — email and dashboard delivery, server down / disk / service alerts, thresholds and custom service monitoring.
7 min readUpdated
SQL Planner provides comprehensive alerting for Windows Server monitoring, so administrators receive immediate notifications when critical issues arise. This guide covers email notifications, dashboard displays and configuration options for matching alerts to your organization’s needs.
Understanding historical server alerts
Default email delivery
Upon login, you’ll find a dedicated section for historical server alerts. By default, all alert emails are automatically sent to your registered email address, ensuring you receive immediate notification of any server issues. This channel works independently of dashboard access.
Dashboard backup system
If you miss an email notification, all alerts remain accessible through the dashboard. The system maintains a complete record of every alert generated, so you can review historical data and identify patterns in server behavior over time.
The dual delivery system — email plus dashboard storage — ensures redundancy and reliability. Administrators can configure email settings to receive alerts at specific intervals or immediately upon detection, depending on operational requirements and urgency.
Configure Email Alert
Set up Database Mail and link the email profile in SQL Planner.
Individual server health dashboard
Server down alert notifications
When a server goes down, SQL Planner generates a comprehensive alert email with immediate visibility into the issue. The subject line clearly identifies which server experienced the outage, making it easier to prioritize responses when managing multiple servers.
- Email subject line — clear identification of the affected server and alert type.
- Timestamp details — precise date and time when the alert was detected.
- Error description — specific error type and technical details.
The most common server-down alert indicates a ping failure, where the monitoring system cannot establish basic network connectivity with the target server. This alert appears in both the email notification and the dashboard’s alert history, providing consistent information across access points.
Disk storage alert details
Disk storage alerts provide critical information about server capacity and utilization. When available disk space falls below configured thresholds, the system generates detailed notifications that include the server IP address, current disk load percentage, total volume size, occupied space and precise timestamp of detection.
| Metric | Description |
|---|---|
| 100% Total Volume Size | Complete capacity of the monitored disk drive. |
| 75% Occupied Space | Current usage percentage triggering the alert. |
| 25% Free Space | Remaining available capacity for operations. |
These storage warnings appear as email notifications with complete technical details and are simultaneously recorded in the dashboard alert history. Capturing data at specific date and time intervals enables proactive storage management to prevent outages caused by full disks.
Service-specific critical alerts
IIS service | Windows service down
When critical services such as Internet Information Services (IIS) or other Windows services fail, SQL Planner generates distinct critical error notifications. These alerts identify which specific service has stopped, the exact server where the failure occurred, and the precise timestamp when the service became unavailable.
The email notification includes detailed service status information, showing which particular IIS service instances were affected. If multiple IIS services stop running simultaneously, the system generates separate alerts for each failure, providing granular visibility into the scope of the problem.
Dashboard integration
All service-specific alerts appear in the dashboard alongside server-level alerts, creating a unified view of system health. The interface clearly distinguishes between warning and critical severity levels, helping administrators prioritize response efforts.
Service monitoring provides visibility beyond basic connectivity checks. A server may remain pingable and responsive at the network level while critical services fail independently. These alerts ensure notification when essential applications, web servers or related services stop functioning.
Dashboard alert management interface
- Summary view — high-level overview of all active alerts across monitored servers, categorized by severity (warning or critical).
- Detailed analysis — minute-by-minute capture of alert occurrences with complete technical details. Clicking Detail reveals the exact time frame when issues occurred.
- Health reports — comprehensive server health overview with descriptive analysis of issues.
The system displays the complete timeline from when a threshold was first breached through resolution or ongoing status. This provides better visibility than email alone and helps identify recurring issues that may indicate deeper systemic problems.
Server health report overview
The health report interface is designed to show comprehensive health reports. When you examine a server with active alerts, it displays summary-level info plus detailed descriptions explaining why specific issues occurred.
- Alert category identification — clear identification of the triggered alert type (server down, disk, service failure, etc.).
- Technical description — detailed explanation of the underlying technical cause and error conditions detected.
- Historical context — previous occurrences showing pattern recognition and recurrence frequency.
Configuring server alert thresholds
- 1
Access configuration
Navigate to “Edit Server Alerts” and select the specific server from the available list.
- 2
Define threshold values
Set specific values for each category, such as disk usage percentage or number of failed pings.
- 3
Enable or disable categories
Toggle individual categories on or off using switch controls to prevent notifications for specific alert types.
- 4
Save configuration
Click “Save All Changes” to apply settings immediately.
Custom service monitoring configuration
- 1
Access server config
Navigate to the specific server where you want to add custom monitoring.
- 2
Locate service settings
Find the service monitoring configuration section within alert settings.
- 3
Add custom service
Enter the exact name of the service as it appears in Windows Service Manager.
- 4
Verify and save
Confirm it appears in the list and click “Save All Changes”.
The system includes a predefined set of critical services but also allows organization-specific services. This flexibility ensures monitoring adapts to your infrastructure rather than forcing predefined templates.
Getting started with SQL Planner
- 1
Download SQL Planner Enterprise
Get the current Enterprise package from the Download page and install it following the Pre-requisite and Installation guide.
- 2
License and activate
Apply licensing through WebSQL as described in the Enterprise Licensing guide. The old free-forever license generator is discontinued.
- 3
Review documentation
Use the docs for installation, configuration and Windows Server monitoring setup.
Download SQL Planner
Get the Enterprise setup package.
Enterprise Licensing
Current licensing and activation guidance.
Windows Server Monitoring
Product overview for resources, event logs and alerting.
