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 vs. AFTER tuning results.

How did we do it?

Simple.

Two main things happened here:

1. SQL Cursor changed from Local to Fast Forward (cant replace the SQL cursor, because this is a third party application and we are limited on what we can do).

2. Indexes hint was added to force specific index usage.

That’s it! That simple!

Imagine how fast we could make your SQL Server go!

Share this post

Share on facebook
Share on google
Share on twitter
Share on linkedin
Share on pinterest
Share on print
Share on email