Page History
This section includes the following topics:
- About Precise for SQL Server tabs
- How most tabs are structured
- About drilling down in context
- About configuring your settings
- Tasks common to most tabs
- About role management in Precise for SQL Server
- Opening your Precise product from the Precise StartPoint
Anchor | ||||
---|---|---|---|---|
|
Precise for SQL Server continuously collects high-quality metrics from each supporting tier of your SQL Server-based custom applications infrastructure and correlates these metrics to build a clear picture of application performance from the end-user's perspective—that is, response time.
...
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 | ||||
---|---|---|---|---|
|
Though each tab is structured differently, most tabs consist of two different areas. Each area can include different control elements, such as tabs and view controls, and displays information in various formats, such as tables, graphs, or charts. The various areas are related to each other in that performing an action in one area affects the information displayed in other areas on the page. For example, the Current tab contains an upper and a lower area. The lower area (Association area) shows information in a table format. Each row in the table represents an application. The upper area (Main area) displays general information on the selected entity as well as related applications.
...
For more information, see “SQL Server Findings” on page 213.
Anchor | ||||
---|---|---|---|---|
|
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.
...
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.
Anchor | ||||
---|---|---|---|---|
|
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:
...
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.
Anchor | ||||
---|---|---|---|---|
|
The following tasks are commonly performed in most tabs:
...
Info |
---|
The favorite address is displayed in the Address field and cannot be edited. |
Anchor | ||||
---|---|---|---|---|
|
...
- 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.
Anchor | ||||
---|---|---|---|---|
|
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.
Anchor | ||||
---|---|---|---|---|
|
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.
...