Before vs. After Perf Tuning Report #5 – 938,757% improvement and a new record!

Before vs. After Perf Tuning Report #5 - 938,757% improvement

Report Report #5... and a new tuning record!

We do a lot of performance tuning of slow SQL Server code.

In this example I will show you how we set our personal best record so far!

938,757% 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
we-tuned-your-sql-and-got-1-million-percent-improvement

Its not 1MM. But its close!

What was changed?

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

That’s it. That simple!

 

Got any proof?

Obviously, we can just paste client code here. But here is what I can show you. 

Below you will see capture of BEFORE vs. AFTER performance tuning run. SQL proc performance BEFORE it was tuned and AFTER it was tuned.

Agree? Disagree? Comment below.

Share this post

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