Page History
...
| 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 About Precise for SQL Server tabs” on page 22, “About tabs, About the Current tab” on page 55, “About tab, About the Activity tab” on page 74, “About tab, About the Objects tab” on page 105, “About tab, About the Statistics tab” on page 147, “About tab, About the SQL tab” on page 162, “About tab, About the Maintenance tab” on page 186tab, and “About About the SmarTune tab” on page 203tab.
| Anchor | ||||
|---|---|---|---|---|
|
...
The information displayed in the Dashboard tab is influenced by the time frame you selected. See “Selecting Selecting a time frame” on page 29frame.
| Anchor | ||||
|---|---|---|---|---|
|
The instance table displayed in the Main area lists all the instances that are monitored by the Precise for SQL Server 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.
...
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 Configuring Findings settings.
The following table describes the information displayed in the Instance Details area.
...
| Tab | Information Displayed | ||
|---|---|---|---|
| Overview | The Overview tab displays In MS-SQL data and performance findings for the selected instance. | ||
| Applications | The Applications tab displays the top resource-consuming databases, programs and machines. | ||
| More | The following options are available in the More tab:
|
| Info |
|---|
If you select the All row, the information displayed reflects the average availability of all instances. The "Current" option option and the Findings table will not be available. |
...
The following table describes the information displayed in the Current Activity graphs.A
Table 14 Current activity graphs
...
For more information about how you can identify specific performance problems, see “How How the Dashboard can help you identify performance problems” on page 52problems.
| Anchor | ||||
|---|---|---|---|---|
|
...
- In the Time Frame list, choose the period of time you want to analyze.
- In the Instance Details area, click More... and and select Statistics. Observe CPU usage vs. load (number of transactions, batches and logins) and paging statistics.
- Launch to the Statistics tab to observe additional instance statistics that can help you locate performance problems in various other aspects of your system, such as I/O and Network statistics.
...
- In the Instance Details area, click More..., and select Current, observe all active sessions (sessions that executed statements during the last minute) and the In MS-SQL breakdown into states, such as, Using CPU, I/O wait, and Lock wait states.
- Launch to the Current tab to view additional information on current sessions. For example, if you identify a session suffering from lock wait during the last minute of activity, launch to the Current tab and analyze the locking tree to discover what is locking the session and why.
...
For more information, see the Precise Administration Guide.
To check SQL Server instance availability
- In the Time Frame list, choose the period of time you want to analyze.
- In the All SQL Server Instances table, check the current availability state of the instance you want to analyze. A status icon, located in the first column, shows the current availability of the instance. Move the pointer over the icon to display a ToolTip showing the current status of the instance and the date its status changed.
- Select the row of the instance you want to analyze. The average availability of the instance is displayed in the Availability column.
- In the Instance Details area, click More... and and select Availability. Check the Availability graph to view the availability of the selected instance with respect to the configured SLA and the log. See “How How Precise for SQL Server monitors availability” on page 38.availability.