Maintaining and troubleshooting Microsoft SQL Server's performance is a very wide set of tasks depending on several factors handled by administrators as well as by developers, sometimes independently and sometimes in conjunction. There's a strong need for cooperation of these two roles working with SQL Server, hence even if this book is taking SQL Server topics from an administrator's point of view, we will go through some development tips and trick briefly to show some cases of performance lags.
In this chapter, we will pay attention to the following topics:
- Performance monitoring overview: The first section defines what the performance is and enumerates prerequisites that should be fulfilled for successful monitoring and tuning. Also, top-level overview of monitoring procedures will be explained.
- Tools for monitoring performance: This...