Category: SQL Server Performance Tuning

Find Top 10 SQL Server Performance Problems

Recently, I blogged about the Top 10 SQL Server Performance Tuning Tips, the things we typically see when we healthcheck SQL Servers here at Sequallity. Now, we have developed a simple script to find the top 10 SQL Server Performance Problems. The script can take between 20 seconds and 42 minutes to run, depending on the number of databases present on the SQL server. It looks at the usual suspects

Read More

Top 10 SQL Server Performance Tuning Tips

Top 10 SQL Server Performance Tuning Tips for On-Premises and Virtualised SQL Servers I have been thinking recently about what is the most effective changes you can make to a SQL Server system and subsequently how these changes rank for importance. Maybe it’s all those Youtube videos I watch, so here are our Top 10 SQL Performance Tuning tips in reverse order… It’s a tough call because let’s say missing

Read More