SQL Server Performance Quick Fix

My one SQL Server View is showing noticeable slow-downs and I need an experienced DBA to jump in, trace the bottlenecks, and leave the system running smoothly again. There are no monitoring tools currently installed, so your first step will be to collect the right metrics by using SSMS, DMVs, Query Store, or any other lightweight method you trust.

The pain points are clear: long-running queries, inefficient or missing indexes, and a configuration that probably isn’t aligned with current workload patterns. I’m looking for someone who can move from diagnosis to action quickly—capturing a baseline, isolating root causes in query execution, indexing, and server settings, then applying fixes and showing measurable improvement.

Deliverables
• Diagnostic report summarising baseline findings (CPU, IO, wait stats, top queries)
• Concrete changes applied—index tweaks, rewritten queries, or configuration adjustments—with rationale
• Before/after performance metrics to prove the gain
• A short recommendations sheet so I can keep things healthy going forward

If you’ve solved similar optimisation issues and can demonstrate clear, quantifiable results, I’d like to hear how soon you can start and how long you’ll need for this focused engagement.