Page History
...
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
...
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 | ||||
---|---|---|---|---|
|
...
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. For more information about viewing these statistics, see About viewing density and selectivity statistics and About viewing column statistics.
Precise. Performance intelligence from click to storage. Learn more > >