Skip to main content
SQL Planner

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.

Example Windows Server alert email — disk storage threshold breach with server details and usage.

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.

MetricDescription
100% Total Volume SizeComplete capacity of the monitored disk drive.
75% Occupied SpaceCurrent usage percentage triggering the alert.
25% Free SpaceRemaining 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. 1

    Access configuration

    Navigate to “Edit Server Alerts” and select the specific server from the available list.

  2. 2

    Define threshold values

    Set specific values for each category, such as disk usage percentage or number of failed pings.

  3. 3

    Enable or disable categories

    Toggle individual categories on or off using switch controls to prevent notifications for specific alert types.

  4. 4

    Save configuration

    Click “Save All Changes” to apply settings immediately.

Custom service monitoring configuration

  1. 1

    Access server config

    Navigate to the specific server where you want to add custom monitoring.

  2. 2

    Locate service settings

    Find the service monitoring configuration section within alert settings.

  3. 3

    Add custom service

    Enter the exact name of the service as it appears in Windows Service Manager.

  4. 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. 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. 2

    License and activate

    Apply licensing through WebSQL as described in the Enterprise Licensing guide. The old free-forever license generator is discontinued.

  3. 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.