Page History
...
Table 4-3 General instance data
General instance data Description
...
| General Instance Data | Description |
|---|---|
| In MS-SQL | Displays a breakdown of the total In MS-SQL duration over time, into states such as, Using CPU, I/O wait, and Lock Wait. |
| Findings |
...
| Lists all the statements, collapsed statements, tables or instance events that were detected for a specific instance. All problems are ranked by severity. The information displayed in the findings table is also displayed in the SmarTune tab. |
| Details for ... |
...
| Finding | Provides quick links to additional tabs and views that would be helpful in your analysis of a particular problem. |
...
About observing top resource-consuming entities
...
Table 4-4 Database applications
| Column | Description |
|---|---|
Column Description
Database The name of the top resource-consuming databases.
...
| Database | The name of the top resource-consuming databases. |
| Sessions | Total number of sessions opened. |
| 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 applications
| Column | Description |
|---|---|
Column Description
...
| Program | The name of the top resource-consuming programs. |
| Sessions |
...
| Total number of sessions opened. |
| In MS- |
...
| SQL | The resource consumption of the program 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 Machines table.
Table 4-6 Machine applications
| Column | Description |
|---|---|
Column Description
...
| Machine | The name of the top resource-consuming machines. |
| Sessions |
...
| Total number of sessions opened. |
| In MS- |
...
| SQL | The resource consumption of the machine 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. |
About examining statistics for an instance
...
Table 4-7 Instance statistical data
Instance statistical data Description
...
| Instance Statistical Data | Description |
|---|---|
| Server CPU | Displays the SQL Server instance CPU utilization for the selected instance with respect to the CPU utilization of other processes (non-SQL Server). |
| Load |
...
| Displays instance load, for the selected instance, broken down into batch requests/sec, transactions/sec, and logins/sec. |
| 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.
...
Table 4-8 Statement activities
| Column | Description |
|---|---|
Column Description
...
| Statement | Displays the ID of the top resource-consuming statements. |
| Duration (Avg) |
...
| Displays the average duration of the statement. | |
| In MS- |
...
| SQL | Displays the resource consumption of the statement broken down into states such as, Using CPU, I/O wait, and 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 Logical Files table.
Table 4-9 Logical files activities
| Column | Description |
|---|---|
Column Description
...
| Database | Displays the name of the file's database. |
| Logical |
...
| File | Displays the logical name of the file. |
| 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.
...
Table 4-10 Storage device activities
| Column | Description |
|---|---|
Column Description
...
| Device Type | Indicates a type of storage device, such as, Windows, HP, Symmetrix. |
| Unit |
...
| ID | Displays the ID of the device's unit. |
| Device |
...
| Displays the name of the device. |
| 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
...
Table 4-11 Instance availability
| Item | Description |
|---|---|
Item Description
...
| Availability | The average percentage of time the SQL Server instance was available. |
| 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 Sessions
| Item | Description |
|---|---|
Item Description
...
| Sessions | Total number of sessions connected to the selected instance. |
| Active |
...
| sessions | Total number of sessions currently active. |
| 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 sessions (last minute)
| Column | Description |
|---|---|
Column Description
...
| Icon | Represents the current session's state (such as, Lock Wait, Request Wait). |
...
| SPID | The session ID. |
| Program |
...
| The name of the program that opened the session. |
...
| State | The current state of the session. |
| 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 activity graphs
| Item | |
|---|---|
Item Description
| Description |
|---|
| Overall activity (Last minute) |
...
| Provides a graphical display of the overall activity that occurred within the last minute, for the selected instance, broken down into the following states: Idle Wait, Parallel Exchange Wait, Request Wait and In MS-SQL. | |
| 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
...
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
| Anchor | ||||
|---|---|---|---|---|
|
Precise for SQL Server enables you to determine which are the most resource-consuming instances, indicating a potential performance problem.
...
- 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.
| Anchor | ||||
|---|---|---|---|---|
|
The Dashboard tab helps you pinpoint performance problems by letting you observe the top problematic findings per instance, statement or object. You can then drill down on a finding and continue your analysis in the SmarTune tab, which provides important guidelines and clues as to what may be causing the performance problem.
...
- 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.
| Anchor | ||||
|---|---|---|---|---|
|
Precise for SQL Server enables you to determine which are the most resource-consuming application components (such as, Databases, Programs, and Statements).
...
| Info |
|---|
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. |
| Anchor | ||||
|---|---|---|---|---|
|
You can examine instance statistics over time to confirm that CPU and memory usage are within normal ranges. A continually high CPU usage may indicate the need to improve the application or to add more processes to the machine to enhance performance. In addition, a high number of page faults may indicate an inefficient SQL statement or lack of memory.
...
- 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.
| Anchor | ||||
|---|---|---|---|---|
|
Monitoring a session's activity during the last minute in SQL Server, can help you locate activities that deviate from the norm, such as locking and latch waits.
...
- 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.
| Anchor | ||||
|---|---|---|---|---|
|
It is possible to examine the availability of SQL Server instances and observe their current status as well as their level of availability over time. In addition, you can determine whether their level of availability meets the SLA standard defined in the SLA availability setting in AdminPoint.
...