$30,000 or $400? - A SQL Server Audits Case Study

Growing Pains

Increasingly high CPU utilization on a high-end system was putting a mission-critical application in jeopardy.

Like many database servers in production, this server was acting as the back-end for a number of key applications. But when CPU activity consistently remained above 80% utilization, concerns grew over how the server would manage with an anticipated increase in customer load.

Throwing More Hardware at the Problem

Since the server was housing a number of applications a tentative decision was made to buy a new, identical, server and offload some of the back-end databases.

Anticipated cost: $30,000.

The SQL Server Audits Solution

In just a few hours I was able to drop CPU utilization from a sustained average of 80% down to a sustained average of just 12%. My solution only cost $400 - and was easily able to handle the anticipated increase in traffic.

Using standard tools and techniques, I was able to isolate the exact database, application, and problem causing the high levels of CPU utilization. Three lines of code later, CPU activity was completely tamed - providing plenty of room and opportunity for increased load and growth.

Another problem solved by SQL Server Audits...

SQL Server Expertise

At SQL Server Audits, I can help save you money and help solve your complex SQL Server problems and concerns.

Contact me today to help put the power of SQL Server Audits to work for you.