SQL Server Performance Tuning Report – 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!

Mark Varnas

Mark Varnas

I love making performance tuning SQL Servers fast and making them more stable. And I channel that obsession into our SQL Managed Services and new content here. When I'm not writing about SQL, I spend time outside hiking, skiing, mountain biking, or trying a new recipe.

Leave a Reply

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

Call Us Now

Or, Let Us Know How We Can Help

Tight On Time?

Schedule A Call: