Databases · Microsoft SQL Server
Enterprise SQL Server operations under the same platform and policies.
SchemaPulse applies the same operational model to Microsoft SQL Server as to every other engine — one console, one policy language for backup and retention, one incident and recommendation pipeline.
SQL Server is covered by the same platform model as every other engine: one console, one policy language for backup and retention, one incident and recommendation pipeline.
Support
Versions and deployment
Supported versions
- SQL Server 2019
- 2022
- 2025
Storage targets
- local
- NFS
- S3
- GCS
Topologies
How SchemaPulse sees Microsoft SQL Server
- Standalone
- Always On Availability Groups
- Failover Cluster Instances
Availability group role, synchronisation state and failover events are tracked per replica.
Capabilities
What is covered on Microsoft SQL Server
- Monitoring
- Database and system metrics from a signed agent on each host
- Query Analytics
- Slow queries, query timeline, index reports, background export
- Backup
- Native full backup · Differential backup · Transaction-log backup
- Point-in-time recovery
- Full backup plus a continuous transaction-log backup chain, optionally using differential backups, restored to the selected recovery point.
- Storage targets
- local · NFS · S3 · GCS
- Provisioning
- Terraform and Ansible, with the agent installed as part of the build
- Integrations
- Jira · PagerDuty · Email
Intelligence
What SchemaPulse recommends on for Microsoft SQL Server
- Index efficiency and missing index findings
- Query plan regressions
- Availability group health
- Backup policies without a successful verification
- Resource saturation trends