Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Use the CPU Usage chart

The CPU Usage chart helps you determine the amount of strain your SQL Server instance is putting upon the CPU. This is an important factor in analyzing poorly-performing SQL Server instances. Click this chart to open the CPU, which contains more charts and information on your CPU resources.

...

Use the Call Rates chart

The Call Rates chart helps you determine why you have high CPU usage. The Call Rates chart displays the following metric statistics: 

...

Use the Memory Usage chart

The Memory Usage chart allows you to analyze the way in which your SQL Server instance uses memory. The chart provides the amount of memory allocated to SQL Server, the memory currently used by SQL Server, and the total amount used on the host computer.

...

Use the Cache Hit Ratios chart

The Cache Hit Ratios chart allows you to view how often a request is serviced by the buffer and procedure cache.

...

Use the Disk Busy chart

Use the Disk Busy chart to analyze bottlenecks in your file system.

...

Use the SQL Server Physical I/O chart

The SQL Server Physical I/O chart allows you to view the number of pages read from, and written to, the physical disk.

...