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.