Becoming a Query Performance Troubleshooting Expert
Every DBA wants to become an expert in query performance troubleshooting. Not every DBA is willing to put in the time and effort it takes to become an expert.
Troubleshooting
The Top 5 Most Common Problems With SQL Server
Over the years I’ve been able to compile a list of issues that I would consider to be common with SQL Server (and other database platforms like Oracle, no platform is immune to such issues). These are the issues that are often avoidable but not always easy to fix once they have become a problem. The trick for senior administrators such as myself is to help teams understand the costs, benefits, and risks of their application design options so as to avoid these common problems. So, here is my list of the top 5 most common problems with SQL Server.
SQL Server Troubleshooting Useful Links
When it comes to troubleshooting performance issues with SQL Server queries, you don’t need an advanced degree in rocket surgery.
Why Is My Server Running Slow?
It’s Sunday evening. You are sitting down to have dinner with your family. Suddenly your phone rings. You want to ignore it because, let’s face it, your phone rings a lot. But you see the person calling and knowing they don’t call very often you decide to answer. On the other end of the line … Read more
