Page History
...
Applications The Applications tab displays the top resource-consuming databases, programs and machines.
Table 4-2 Information displayed in the Instance Details area
Tab Information displayed
More The following options are available in the More tab:
...
■ The Current tab displays the overall activity and active sessions that occurred within the last minute for the selected instance.
Note: The Current tab is not available if All Instances is selected.
...
| Info |
|---|
...
If you select the All row, the information displayed reflects the average availability of all instances. The "Current" option and the Findings table will not be available. |
...
...
About gaining an overview of your system's performance
The Overview tab displays In MS-SQL data and performance findings for the selected instance. You can continue investigating a problem as follows:
...
- Click In MS-SQL to launch the Activity tab with an instance or Precise for SQL Server Tier context.
...
- Click Findings or a launch icon in the Findings table to launch to the SmarTune tab with the selected finding in context.
The following table describes the information displayed in the Overview tab.
Table 4-3 General 3 General instance data
General instance data Description
...
The following table describes the information displayed in the Databases table.
Table 4-4 Database 4 Database applications
Column Description
...
Sessions Total number of sessions opened.
Table 4-4 Database applications
Column Description
In MS-SQL In MS-SQL The resource consumption of the database broken down into states such as, Using CPU, I/O wait, Lock wait states.
Click on the respective icons to display the data in this column in a stacked graph, bar graph or numerical format.
The following table describes the information displayed in the Programs table.
Table 4-5 Program 5 Program applications
Column Description
...
Click on the respective icons to display the data in this column in a stacked graph, bar graph or numerical format.
The following table describes the information displayed in the Machines table.
Table 4-6 Machine 6 Machine applications
Column Description
...
Click on the respective icons to display the data in this column in a stacked graph, bar graph or numerical format.
About examining statistics for an instance
...
All items in this display launch the Statistics tab with an Instance or Precise for SQL Server Tier context. The following table describes the information displayed in the Statistics tab.
Table 4-7 Instance 7 Instance statistical data
Instance statistical data Description
...
Page faults Displays memory paging of the selected instance vs. memory paging caused by other processes (non-SQL Server).
About viewing top resource-consuming statements, logical files and storage devices The Activities tab, accessed from the More tab, displays the top resource-consuming statements, logical files and storage devices.
All entities in this display launch the Activity tab, in context of an instance or Tier. The following table describes the information displayed in the Statements table.
Table 4-8 Statement 8 Statement activities
Column Description
...
Click on the respective icons to display the data in this column in a stacked graph, bar graph or numerical format.
The following table describes the information displayed in the Logical Files table.
Table 4-9 Logical 9 Logical files activities
Column Description
...
I/O Wait Displays the total I/O waits registered for the file.
Click on the respective icons to display the data in this column in a stacked graph, bar graph or numerical format.
The following table describes the information displayed in the Storage Devices table.
Note: This information is only displayed if storage points are installed.
Table 4-10 Storage 10 Storage device activities
Column Description
...
I/O Wait Displays the total I/O waits registered for the device.
Click on the respective icons to display the data in this column in a stacked graph, bar graph or numerical format.
About viewing the availability of SQL Server instances
...
All entities in this display launch the Activity tab, in context of the instance or Tier.
The following table describes the information displayed on instance availability.
Table 4-11 Instance 11 Instance availability
Item Description
...
Log A detailed log of the changes in availability status.
About viewing your system's current activity
...
The following table describes the information displayed in the Session Activities area.
Table 4-12 Sessions12 Sessions
Item Description
Sessions Total number of sessions connected to the selected instance.
...
Locked sessions Total number of locked sessions.
The following table displays information on the active sessions that occurred within the last minute, for the selected instance.
Table 4-13 Active 13 Active sessions (last minute)
Column Description
...
In MS-SQL Total In MS-SQL entities for the session, occurring within the last minute, broken down into states (such as, Using CPU, I/O wait, and Lock Wait).
The following table describes the information displayed in the Current Activity graphs.A
Table 4-14 Current 14 Current activity graphs
Item Description
...
In MS-SQL (Last minute) Provides a graphical display of In MS-SQL activity that occurred within the last minute, for the selected instance, broken down into states, such as, Using CPU, I/O wait, and Lock Wait.
About the Findings area in the Dashboard tab
The Findings area in the Dashboard tab displays performance problems detected in the select instance(s). The findings list is displayed according to severity (highest to lowest).
To view the details of a specific finding, hover over the finding name. The area for the selected finding will expand, displaying information and recommended actions. Click on the relevant link to launch the appropriate tab in context, or Learn more to open the help for that finding.
For more information about how you can identify specific performance problems, see “How the Dashboard can help you identify performance problems” on page 52.
How the Dashboard can help you identify performance problems
You can identify a performance problem by doing one or more of the following:
...
- Identifying the most resource-consuming instance
...
- Analyzing top performance findings per instance
...
- Identifying the highest resource consumers in various entities
...
- Examining instance statistics
...
- Monitoring a session's activity during the last minute
...
- Checking SQL server instance availability
...
...
Identifying the most resource-consuming instance
...
To identify the most resource-consuming instance
...
- In the Time Frame list, choose the period of time you want to analyze.
...
- In the All SQL Server Instances table, observe the total In MS-SQL statistics and statement executions of the instance you want to analyze.
...
- Select the row of the instance you want to analyze.
...
- In the Instance Details area, on the Overview tab, check the In MS-SQL graph to view its resource consumption, over time, to identify problematic time periods and observe its general resource consumption trend.
...
- Check the Findings table to view the top problematic findings per instance.
...
...
Analyzing top performance findings per instance
...
To analyze top performance findings per instance
...
- In the Time Frame list, choose the period of time you want to analyze.
...
- In the All SQL Server Instances table, observe the total In MS-SQL statistics and statement executions of the instance you want to analyze.
...
- Click on an instance in the All SQL Server Instances table.
...
- In the Instance Details area, on the overview tab in the Findings table, observe the top findings for the selected instance. The findings displayed in this table are sorted by severity. Additional information and hot links for the selected findings is displayed in the Details area below the Findings table.
...
- In the Type column, click on the link to the instance that you want to analyze further or on the Findings link located above the table.
...
- In the SmarTune tab observe the data displayed on the finding in the various tables and graphs, and follow the links provided to view additional information on the problem in other tabs. The SmarTune tab also provides details and recommendations on how to solve a problem.
Identifying the highest resource consumers in various entities
Precise for SQL Server enables you to determine which are the most resource-consuming application components (such as, Databases, Programs, and Statements).
To identify the highest resource consumers in various entities
...
- In the Time Frame list, choose the period of time you want to analyze.
...
- In the All SQL Server Instances table, determine which instance consumes the most resources.
...
- Select the row of the instance you want to analyze.
...
- In the Instance Details area, on the Applications tab, identify the highest application resource consumers for the selected instance.
...
- In the Instance Details area, on the Activities tab, identify the highest activity resource consumers for the selected instance.
...
- Launch to the Activity tab to continue the performance tuning process on the selected component.
...
...
Note: The entities displayed in the Application tab will differ according to the ERP installed and will take into account that ERP's specific entities. For example, if you have SAP installed, the following types of entities are displayed: Work Types, Logins, SAP Users and Programs, and SAP Transactions.
Examining instance statistics
...
To examine instance statistics
...
- In the Time Frame list, choose the period of time you want to analyze.
...
- In the Instance Details area, click More... 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.
...
Monitoring a session's activity during the last minute
...
To monitor a session's activity during the last minute
...
- 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.
...
...
Checking SQL server instance availability
...
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 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 Precise for SQL Server monitors availability” on page 38.
...
Precise. Performance intelligence from click to storage. Learn more > >
...