[Case study] Tuning SQL Performance to run 753 times faster! How did we do it?

Problem: Slow stored procedure

75,336% improvement in stored procedure performance!

Notes:
Improvements achieved:
• CPU from 18,922 to 1,249
• Reads from 12,850,589 to 18,532
• Duration from 30,682 to 685

What was changed?

A SELECT with four JOINS became two SELECTs using a UNION.

It’s not 1 thousand times faster. But it is close!

That’s it. That simple!

Check out more case studies here!

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 *