Analysis, Instruction, Advice.
$30,000 or $400? - A 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 serving 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.
One Option
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 four 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 - proving, in this case, that an ounce of technique is worth over 100 pounds of technology.
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.