Fractional SQL Server DBA · Free SQL Server Health Check

4 min read Original article ↗

Free · Read-only · 15 minutes

Find out what's quietly killing your SQL Server, before it kills a night's sleep.

A read-only health check for your SQL Server. One script, nothing leaves your server, you keep the report.

Read-only, no agents Nothing leaves your server You keep the report

Running SQL Server without a DBA? The bit at the very bottom is for you ↓

The problem

Most SQL Server emergencies were avoidable

The warning signs sit in the DMVs for months. Nothing shows up on a dashboard until it's a 2am outage.

  • Backups that can't actually restore, or a FULL-recovery log with no log backups, growing until the disk fills.
  • No integrity checks: disk corruption spreading silently until a query hits the bad page.
  • TempDB and memory misconfigured, throttling every query the moment load arrives.

The score

You can't see this from a dashboard

A neglected SQL Server hides its risk in plain sight: green on every monitor, one bad night from an outage. This is what the check reveals. Where does yours land?

24/ 100Critical risk

0 · CriticalAt riskFairHealthy · 100

Get my free health score

What you get

A plain-English report, not a wall of jargon

Every check tells you what it is, what it’s costing you, and how to fix it, ranked by severity, with a summary you can forward to your boss.

Recoverability restore gaps, missing log backups, worst-case data loss

Integrity last known-good CHECKDB

Config drift every setting changed from default

Memory & CPU memory cap, MAXDOP, cost threshold

TempDB & storage file layout, contention, IO latency

Top offenders your heaviest CPU & memory queries, named

Security the sa account, surface area, who holds the keys

Page verification CHECKSUM on, so corruption gets caught early

Auto-shrink the setting that quietly fragments your data

File growth percentage autogrowth and un-sized files

Query Store whether your flight recorder is even on

Compatibility level databases stuck on an old version

See a full sample report →

How it works

Zero risk to your production server

1

You run it

A single read-only script in SSMS or sqlcmd. No agents, no installs, nothing leaves your server.

2

You get the report

It builds a branded HTML report on the spot: findings ranked by severity, with a health score.

3

We review it

Send it back and I'll walk you through the top three things to fix. Free, about 15 minutes.

Run your own SQL Server health check

One read-only script in SSMS. About 15 minutes. Nothing ever leaves your server.

  • A plain-English report that scores your server 0 to 100
  • Every risk ranked by severity, urgent vs. what can wait
  • A prioritized fix list you can act on today

Get the health check

Send the report back and I’ll walk you through it, no charge.

Run the check, fix what it finds, and for a lot of teams that’s the whole story. No pitch, glad to help.

But if that report just puts a number on something you already suspected, that no one is really watching your SQL Server, a one-time fix won’t hold.

There’s a better answer

The ongoing option

Your SQL Server, actually looked after.

Someone keeping a real eye on it: the maintenance and tuning most servers never get, and a judgment call when something looks off, not just an alert nobody reads. Month to month.

The work that gets skipped

Regular maintenance and tuning a busy team never gets around to.

Judgment, not just alerts

A person who can look at what’s happening and decide what to do.

Simple monthly plans, light-touch to all-in. Start with the free check, and we’ll take it from there.