RE2 Tech rescued a production SQL Server installation that had become unreliable under growing load for a manufacturing client.
Read the Full StoryTalk to UsA manufacturing client had a production SQL Server installation that supported a custom line-of-business application. Over time, as the database grew and the number of users climbed, query performance had become erratic. Some mornings the system ran fine. Some mornings users waited minutes for screens to load. Nobody could predict when the bad days would happen.
We set up extended events to capture query performance and blocking over a week of normal operation. The data showed a classic pattern: a small number of reports running on the same server were competing for resources with OLTP traffic, and when they ran at the wrong time they starved the application of memory and CPU.
We tuned the biggest report queries, added resource governor limits to protect OLTP traffic from reporting workloads, rebuilt index strategy on the most-used tables, and reconfigured memory settings to match the actual workload. We also scheduled the most intensive reports for off-hours so they no longer competed with production.
Morning slowdowns disappeared. Application response time became consistent through the business day. The client kept the same hardware because the real problem was not capacity, it was configuration and workload management. The engagement has continued as ongoing monthly DBA support.
Call a RE2 Tech engineer today and get a specific proposal inside of 72 hours. No pressure, no long pitch.
612-494-3557helpdesk@re2tech.com