Page History
...
The Statistics tab displays information on a selected entity and its associated entities. 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. 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. If you open the Statistics tab from another tab, the historical settings (meaning those settings which were selected when you left the tab, such as the last entity you drilled down to) are taken into account and the information displayed the last time you viewed this tab is displayed (similar to clicking the History button and returning to a previous tab). See “About the Precise bar” on page 24For more information about the Precise bar, see About the Precise bar.
The selected entity is always reflected in the Tab heading, which serves as a point of orientation. The highest-level entity you can view information for in the Statistics tab is the Tier level (viewed when All Instances is selected from the Instance list). You can also select a specific instance from the Instance list.
...
If you want to view additional information on an associated entity, drill down to it, by selecting the entity's row. A drill-down affects the entire tab. When you drill down to another entity, the Tab heading reflects the new selection, the Main area displays information on the selected entity, and the Association area displays the entities that are now associated with the newly selected entity.
...
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. See “About For more information about displaying this data, see About drilling down in context” on page 27context.
| 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. |
See “About For more information about the Main and Association areas, see About the Main area” area and “About About the Association area” on page 25area.
About the Instance entity
...
- In MS-SQL. Displays resource consumption counters collected by the Precise for SQL Server Collector such as, Using CPU, I/O wait, and Lock wait.
- CPU. Displays statistics that reports on CPU usage broken down into SQL Server CPU usage and Non SQL Server CPU usage.
- Paging. Displays memory paging statistics that are broken down into SQL Server Page Faults/sec and Non SQL Server Page Faults/sec.
- Load. Displays instance load statistics such as, Batch Requests/sec, Transactions/sec and Logins/sec.
- I/O. Displays I/O load statistics, such as, the percentage of time that has elapsed while the disks are busy servicing read and write requests.
- Network. Displays network load statistics, such as Maximum Packets Received/sec and Maximum Packets Sent/sec.
See “About session states” on page 36For more information about session states, see About session states.
About viewing CPU usage statistics for an Instance
...
- SQL Server Memory. Displays SQL Cache Memory, Optimizer Memory, Connection Memory, Lock Memory, Granted Workspace Memory, and Memory in Buffer Pool.
- Memory Allocation in Buffer Pool. Free Pages, Stolen Pages, and Database pagesPages.
About viewing Memory (Buffer Pools) statistics for an Instance
...
- General Details. Displays general information regarding the selected database entity.
- In MS-SQL. Displays database resource consumption counters collected by the Precise for SQL Server Collector, such as, Using CPU, I/O wait, Lock wait.
- Transactions. Displays Transactions/sec and Active Transactions.
- Flush Wait Time. Displays the Log Flush Wait Time counter.
- Log Flushes. Displays Log Flushes/sec, Log Flush Waits/sec and Log Cache Reads/sec.
See “About session states” on page 36For more information about session states, see About session states.
About viewing Database Transactions statistics
...
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. See “About For more information about the Main and Association areas, see About the Main area” area and “About About the Association area” on page 25area.
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. See “About For more information about the Main and Association areas, see About the Main area” area and “About About the Association area” on page 25area.
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. See “About For more information about the Main and Association areas, see About the Main area” area and “About About the Association area” on page 25area.
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. See “About For more information about the Main and Association areas, see About the Main area” area and “About About the Association area” on page 25area.
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 > >
...
...