Page History
...
The following table describes which tasks can be performed in each tab.
Table 2- 1 Precise for SQL Server tabs
Tab | Description |
---|---|
Dashboard | Allows you to quickly identify which SQL Server instance has a performance problem, providing the first glimpse into where the problem lies. |
Current | Allows you to solve the performance problems that are happening now. |
Activity | Allows you to examine application performance over time and helps locate performance bottlenecks. |
Objects | Allows you to identify which SQL Server objects are used inefficiently by the application, and their effect on the application components. |
Statistics | Allows you to identify performance bottlenecks in the way SQL Server instance resources are used. |
SQL | Allows you to tune problematic SQL statements or stored procedures. |
Maintenance | Displays information on SQL Agent activities and other SQL Server activities related to DBA. maintenance tasks. |
SmarTune | Displays performance findings that may indicate potential problems in the instance. The list of problems includes the following:
|
Anchor | ||||
---|---|---|---|---|
|
...
In the Association area, click the row of the application you want to view detailed information for. The Tab heading indicates the newly selected entity; the Main area displays information on the application you drilled down to, and the Association area shows information on statements executed by this application.
Figure 2- 1 How a typical tab is structured
...
The Precise bar enables you to keep track of where you have been and provides various controls. The following table describes the function of each of the toolbar buttons.
Table 2-2 Precise bar functions
Icon | Name | Description |
---|---|---|
Back | During a work session, keeps track of where you have navigated to. The Back and History buttons enable you to navigate between previously visited views. The Back control displays your previous view. | |
Forward | Enables you to navigate to the next view. This button is only enabled if you clicked Back or if you chose a history option. | |
AdminPoint | Opens Precise AdminPoint. | |
Home | Navigates to the highest level entity, usually the instance or Tier (all instances). The time frame settings remain the same. | |
Stop | Stops a request for information from the server. | |
Refresh | Updates the data currently displayed. | |
Favorites | Enables you to add or remove favorites in your Favorites list. | |
Send | Opens a new email message in your email program with the link to the current application in context. | |
Settings | Opens the General Settings and Time Frame Settings dialog boxes. | |
Help | Opens the online help in context. |
About the Main area
The Main area displays general information on the selected entity. The structure of this area depends on the selected entity and tab.
...
The table below describes the information that is displayed in the Findings area.
Table 2- 3 Information displayed in the Findings area
Column | Description | ||
---|---|---|---|
Severity | The severity of the finding is calculated using a formula. The position of the finding in the list is determined by an internal scoring system that is based on the knowledge of Precise product experts. The severity is indicated by the following colors:
By default, findings are displayed according to severity. | ||
Finding | A short name of the Finding. | ||
Context | Entity/Method name (unless specified for the whole instance). The entity/method name is a short name but the long name is displayed in the ToolTip. Some of the findings are identified in specific Methods while others are relevant for the entire instance. In the latter case, a finding is specified as an instance-related finding.
| ||
Finding overview | Displays specific details regarding the finding in context.
| ||
Learn more (advice) | Provides recommendations for solving the selected finding. For each finding, it lists all relevant pieces of advice and all applicable solutions. You should carefully review all data for the finding and then choose the advice that best suits your needs.
| ||
Proceed with the following (bullets) | Provides expert knowledge about the selected finding. The information displayed will direct you if you have difficulties deciding which advice to take or which solution to implement.
|
Investigating a finding
Perform the following steps to investigate a finding.
...
- Type the address of the StartPoint user interface into the Address bar of your browser and click Enter. The Precise login page opens. The login page provides secure access to Precise and to your specific product.
- Specify your authorized role name and password. By default, both role name and password are admin. For more information about role names, see the Precise Administration Guide.
- Click Login. The StartPoint page opens. This is the Precise home page.
- On the Product Selection bar, from the drop-down list, select the product you want to open.
Precise. Performance intelligence from click to storage. Learn more > >
...