Case study – 753x faster!

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!

Share this post

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

Leave a Comment

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

4.8/5

42

TESTIMONIALS

FREE Scripts to Instantly
Improve SQL Server Performance
[mc4wp_form id="4581"]