Solving SQL Server Issues

sqlserver2014

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.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s