Chapter 37. Monitoring SQL Server Performance
by Paul Bertucci
IN THIS CHAPTER
Performance-Monitoring Approach
Performance Monitor
Windows Performance Counters
SQL Server Performance Counters
SNMP Support
Using DBCC to Examine Performance
Other SQL Server Performance Considerations
No SQL Server implementation will be perfect “out of the box.” As you build and add SQL Server applications to your server, you will want to start taking an active approach to monitoring performance. You will also need to keep re-evaluating things as more and more load is placed on your servers. This chapter will focus on SQL Server monitoring and leave the other types of servers for those specialists. Other types of servers would include application servers, backup servers, ...
Get Microsoft® SQL Server™ 2000 Unleashed, Second Edition 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.
