Solving SQL Server issues can be very difficult. You have to understand the symptoms before you can track down the cause of a given problem. Once you understand the problem you then have to know how to address a specific problem to resolve the issue. Just because you know a server is running slower than normal doesn’t mean you automatically know what is causing the issue or what steps you should take to solve the problem. In a recent article by
You can easily resolve some issues related to SQL Server performance, but there are others that require more time and resources. Implementing these performance solutions may require some planning or perhaps a service outage. Once configurations are adjusted, they may need long-term monitoring or ongoing adjustments to succeed. That’s why we call these solutions “The Long Road.”
There are four issues under this umbrella: file locations, virtual log files, tempdb files, and missing index DMVs.