Top reasons for slow SQL Server performance I typically see are:
Slow Running Queries, these are queries that run slow even with just one user in the database.
- Caused by poorly written queries.
- Caused by missing indexes.
> See Database Health Monitor Missing Indexes Report. - Caused by out of date statistics for your indexes.
- Many other reasons.
Blocking Queries, where one query is holding a lock on a table and causing blocking. A few, to hundreds or thousands of queries can pile up in a traffic jam behind a single blocking query.
- Caused by slow queries that are changing data.
- Caused by missing indexes.
- Caused by out of date statistics.
- Caused by long running transactions.
- Caused by poorly architected tables.
- Many other reasons.
Your first assumptions may be that you need faster hardware, more memory, or bigger disks. Sometimes that may be true, but with good performance tuning, you can speed up queries without changing the hardware. Other times faster hardware does’t help and you have to end up doing the performance tuning anyhow.
There are many ways Stedman Solutions can help.
- Using Database Health Monitor for tracking the issues on your own.
- Become proficient using Database Health Monitor in our online course.
- Our full Performance Assessment helps determine the cause of your issues and provide remediation.
- Sign up for our Free Performance Tuning Weekly Training
More from Stedman Solutions:
Steve and the team at Stedman Solutions are here for all your SQL Server needs.
Contact us today for your free 30 minute consultation..
We are ready to help!