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!
See more SQL Server Performance Optimization examples here.
