SQL Server Performance

Do you need help with SQL Server performance?

Many who undertake SQL tuning projects look for the magic bullet in the form of a SQL Server software tool for help.

While SQL Server tools can help tune simple SQL statements, tuning complex queries that contain sub-queries, outer joins, etc, provide challenges for those tools. We have used many conventional health monitoring tools and have been less than impressed.

If tools are less than adequate, how do we effectively and efficiently tune SQL statements and applications? Instead of relying on server health tools that do not work well, we suggest learning to understand the performance of individual SQL queries and using tools that expose the problems and delays at a query level.

Too many people we cross paths with do not understand even the basics when it comes to SQL tuning, so a goal of this website is to provide a process that will help you get started down the tuning path and resources to help you along your way.

Understanding SQL Server performance takes time and practice, so if you are intimidated by the thought of undertaking tuning projects, roll up your sleeves and jump into it. You will never learn by sitting on the sidelines and doing the same old things. However, when beginning the project you will want to make sure you are not standing on an island by yourself.