Before vs. After Perf Tuning Report #3 – 877% improvement

Before vs. After Perf Tuning Report #3 – 877% improvement Real example #3 Some SQL Server Consulting clients chose to tune databases periodically. This is one of those clients. Here is a recent example of performance tuning slow MS SQL Server Stored Procedure. And here is a capture from SQL Server Profiler to compare BEFORE

Read More »

Before vs. After Perf Tuning Report #2 – 67,871% gain

Before vs. After Perf Tuning Report #2 – 67,871% improvement Real example #2 Today I am sharing another MS SQL Performance tuning report from recent tuning. After making couple of small tweaks to the SQL Server stored procedure we were able to get few improvement: Run time duration improved by: 10,788% CPU improved by: 10,903% Disk

Read More »

Before vs. After Perf Tuning Report #1 – 846% improvement​

Before vs. After Perf Tuning Report #1 – 846% improvement Real Example #1 Some customers care about SQL Performance Tuning so much, that they use our database administrators for continuous Microsoft SQL Server performance tuning. Once we tune, I noticed sometimes it was hard to communicate benefit achieved. We struggled a bit with reporting which

Read More »