Chapter 39. Monitoring SQL Server Performance

No SQL Server implementation is perfect out of the box. As you build and add SQL Server–based applications to your server, you should take an active approach to monitoring performance. You also need to keep reevaluating as more and more load is placed on your servers and data volumes grow. This chapter focuses on SQL Server monitoring and leaves monitoring of the other types of servers (including application servers, backup servers, domain controllers, file and print servers, mail/messaging servers, and web servers) for the specialists in those areas.

You can monitor ...

Get Microsoft® SQL Server 2008 R2 Unleashed now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.