O'Reilly logo

Microsoft SQL Server 2012 Performance Tuning Cookbook by Bihag Thaker, Ritesh Shah

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required