Page History
...
For an explanation on how to define instance groups, see the Precise Installation Guide. 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.
...
- 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 > >
...