[Case study] SQL Performance Tuning using indexes

Problem Summary

The client is experiencing issues with SQL server performance.

Two stored procedures that are run hundreds of times per hour were taking a long time to execute.

What was done

Simple. For this case, we created only a new index to improve both stored procedures.

The first one:

The another one:

As soon as we begin providing our services, you will be able to monitor the progress in every segment influenced by our activities.

You will notice how your system performance improves.

Also, the number of critical incidents will dramatically decrease.

As a result, your overall productivity and efficiency will be enhanced beyond the most optimistic expectations.

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 vehicles? 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.

We tune slow SQL Servers every day. For over a DECADE now. Contact us!

Picture of Mark Varnas

Mark Varnas

Hey I'm Mark, one of the guys behind Red9. I make a living performance tuning SQL Servers and making them more stable. I channel my SQL into our SQL Managed Services, SQL Consulting and our internal database products.

Leave a Reply

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