SQL Server Health Check

Know where your SQL Server stands in one week.

A focused review of performance, availability, backups, and security, ending in a prioritized fix list, so you know what matters most and what can wait.A one-week review of performance, availability, backups, and security, with a prioritized fix list.

A database under a magnifying glass next to a prioritized fix list

A review built to end in decisions

The Health Check is a one-week engagement. We look at the four areas that cause the most expensive surprises with SQL Server, and we finish with a list you can act on, ranked by what matters most.

It's also a practical way to find out whether we're the right team to help, before you commit to anything larger. Not sure what a good review includes? Read what a Health Check should cover.

What you get

A prioritized fix list. Findings are ranked by importance, so you know what to tackle first and what can wait.

What we review

Four areas, looked at together, because a problem in one often shows up in another.

Performance

Slow queries, indexing, blocking, and resource pressure that make applications and reports slower than they should be.

Availability

How your databases stay up, including high availability and failover setup (keeping databases running if a server fails), and where a single failure could take them down.

Backups

Whether backups are running, how long they're kept, and whether they could actually be restored when you need them.

Security

Access and permissions, patching, and configuration, with an eye on what an audit or security review would ask you.

How the week works

Three steps from kickoff to a list you can act on.

1

Scope

We agree what's in scope and the access we need, kept as limited as the review allows.

2

Review

We assess performance, availability, backups, and security across your environment.

3

Prioritize

You receive the fix list, ranked so you can decide what to act on first.

After the Health Check

The fix list is yours to act on however you like.

Act on it yourself

Work through the list with your own team, in the order it's ranked.

Have us fix it

We can take on the performance, configuration, and security items as a tuning or remediation project.

Plan an upgrade or move

If the review shows you're better off on a newer version or in Azure, we can plan and run the migration.

Hand off the day-to-day

Managed DBA takes over monitoring, backups, patching, and support, so the list stays short.

When a Health Check makes sense

  • You're running SQL Server 2016 or older and haven't decided what to do
  • Your DBA is leaving, or nobody owns the databases full-time
  • Applications or reports have been getting slower
  • You haven't tested a restore recently, or ever
  • An audit or security review is coming and you want to know where you stand
  • You've had an outage and want to be sure it can't happen the same way again

Common questions

Access to review your environment, agreed up front and kept as limited as the review allows, and a point of contact who knows the systems. We'll confirm exactly what's needed when we scope it.

No. Performance, availability, backups, and security matter on every version, including current ones.

Yes. We work on-premises, on Azure virtual machines, and on Azure SQL services, so the review applies wherever your databases run.

That's what the prioritization is for. The list is ranked, so you can deal with the most important items first and decide what can wait.

No. The fix list is yours, and you can act on it with your own team, with us, or with someone else.

Start with a SQL Server Health Check.

One week, and a prioritized fix list, so you know exactly where you stand.

Book a Health Check