When you open the Statistics tab from the Activity tab, the tab is launched, in context, if the selected entity exists in the Statistics tab. When you open the Statistics tab from the Dashboard tab, the tab is launched, in context, and depending upon your selection in the All SQL Server Instances table (All or Instance), the information is displayed on the Tier or Instance level. The Statistics tab displays information on a selected entity and its associated entities. For example, if the Collector identifies a massive Using CPU State it may be necessary to check the CPU queue length or SQL compilation counters to check related problems that can influence the Using CPU State parameter. Alternatively, you can use the Statistics tab to fully analyze a performance problem reported by the Collector. Use the Statistics tab to periodically monitor the health of your system-for example, view the statistics on CPU utilization or Hit Ratios. While examining a single counter is very important, the real value obtained from working with the Statistics tab lies in examining the ready-to-use set of graphs that display several related counters. Based on the information displayed in the CPU Pressure graph, you will be able to determine if the system is experiencing CPU pressure that may be alleviated by faster CPUs, by adding additional CPUs, or by SQL tuning. You will be able to view how much time the SQL Server waited for each wait group. Viewing these statistics will let you diagnose additional performance issues in the In MS-SQL graph. If you are using SQL Server 2005, you will have access to additional statistics on wait events and latch events. It is possible to view current status in one-minute intervals or historical information roll-up at a higher summary level. The statistics tab provides hundreds of raw performance counters (All perfmon counters that are relevant to SQL Server and a few additional OS counters are collected). Is it possible to examine the disks' average queue length? " The Statistics tab enables you to provide answers to the following types of questions: "Is SQL Server the major CPU consumer in my server?" or "I am aware that SQL Server suffers from I/O wait. The tab can be used to monitor your system's current state as well as historical statistical information. In addition several OS statistics are also presented to enable you to examine SQL Server and OS statistics together. The Statistics tab displays statistical information on all SQL Server instances. How the Statistics tab can help you identify performance problems.This section includes the following topics:
0 Comments
Leave a Reply. |