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!

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 *

Call Us Now

Or, Let Us Know How We Can Help

Tight On Time?

Schedule A Call: