SQL Server consulting for quick pain relief.
You’re frustrated with a slow, unreliable Microsoft SQL Server. You’re tired of hearing conflicting advice and watching team members point fingers at each other. Is it a storage problem? A code problem? A database problem? You just want clear answers. You’ve got a great team – but they just need some guidance to get back on track.
My 2-day SQL Critical Care® gets everyone on the same page and brings you permanent pain relief.
Leading up to the engagement: you install SQL ConstantCare® (it’s free for my SQL Critical Care clients), sending me diagnostic data, and getting the obvious recommendations out of the way. I track your wait stats, indexes, query plans, and more, looking for problems ahead of time so I can hit the ground running on Day 1. I also send advice ahead of time so you can start getting the low-hanging fruit out of the way. (I’ve had some engagements where we even solved everything before Day 1 started, and we were able to focus the rest of the engagement on becoming more proactive!)
Day 1 morning: we walk through your diagnostic data together. I start a WebEx session with your senior sysadmin or DBA, lead developer, and a business stakeholder. I show you what’s going on, training you as I go, showing you what we’re seeing together. It’s a fast, low-impact, read-only process that I’ve used across hundreds of clients around the world, without any need for VPN logins or high-overhead traces.
Day 1 afternoon & day 2 morning: I write the findings. You go back to work while I analyze the data and build a plan of attack. I write a clear, actionable set of tasks for you to get permanent pain relief. You can see samples of ’em below.
Day 2 afternoon: I train your team. The moment of truth: we get back together to go through the findings in detail, showing you exactly why the SQL Server isn’t behaving the way you’d expect, and how to get the pain relief you want. It’s a mix of consulting and training: I’m showing you exactly what you need to do, and explaining why it’ll make a difference. You’re then empowered to relieve SQL Server pains on your own – without expensive prescriptions for ongoing consulting. (If you’d like to hire me to help do the work, that’s an option too.)