Before vs. After Perf Tuning Report #7 – 7,039% improvement

Before vs. After Perf Tuning Report #8

Speed improved by: 4,763% + 550% + 1,726% or 7,039% total improvement.

Not bad for results that we got before I ate my serial 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.

First query improved by 4,763%.

Second query improved by 550%.

Third query improved by 1,726%.

 

First query:

sql server performance tuning frequently running query 01

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