Description:
Problem: This stored procedure showed up in the top resource-consuming report. It was putting too much stress on the CPU.
Solution: Added two new indexes.
Why does disk improvement matter for stored procedure speed?
It’s simple. The less you access the disk; the more disk capacity is left over.
It works just like a highway. Say you have 3 lane highway. And 5 cars use it every 1min.
What if you add 50 cars? The speed is still the same because 55 cars don’t overload that highway.
What if you add another 500 or 5000? Now you are starting a slowdown in traffic.
They all still get home. But not at the same speed anymore.
Same with SQL Servers. That’s why speed tuning most critical resources are essential.
The fewer hits there is to the storage, the more capacity there is available.
And the more future cars we can put on it.
See more SQL Server Performance Optimization examples here.