Page History
...
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.
...
For more information, see “SQL Server Findings” on page 213.
About drilling down in context
The term 'in-context' means that you can display additional information on a selected item by drilling down to another tab or view. The filter settings you defined (for example, the selected time frame you chose) and the entity you selected are carried over to the other view or tab, to allow you to continue analyzing your subject from a different perspective. This concept takes on slightly different meanings depending upon where you are attempting to drill down in context from.
...
In short, the information displayed when drilling down in context is always related to your original selection’s settings.
How a
...
drill-down affects the Tab heading
The Tab heading displays the name of the currently selected entity on this screen. When you drill down to a new entity in the Association area, the Tab heading changes to reflect the name of the newly selected entity. See “How most tabs are structured” on page 23.
About configuring your settings
The following settings allow you to control the appearance and behavior of the user interface. They can be configured from the Settings menu on the Precise bar:
- General settings - Includes the General, Display, and Tree view tabs.
- SmarTune settings
- Time Frame settings
About configuring general settings
On the General tab of the General Settings dialog box, you can adjust the following:
- Number of items that will be displayed for each association. From the list, select the maximum number of items that will be displayed in a table. The default is 50 items. You can control the number of items returned for a specific association by using the More... option in the Association controls. This way, you can display up to 500 items.
- Maximum number of characters to display in a text ToolTip. When you move your cursor over text columns in a table listing Statements or PL/SQLs, a ToolTip appears, displaying more text than can normally fit into a table cell. This field controls the maximum number of characters that can be displayed. The default is 500 characters.
- How often the information in the Current tab is refreshed. If you select the Auto-refresh Current tab every check box, the Current tab automatically refreshes at the specified interval. By default, the tab is not refreshed automatically. If you select this option, the default refresh interval is every five minutes.
About configuring tuner settings
In the Tuner tab you can change the Login name and Password used when launching Microsoft® SQL Server Query Analyzer and the Recommend Indexes processes.
About configuring display settings
When you drill down to or choose a different entity, selecting the option on the Display tab of the General Settings dialog box allows you to maintain the selected view or tab when changing from one tab to another. This is sometimes referred to as sticky tabs.
About configuring Tree view settings (Only applies to Precise products that include a Tree view)
On the Tree View tab of the General Settings dialog box, you can adjust the following:
- Number of categories to display when expanding an item.
- Number of items to display when expanding a category.
About configuring SmarTune settings
You control the maximum number of findings to display in the Findings area and whether or not you want to ignore findings, in the SmarTune settings dialog box. See “Configuring Findings settings” on page 212.
About configuring Time Frame settings
You can determine the resolution of the data that is displayed in the overtime graphs using the Time Frame Settings dialog box. By using this dialog box you can define the default time frame to display.
Tasks common to most tabs
The following tasks are commonly performed in most tabs:
- Switching to a different tab
- Selecting a time frame
- Selecting an entity
- Filtering data
- Associating entities with data that meets specific criteria
- Focusing on information in overtime graphs
- Sending an email message
- Adding, viewing, and deleting Favorites
- Determining which table columns to display
- Copying data to the clipboard
- Exporting to the Precise Custom Portal
- Exporting to the Precise Custom Portalinformation
Switching to a different tab
You can easily switch between the different tabs using the Tab Selection bar. When you start your Precise product, the Dashboard tab opens by default. For other Precise products, another tab will open by default. The button of the selected tab is displayed in orange.
To select a tab, click a button on the Tab Selection bar to display information on the selected entity in a different tab.
Selecting a time frame
You can configure Precise for SQL Server to display transaction performance data for a specific time frame using the predefined time frame options or calendar icons.
...
- Click the calendar icon. In the dialog box that is displayed perform one of the following:
- To define a time frame independent from the current time, select the ‘Time Range’ option and select the Start and End dates and times.
- To define a time frame up to the current time, select the ‘Last’ option and enter the desired time frame.
- To use one of the three previously used time frames, select the ‘Recently used’ option and from the drop-down menu select the desired time frame.
- To use a previously saved time frame, select Use a previously saved time frame and from the drop-down menu select the desired time frame.
- To save your settings for future access, select Save these definitions for future use as: and enter a name in the corresponding field.
- Click OK.
Selecting an entity
You can select the entity that you want to examine in more detail.
To select an entity, on the Main area of the tab, select the entity you want to examine.
Filtering data
You can focus on specific contents of the Dashboard and Activity tabs by showing a subset of the information. This shows the contribution of entities such as programs and users.
...
- Click Filter is Off/Filter is On.
- In the Filter dialog box, do the following for each entity you want to filter:
- From the left drop-down list, select an entity.
- From the middle drop-down list, select an operator, such as, Like, <>, Not Like, In, Not In.
- In the text box, type the criteria (case-sensitive) for the selected entity.
- If you select the operator Like or Not Like, you can use the % wildcard character to represent 0 or more characters, and the _ wildcard character to represent exactly one character. If you select the operator In or Not In, type a comma to separate values.
- Click OK.
Associating entities with data that meets specific criteria
You can associate the displayed entity with specific data to focus your analysis.
...
The new statement is saved in the PMDB in a logical cabinet and folder hierarchy.
Focusing on information in overtime graphs
Some entities display an overtime graph. The overtime graph displays entity statistics over a specified time period. Depending on the number of points displayed in the graph, you may need to zoom in or out. The text displayed on the x-axis varies according to the time frame. If there is a year or day change, x-axis labels will display accordingly.
To focus on information in overtime graphs, select the desired time frame on the overtime graph, click and drag the left or right handle to increase or decrease the time range. The small zoom (spyglass) icon will display on the upper right of the selected time range, and above the overtime graph legend. Click the zoom icon to zoom in according to the selected time frame.
Sending an email message
You can send an email message to one or more recipients from the Precise toolbar. The default subject for the message will be “Link to a Precise application”.
...
- Click the email icon on the Precise toolbar. The default email program opens.
- Fill in the required fields and click Send.
Adding, viewing, and deleting Favorites
The Favorites feature allows you to save a specific location in your application and to retrieve the same location later without having to navigate to it.
...
Note: The favorite address is displayed in the Address field and cannot be edited.
Determining which table columns to display
Tables are used to display information about a set of related entities in the Main and Association areas. It is possible to determine which columns to display in the Association area tables.
...
- Click the Table icon on the upper right-hand side of a table and select Column Chooser.
- In the Table columns dialog box, click the arrows to move the names of the columns that you want to display to the Visible box and the ones that you do not want to display to the Invisible box.
- Click OK.
Copying data to the clipboard
At times you may want to save data displayed in the table area in a Microsoft Excel spreadsheet for further analysis or save an image of a graph to the clipboard.
...
You can now paste the image into any application that works with the clipboard.
Exporting to the Precise Custom Portal
The Export to the Precise Custom Portal Portlet feature enables you to export the view of the chosen table or graph and generate a portlet with that view in the Precise Custom Portal, so that it will provide you with another way of monitoring your application.
...
If you do not have sufficient rights, you will get an error message when trying to execute this feature.
Exporting the information
You can either export a table view or a graph view.
...
- Right-click the graph.
- Select Export to the Precise Custom Portal Portlet.
- Insert a name in the name field that clearly describes the graph view.
- Click OK.
About role management in Precise for SQL Server
The Roles management feature in Precise for SQL Server lets you assign roles to users and control whether they will be able to do the following operations:
...
For more information on configuring permissions and roles, see the Precise Administration Guide.
Opening your Precise product from the Precise StartPoint
Precise is a Web-based application. You can access the Precise user interface using the Internet Explorer browser, version 6.0 or later. The syntax of the Precise URL address is: http://<server>:<port>, where <server> refers to the Precise FocalPoint server and <port> refers to the port number used by the GUI Web server. By default, the port number is 20790 (20760 for J2EE). For example: http://beanotown:20790.
This URL provides secure access to the StartPoint using authorized roles. From here, you can launch all Precise products. It gives you a quick overview of the status of your applications and access to the AdminPoint, where you can perform various management tasks (see the Precise Administration Guide for details).
| Info |
|---|
...
You must have local administrator privileges on the server where the StartPoint is running. |
To open your product using Precise StartPoint
- Type the address of the StartPoint user interface into the Address bar of your browser and Click 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.
...