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.

SP tuning

See more SQL Server Performance Optimization examples here.

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

Mark Varnas

Mark Varnas

Hey I'm Mark, one of the guys behind Red9. I make a living performance tuning SQL Servers and making them more stable. I channel my SQL into our SQL Managed Services, SQL Consulting and our internal database products.

Leave a Reply

Your email address will not be published. Required fields are marked *