Page History
...
The SmarTune process detects performance deterioration by regularly analyzing SQL Server performance data, and identifying less than optimal behavior.Note:
| Info |
|---|
You can change the frequency of how often the processes are run and configure the process parameters in AdminPoint. See the Precise Administration Guide for details. |
SmarTune displays performance findings that may indicate potential problems in the database. The list of problems includes the following:
...
You can access the SmarTune tab from the following locations:
- From the Dashboard.
Select the SmarTune icon in the Findings table, for a given instance.
The SmarTune tab opens with the selected instance, displaying the findings for this instance, in the context of the selected instance and timeframe. - From the Activity tab.
Click SmarTune on the Tab Selection bar.
The SmarTune tab opens with the selected instance, displaying the findings for this instance, in the context of the selected instance and timeframe. - From the Current, Objects, or Maintenance tabs.
Click SmarTune on the Tab Selection bar.
The SmarTune tab opens with the selected instance, displaying the findings for this instance, in the context of the selected instance.
...
The SmarTune tab is divided into two areas—the Findings area and the Details area. The Findings area displays all findings returned by SmarTune for the selected time frame. The Details area provides detailed information regarding the selected finding.
About the Findings area in the SmarTune tab
The Findings area lists all the statements, collapsed statements, tables or instance events that were detected for a specific instance, within the selected time frame. All problems are ranked by severity. An Ignore icon, lets you decide if you want to remove a problem from the Findings table. This does not mean that SmarTune will stop checking these findings, rather that they will not be displayed in the Findings table. Clicking on an item in the Findings list refreshes the information displayed in the Details area.
...
| Column | Description |
|---|---|
| Severity Icon | Indicates how severe the detected problem really is. Calculates the severity of the finding in relation to the entire instance. |
| Type | Indicates the type of finding. Can be one of the following:■ Heavy
|
| Object | Depending on the type of finding, displays one of the following:■ For
|
| In MS-SQL | Depending on the type of finding, displays one of the following:■ For
|
| Database | Displays the name of the statement or object affected by the finding. The field is left empty in the case of an instance event finding.
|
| User | Depending upon the type of finding, displays one of the following:■ for
|
| Last Detected | Displays the last time the finding was found. |
| Ignore Icon | Click to ignore a finding. The finding is added to an Ignore list and is no longer displayed in the Findings table. You can always redisplay a finding by turning off the Ignore list or by specifying which findings you want to restore in the Ignore list. |
...
Table 12-2 About severity icons
| Severity Icon | Level of Severity |
|---|
...
Low
Medium
...
 | Low |
 | Medium |
 | High |
About the Details area in the SmarTune tab
The Details area displays comprehensive information on the problem selected in the Findings area. A set of tabs lets you page through different views to gain additional information on the selected finding. The types of tabs, and the information displayed in them, changes according to the type of finding you chose to investigate in the Findings area.
...
Table 12-3 Information displayed in the Details area when a statement is selected
| Tab |
|---|
Tab Information displayed
...
| Information Displayed | |
|---|---|
| Highlights | Offers a quick overview of the major finding details. |
...
The Text area displays the actual text of the statement. The Statement Findings area presents an overview of all the findings detected within a time frame, for the selected statement. |
...
|
...
|
...
|
...
|
...
|
...
The Details for Finding area points you in the direction of additional tuning and findings-related data. They direct you to other tabs that can supply additional information regarding the specific finding, or to additional views within the SmarTune tab, so that you can view additional information about the specific finding. |
...
| Objects | Displays the list of objects appearing in a statement, that are part of the performance finding. For example, Objects area can indicate if a table or index is part of the heavy operators finding, or if a table has missing indexes or statistics. |
| Over |
...
| Time | Displays the following overtime graphs: |
...
|
...
|
...
|
...
|
...
|
...
|
The following table shows the information displayed for problematic objects.
Table 12-4 Information displayed in the Details area when an object is selected
| Tab |
|---|
Tab Information displayed
...
| Information Displayed | |
|---|---|
| Highlights | Offers a quick overview of the major finding details, such as the table's details, and a description of the findings, including an estimate of the potential improvement to performance if you choose to make the suggested change. |
...
|
...
|
...
|
...
|
...
The Details for Finding area points you in the direction of additional tuning and findings-related data. They direct you to other tabs that can supply additional information regarding the specific finding, or to additional views within the SmarTune tab, so that you can view additional information about the specific finding. |
...
| Statements | Displays a list of statements that accessed a table, during the selected time period. |
| Over |
...
| Time | Displays the following overtime graphs: |
■ Storage
|
...
|
...
|
The following table shows the information displayed for problematic objects.
Table 12-5 Information displayed in the Details area when a collapsed statement is selected
| Tab |
|---|
Tab Information displayed
...
| Information Displayed | |
|---|---|
| Highlights | The Text area displays the actual text of the collapsed statement. |
...
The Collapsed Statement Findings area presents an overview of all the findings detected within a time frame, for the selected collapsed statement. |
...
|
...
|
...
|
...
|
...
|
...
The Details for Finding area points you in the direction of additional tuning and findings-related data. They direct you to other tabs that can supply additional information regarding the specific finding, or to additional views within the SmarTune tab, so that you can view additional information about the specific finding. |
| Statements |
...
| Displays the list of statements belonging to the same collapsed statement, that were executed during the selected time period. |
| Over |
...
| Time | Displays the following overtime graphs: |
...
|
...
|
...
|
...
|
The following table shows the information displayed on findings, at the instance level. Findings at the instance level check general behavior and statistics counters and give a general indication of the problems influencing instance performance.
Table 12-6 Information displayed in the Details area when an instance is selected
| Tab |
|---|
Tab Information displayed
...
| Information Displayed | |
|---|---|
| Highlights | Offers a quick overview of the major finding details. |
...
The text area describes the problem, displays thresholds and provides links to other tabs that can supply additional information regarding the specific finding, or to additional views within the SmarTune tab, so that you can view additional information about the specific finding. The graph presents information that is relevant to the specific finding or instance event. |
| Activities |
...
For: Locked Instance |
...
|
...
For: Tempdb bottleneck |
...
|
...
|
...
|
...
|
...
| Statistics | For: The transaction log bottleneck |
...
|
...
For: Buffer cache is too small |
...
|
...
|
...
For Tempdb bottleneck, three graphs showing tempdb statistics: |
...
|
...
|
...
|
About Statement findings
SmarTune displays the top statements occurring in a time slice. A SmarTune time slice is updated on an hourly basis. Top statements are the statements that have the highest In MS-SQL time, computed without lock time and remote wait time, that were running more than a specified number of minutes, during the time slice.
...