Urgent SQL Server Tune-Up
Budget: $250 – $750 USD
Our central SQL Server, the backbone for the design software my 10-person team relies on every day, has slowed to a crawl. Queries lag, the CPU sits at a steady 100 % and we’re starting to feel the pain of frequent locks that stall productivity. I haven’t touched the configuration recently, so I suspect the bottleneck lies in a mix of schema design, missing or ineffective indexes and plain hardware fatigue. A brand-new machine is already on order, but it won’t arrive for a few months. I need an experienced performance specialist who can squeeze every possible ounce of speed out of this current box so we can keep working smoothly until the upgrade lands.
Here’s what I’m hoping for:
• A focused diagnostic session to trace the exact causes of the high CPU usage, slow queries and lock contention (activity monitor, Profiler, DMVs, Query Store—whatever you prefer).
• Concrete, low-risk optimisations—index improvements, query rewrites, light-touch configuration tweaks—that we can roll out quickly with minimal downtime.
• A short report summarising what was changed, why, and any maintenance scripts or monitoring queries I should keep running.
If you’re comfortable diving into production, speaking plainly about findings and delivering measurable gains fast, let’s get started.
Here’s what I’m hoping for:
• A focused diagnostic session to trace the exact causes of the high CPU usage, slow queries and lock contention (activity monitor, Profiler, DMVs, Query Store—whatever you prefer).
• Concrete, low-risk optimisations—index improvements, query rewrites, light-touch configuration tweaks—that we can roll out quickly with minimal downtime.
• A short report summarising what was changed, why, and any maintenance scripts or monitoring queries I should keep running.
If you’re comfortable diving into production, speaking plainly about findings and delivering measurable gains fast, let’s get started.