Summary
PerfMon is a powerful tool in any DBA's toolbox. Used alone, it provides a comprehensive overview of the server's status — both Windows and SQL Server. The key to PerfMon is understanding the overwhelming number of counters. If you know which counters to focus on, you'll find that PerfMon can be efficient.
The next chapter looks at Profiler, a SQL Server monitoring tool that you can use with PerfMon to produce thorough performance monitoring.
Get Microsoft SQL Server 2012 Bible 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.
