Page History
...
In the Association area, click the row of the disk you want to view detailed information for. The Tab heading indicates the newly selected entity; the Main area displays statistical information on the disk entity you drilled down to, and the Association area shows information on its associated performance counters. For more information about displaying this data, see About drilling down in context.
| Anchor | ||||
|---|---|---|---|---|
|
...
For an explanation on how to define instance groups, see the Precise Installation Guideand Administration. The following table describes the information displayed in the Instance Grouping table.
Table 9- 1 Instance Grouping table
| Column | Description |
|---|---|
| Group | Displays the name of the group. |
| Instances | Displays the number of instances linked to the group. |
| SQL Server CPU | Displays the average SQL Server CPU Usage (%) of all the instances in the specified group. |
| Transactions/sec | Displays the average number of Transactions/sec started for the databases of the instances in the specified group. |
| Batch Requests/sec | Displays the average number of Batch Requests/sec received by the instances in the specified group. |
| Page Faults/sec | Displays the average number of Page Faults/sec executed by the instances in the specified group. |
About viewing instances associated with an Tier in the Association area
...
The following table describes the information displayed in the tabs in the Association area.
Table 9- 2 Viewing information on associated instances
| Tab | Description |
|---|---|
| CPU | Displays counters that report on the average and maximum CPU resources used by the SQL Server and the entire Server. |
| Load | Displays counters that report on instance load such as Login/sec, and Transactions/sec. Both average and maximum values are displayed. |
| I/O | Displays counters that report on I/O performance, such as the average time it takes to read from the disk, and I/O load, such as the average number of read operations on the disk, per second. |
| Memory | Displays counters that report on memory utilization by SQL Server, such as SQL Server Memory MB (max) vs. Page Faults per second. |
| Network | Displays statistics that report on network activity, such as Output Queue Length and Packets sent or received, per second. |
For more information about the Main and Association areas, see About the Main area and About the Association area.
About the Instance entity
...
You can view information on the entities associated with the selected Database entity in the Association area. For example, you can analyze counters that report on the database's transaction activity and log activity. It is possible to associate to the Database entity from an Instance entity. For more information about the Main and Association areas, see see About the Main area and About the Association area.
About the Disks entity
The Disk entity displays predefined graphs that report on disk activity and performance in the Overview view. This enables you to immediately view relevant counters, grouped according to topic.
...
You can view information on the entities associated with the selected Disk entity in the Association area. It is possible to associated to the Disk entity an Instance entity. The counters displayed in the Association area report the disk's performance and load. For more information about the Main and Association areas, see see About the Main area and About the Association area.
About the Network Cards entity
...
You can view information on the entities associated with the selected Network Card entity in the Association area. It is possible to associate to the Network Card entity from an Instance entity. The counters displayed in the Association area report the network card's activity, load and latency. For more information about the Main and Association areas, see see About the Main area and About the Association area.
About the Performance Counter and Counter Instance entities
...
You can view information on the entities associated with the selected Performance Counter or Counter Instance entities in the Association area. It is possible to associate to the Performance Counter or Counter Instance entities from the Instance, Database, Disk or Network Card entities. When choosing a specific performance group the description of the counters are displayed. When drilling down to a counter with instances, the minimum, maximum and average values for the counter instances are displayed. For more information about the Main and Association areas, see see About the Main area and About the Association area.
About the Wait Events entity (SQL Server 2005 only)
...
- Enhancing the application
- Reducing the amount of data returned
- Configuring the SQL Server instance “network "network packet size (B)” " parameter with a reasonable number that would avoid many packets from being sent or received (causing overhead)
- Reconfiguring the network configuration
...
- In the Time Frame list, choose the period of time you want to analyze.
- In the Instance list, choose the instance you want to analyze.
- On the Association controls in the Association area, click Latch Events. View the latch events listed in the Association area. Observe to which latch group an event belongs.
Compare the event in one latch group to an event in a different latch group to observe how much time each wait event spent in the SQL Server. - Drill down on a latch event entity and observe its performance over time.
- You can continue your analysis by viewing the hit ratio in the Memory (Buffer Pools) view. If the hit ratio is below 99% consider adding RAM to the SQL Server. If the hit ratio exceeds 99%, consider improving the speed of your I/O system.
Precise. Performance intelligence from click to storage. Learn more > >
...