Before vs. After Perf Tuning Report #10 – 340% CPU gain

Before vs. After Perf Tuning Report #10 – 340% CPU gain

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.

SP tuning

 

 

Share this post

Share on facebook
Share on google
Share on twitter
Share on linkedin
Share on pinterest
Share on print
Share on email