Case study – 753x faster!

Problem: Slow stored procedure

75,336% improvement in stored procedure performance!

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

I love making performance tuning SQL Servers fast and making them more stable. And I channel that obsession into our SQL Managed Services and new content here. When I'm not writing about SQL, I spend time outside hiking, skiing, mountain biking, or trying a new recipe.

Leave a Reply

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