Summary

As you can see, you can use many different techniques to get the optimal performance out of your stored procedures. Information was grouped by platform, because performance tuning is very platform-specific. Both monitoring and basic tuning were covered.

To ensure top-notch performance, have a properly configured environment, proper indexes, and current statistics available.