Chapter 4. Resource Monitor and Performance Monitor
In this chapter we will cover:
- Monitoring of server performance
- Monitoring CPU usage
- Monitoring memory (RAM) usage
Introduction
If you encounter database performance problems caused by poorly written queries, lack of necessary indexes, or anything else at database level, you can troubleshoot such issues and investigate the root cause by using execution plans, DMVs and DMFs, SQL Traces, or Database Engine Tuning Advisor (DTA).
However, if the performance issues are at hardware or operating system level, you need a sophisticated tool that gives you an idea about the performance of your hardware resources (such as CPU, memory, I/O, or network adapters) with respect to the processes that might be running ...
Get Microsoft SQL Server 2012 Performance Tuning Cookbook 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.
