Page History
...
From the Association area, you can also drill down to another entity by clicking a table row. A drilldown drill-down affects the whole tab: When you drill down to another entity, the Tab heading reflects the new selection, the Main area displays information on the newly selected entity, and the Association area shows data on its associated entities.
...
In the Association area, click the row of the database you want to view detailed information for. The Tab heading indicates the newly selected entity; the Main area displays an overview of the database you want to investigate, and the Association area shows general details on the tables that are associated with the database you selected. See For more information about Precise for Sybase tabs, see About Precise for Sybase tabs on page 15.
Anchor | ||||
---|---|---|---|---|
|
...
The headings in the Replication Agent Configuration Parameters main area are described below.
Table 7- 1 Replication Agent Configuration Parameters headers
Column | Description |
---|---|
Parameter Name | Displays the parameter name. |
Default Value | Displays the default value for each parameter. |
Configuration Value | Displays the configuration value for each parameter. |
Run Value | Displays the run value for each parameter. |
About the Database entity in the Association area
...
- I/O Size. Shows the size of the buffers in the pool. Specifies the amount of bytes that can be read at once. The default size of the pool is the size of the server's logical page.
- Config Size. The amount of memory space configured for the pool.
- Run Size. The amount of memory space currently assigned for the pool. The value may differ from the config size of the pool because one cannot explicitly configure its size. The value may differ for other pools if you have tried to move space between them, and some of the space could not be freed.
- Wash Size. Size of the Wash area. A portion of each pool is configured as the wash area. After dirty pages (pages that have been changed in cache) pass the wash marker and enter the wash area, Adaptive Server starts an asynchronous I/O on the page. When the write completes, the page is marked clean and remains available in the cache. The space in the wash area must be large enough so that the I/O on the buffer can complete before the page needs to be replaced. For more information, see the Precise Installation Guideand Administration.
- APF (%). Displays the percentage of the pool that can hold unused buffers brought in by asynchronous prefetch.
...
The table below describes the information displayed in the Performance tab.
Table 7- 2 Performance tab
Column | Description |
---|---|
Launch icon to SQL tab | Launches into SQL tab. |
Statement ID | Displays the statement ID. |
In Sybase | Displays the sum of each In Sybase parameter in the time period from the statistics table - bar with separated values or sum of all In Sybase values. |
Text | Displays the statement's text. |
The table below describes the information displayed in the Plan tab.
Table 7- 3 Plan tab
Column | Description |
---|---|
Launch icon to SQL tab | Launches into SQL tab. |
Statement ID | Displays the statement ID. |
Database | Displays the database name. |
Parsing User | Displays the parsing user name. |
Most Recent Plan | Displays the date of the most recent plan. |
Last Show Plan | Displays the date of the last shown plan. |
Total Estimate Cost | Displays a graph/number. |
Table Scan | Displays Yes or No. |
Clustered Index Scan | Displays Yes or No. |
Clustered Index Seek | Displays Yes or No. |
Index Scan | Displays Yes or No. |
Index Seek | Displays Yes or No. |
Table Lookup | Displays Yes or No. |
Sort | Displays Yes or No. |
Merge Join | Displays Yes or No. |
Join | Displays Yes or No. |
Nested Loop Join | Displays Yes or No. |
Parallel Access | Displays Yes or No. |
Anchor | ||||
---|---|---|---|---|
|
...
The table below describes the information displayed in the Performance tab.
Table 7- 4 Batch entity Performance tab
Column | Description |
---|---|
Launch icon to SQL tab | Launches into SQL tab. |
Batch ID | Displays the batch ID. |
In Sybase | Displays the sum of each In Sybase parameter in the time period from the statistics table - bar with separated values or sum of all In Sybase values. |
Text | Displays the text of the batch. |
The table below describes the information displayed in the Plan tab.
Table 7- 5 Batch entity Plan tab
Column | Description |
---|---|
Launch icon to SQL tab | Launches into SQL tab. |
Batch ID | Displays the batch ID. |
Database | Displays the database name. |
Parsing User | Displays the parsing user name. |
Most Recent Plan | Displays the date of the most recent plan. |
Last Show Plan | Displays the date of the last shown plan. |
Total Estimate Cost | Displays a graph/number. |
Table Scan | Displays Yes or No. |
Clustered Index Scan | Displays Yes or No. |
Clustered Index Seek | Displays Yes or No. |
Index Scan | Displays Yes or No. |
Index Seek | Displays Yes or No. |
Table Lookup | Displays Yes or No. |
Sort | Displays Yes or No. |
Merge Join | Displays Yes or No. |
Join | Displays Yes or No. |
Nested Loop Join | Displays Yes or No. |
Parallel Access | Displays Yes or No. |
Anchor | ||||
---|---|---|---|---|
|
...
- Use the Optdiag view in the Table or Index entity to observe fragmentation information.
- Determine whether the table or index is heavily fragmented and needs to be reorganized. See For more information about table and view entities, see About the Table entity and Tables Contain Same Column entity on page 69.
...
- and About the View entity and Views Contain Same Column entity
...
- .
Anchor | ||||
---|---|---|---|---|
|
...
To examine distribution statistics of indexes and columns, use the Statistics view of the Column entity to help you see the distribution of values in that column. See For more information about viewing these statistics, see About viewing density and selectivity statistics on page 73.See and About viewing column statistics on page 73.
Precise. Performance intelligence from click to storage. Learn more > >
...
.