Page History
This section includes the following topics:
- About the SmarTune tab
- About accessing the SmarTune tab
- How the Precise for SQL Server SmarTune tab is structured
- Configuring Findings settings
| Anchor | ||||
|---|---|---|---|---|
|
The SmarTune process detects performance deterioration by regularly analyzing SQL Server performance data, and identifying less than optimal behavior.
...
As part of the guidance provided, SmarTune includes Quick Links to launch to other tabs in context, so that you can easily continue your investigation. For example, you may be directed to the Activity tab to view the performance of an offending SQL statement. From there, you can launch to the SQL tab to examine the statement's execution plan and view a recommendation on a new index.
| Anchor | ||||
|---|---|---|---|---|
|
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.
| Anchor | ||||
|---|---|---|---|---|
|
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.
...
The SQL Server instance has spent much of its time waiting for Internal Wait.
| Anchor | ||||
|---|---|---|---|---|
|
You determine the maximum number of findings to display in the Findings area.
...