SQL performance tuning report and making CPU faster by 340%. How did we do it?

SQL Server Performance Tuning Report

This tuning requires a bit of a different explanation.

In some cases, client server is pressure on different resources. The three resources/parameters when tuning we care most about are:

• CPU
• Storage
• Duration

In this case, this stored procedure ran a LOT. It ran enough, to be the top CPU cycle consumer when looking at all T-SQL calls.

Server CPU was under heavy pressure. Somewhere around constant 70-80%.

Therefore we looked for a candidate that would reduce CPU usage.

You can see that Duration dropped some just a bit

Disk usage went up. Not ideal. But we knew CPU is what we tuning for. And as long as you got enough resources this type of trade off is OK.

CPU  usage cut by about 340% or 3 times less. Which is pretty great, since we really needed to get more CPU capacity.

See more SQL Server Performance Optimization examples here.

We tune slow SQL Servers every day. For over a DECADE now. Contact us!