Services
Check it. Watch it. Fix it.
Three services. Most clients start with a health check, then move to monitoring.
1 · One-time
SQL Server Health Check
A comprehensive assessment of one SQL Server instance. Your tech runs the script and sends us the output. We don't need access to the client's server or network.
You get back:
- A one-page summary in plain English, rated red, yellow or green by area. Written so the client can read it.
- A prioritized fix list with an effort estimate for each item. You decide what gets done and who does it.
$495 per SQL Server instance. Results within 5 business days of receiving the output.
What it covers
- Backups and recoverability: are there backups, how old, does the recovery model match
- Security: sa, sysadmin members, old logins, risky settings
- Configuration: memory, parallelism, tempdb, database options
- Capacity: disk space, file growth, log size
- Maintenance and Agent jobs: integrity checks, index and statistics upkeep, failing jobs
- A performance snapshot: waits, heavy queries, missing indexes
2 · Monthly
Monitoring and care
A lightweight collector runs on each server. It sends health data to us over outbound HTTPS only, using a read-only login that can't read or change client data. Why that's safe.
We triage every alert. You hear from us when something needs action, with what happened and what we recommend. Not a wall of raw alerts.
Each month you get a one-page report per server, and each plan includes 2 maintenance hours per server per month for routine fixes.
Response times
| Alert | We respond |
|---|---|
| Critical | Within 1 hour, during business hours |
| Warning | By the next business day |
Business hours are Monday to Friday, 8 a.m. to 5 p.m. Mountain Time. This is not a 24/7 on-call service.
What it checks
| How often | Checks |
|---|---|
| Every 5 minutes | Server reachable, disk free space, blocking, transaction log usage, long-running queries, Agent job failures |
| Hourly | Age of the last full backup and the last log backup |
| Daily | Last clean CHECKDB, sa enabled, sysadmin members, auto-shrink and auto-close, SQL Server version |
| Always | An alert if a server's collector stops reporting |
3 · As needed
Fixes and projects
Remediation
Work from the health check fix list, or anything beyond the included monthly hours. Billed hourly or from a prepaid block.
Performance tuning
Slow screens, timeouts, blocking. We find the queries and indexes behind it and fix them, or tell the vendor exactly what to fix.
Azure migrations
Moving legacy SQL Server to Azure. Starts with a fixed-price assessment and migration plan, so you know the scope and cost before anything moves.