Covers Every SQL Server Environment
What's Included
80+ Diagnostic Checks.
Zero Cookie-Cutter Scripts.
80+ diagnostic checks run across every layer of your SQL Server environment — instance, database, query, index, storage, and security. Every finding is manually reviewed and interpreted by Michael, not just raw script output dropped in a PDF.
Instance & Memory Health
Server-level configuration, memory allocation, NUMA topology, and process health validated against best practices.
Wait Stats & Blocking
Top wait types profiled, blocking chains identified, and concurrency problems surfaced before they become outages.
Query Performance Deep Dive
Every angle of slow query analysis — from worker time and logical reads to stored proc performance and ad hoc plan cache waste.
Index Strategy Analysis
Missing indexes ranked by impact across all databases. Redundant, unused, and volatile indexes flagged. Fragmentation quantified.
Storage & I/O Analysis
Drive-level and file-level latency measured, TempDB configuration assessed, VLF counts checked, and space usage reviewed.
Configuration & Security
Every critical sp_configure setting checked. Security posture reviewed including logins, permissions, SA status, and encryption.
HA/DR & Always On
Always On AG cluster health, listener configuration, replica sync status, and backup coverage verified end to end.
Statistics & Table Health
Stale statistics, table sizes, auto-shrink risks, and database-scoped configurations reviewed across all user databases.
Cloud Platform Checks
Azure SQL and AWS RDS have unique diagnostic surfaces. Platform-specific resource usage, geo-replication, and service tier checks included.
The Deliverable
Your Prioritized
Action Report
You don't just get raw data — you get a clear, prioritized written report with specific findings, their business impact, and the exact steps to fix them. Ordered by severity and effort.
Every recommendation is something you or your team can act on immediately. No vague suggestions, no upsell required.
Report Includes:
The Process
How the Health Check Works
From booking to report delivery, the process is straightforward and designed to minimize your time investment while maximizing the value you get back.
Start Now — Book a CallBook a Discovery Call (20 min)
Schedule via Calendly. We talk through your environment: SQL Server version, instance count, biggest pain points, and what you're hoping to learn. No prep needed.
Secure Read-Only Data Collection
You provide read-only access (or run my provided scripts locally and send output). No changes to your environment during the assessment phase.
Deep Analysis (48–72 Hours)
Michael personally reviews all collected data — DMV output, query plans, index usage, configuration settings, and security posture.
Report Delivery + Review Call
You receive the full written report followed by a 30-minute call to review findings, ask questions, and map out the highest-priority next steps.
You're in Control
The report is yours. Implement it yourself, hand it to your team, or engage Michael for implementation support — your choice, no pressure.
Is This Right for You?
Who Gets the Most from a Health Check
Performance is Suffering
Queries are slow, users are complaining, and you're not sure where the bottleneck is. You need a clear answer, fast.
No Dedicated DBA on Staff
Your developers or sysadmins manage SQL Server without deep DBA expertise. You want an expert set of eyes to find what they've missed.
Inherited a SQL Server Environment
You're the new DBA or consultant and need to quickly understand what you're working with, what's wrong, and where to start.
Planning a Migration or Upgrade
Before migrating to Azure SQL, AWS RDS, or upgrading SQL Server versions, you want to know the current state of health to avoid carrying problems forward.
Compliance or Audit Prep
Upcoming SOC 2, HIPAA, PCI-DSS, DoD STIGs, or internal audit and you need to understand, implement, and document your SQL Server security posture.
Proactive Risk Management / Planning
Things are running okay, but you want peace of mind — a professional confirmation that your environment is healthy and protected. Hands-on experience walking through risk management engagements with TrustWave consultants.
Ready to Get Started?
Book Your SQL Server Health Check
Start with a free 20-minute discovery call. No commitment, no sales pressure — just an honest conversation about your SQL Server environment.
Usually responds within 24 hours · St. Cloud, MN · Remote Worldwide