SQL Performance Tuning Report – 7,039% improvement

Speed improved by: 4,780% + 565% + 1,763% or 7,108% total improvement.

Not bad for the results that we got before I ate my cereal in the morning.

 

Here is another SQL Server performance tuning report. Before vs. After.

“Before” – shows numbers before we made any changes.

“After” – shows performance numbers after we made some changes in the database to improve slow SQL calls.

 

This report shows three queries that run a lot faster now.

The first query improved by 4,763%.

The second query improved by 550%.

The third query improved by 1,726%.

 

First query:

Second query:

 

Third query:

What changes made these queries run faster?

Item #1 (SELECT that runs every 30 minutes)
– Created index [IX_extra_6__INC] on [oehdraud_sql] ;

Item #2 (UPDATE bins set bin_flag=1 )
– Created index IX__bin_flag__INC on [<removed>_ldbld_bins] ;

Item #3 – Tuning procedure ( <removed>_DealerPortal_UpdateCustomerLevel )
– Replace 2 temporary tables with CTE.

 

Questions? Comments? Write 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

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

3 FREE Scripts to Instantly
Improve SQL Server Performance

Learn how to increase Performance of SQL Server INSTANTLY with 3 free scripts.