[Case Study] We Tuned SQL Server Performance and now TSQL runs 7,039% faster(not a typo)! How did we do it?

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.

See more SQL Server Performance Optimization examples here.

We tune slow SQL Servers every day. For over a DECADE now. Contact us!

Mark Varnas

Mark Varnas

Hey I'm Mark, one of the guys behind Red9. I make a living performance tuning SQL Servers and making them more stable. I channel my SQL into our SQL Managed Services, SQL Consulting and our internal database products.

Leave a Reply

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