Page History
This section includes the following topics:
...
- About the Dashboard tab
...
- About the Main area in the Dashboard tab
...
- How the Dashboard can help you identify performance problems
...
...
About the Dashboard tab
The Dashboard tab provides an overview (approx. 70-80%) of the information displayed in other Precise for SQL Server tabs. The Dashboard is the starting point for your Precise analysis since it displays an overview of all the instances available in the selected application and information that is also available in some of the other tabs.
...
The Dashboard tab provides answers to the following types of questions:
...
- Are all my SQL Server instances up?
...
- Which instance is consuming the most resources?
...
- Which program is consuming the most resources for the specified instance and across all instances?
...
- From what types of performance problems is an instance suffering?
The All row in the All SQL Server Instances table located in the Main area (left pane) displays the average availability of all instances. When you select the All row a summary of the activities of all the instances and a comparison of application identifiers is displayed in the various tab pages viewed in the Instance Details area (right pane).
In general, launching to a tab from the All row focuses in on the Tier entity, which summarizes the data collected for all instances. Tabs that do not have an Tier entity, open on the default instance.
...
| Info |
|---|
...
If you are working with SAP, PeopleSoft, or Siebel, and ERP support is installed, the Dashboard tab displays information on SQL Server activity in relation to the ERP application and users, and specific information on executed views and transactions. |
See “About Precise for SQL Server tabs” on page 22. See , “About the Current tab” on page 55.See , “About the Activity tab” on page 74.
See , “About the Objects tab” on page 105. See , “About the Statistics tab” on page 147. See , “About the SQL tab” on page 162.See , “About the Maintenance tab” on page 186. See , and “About the SmarTune tab” on page 203.
How the Dashboard tab is structured
The Dashboard tab is divided into two areas—the Main area and the Instance Details area. The Main area lists all the instances that are monitored by the Precise for SQL Server Tier. The Instance Details area provides comparative information regarding the selected instance.
The information displayed in the Dashboard tab is influenced by the time frame you selected.See “Selecting a time frame” on page 29.
About the Main area in the Dashboard tab
...
Tier. Each row corresponds to an instance. The All row displays the average availability (%) of all instances. The following table shows the information displayed in the Instance table.
Table 4-1 Instance 1 Instance table
Column Description
...
Clicking on the various tabs in this area allows you to display overall activity, top performance findings, active sessions, current and statistical information for the selected instance. Clicking on the hyperlink for specific data items launches, in context, to the related tab from which the data was derived. See “Configuring Findings settings” on page 212.
The following table describes the information displayed in the Instance Details area.
Table 4-2 Information 2 Information displayed in the Instance Details area
...
Applications The Applications tab displays the top resource-consuming databases, programs and machines.
Table 4-2 Information displayed in the Instance Details area
...