Page History
...
Table 7-1 Configurable process parameter and its default value
| Parameter | Default value |
|---|---|
| Explain only Top-N Statements (based on their In DB2 time) | 100 |
| Timeout if the Explain Process takes more than n minutes | 60 |
| Explain process stops after N Statements fail to be explained | 100 |
About the DB2 Explain New Statements process parameters
...
Table 7-2 Configurable process parameter and its default value
| Parameter | Default value |
|---|---|
| Explain only Top-N Statements (based on their In DB2 time) | 30 |
About the DB2 Load Data process parameters
...
Table 7-3 Configurable process parameter and its default value
| Parameter | Default value |
|---|---|
| Load only Top-N Programs information | 300 |
| Load only Top-N Statements information | 500 |
About the DB2 Purge Internal Data process parameters
...
Table 7-4 Configurable process parameter and its default value
| Parameter | Default value |
|---|---|
| Purge plans data older than n days | 14 |
| Save the last n plans for each Explain Statement | 3 |
About the J2EE Load Data process parameters
...
Table 7-5 Configurable process parameter and its default value
| Parameter | Default value |
|---|---|
| Collect only Top-N records | 1000 |
| Number of executions over total service time | Low |
| Load Data | 30 |
About the Microsoft .NET Perform SmarTune Analysis process parameters
...
Table 7-6 Configurable process parameters and their default values
| Parameter | Default value |
|---|---|
| Too many queued ASP.NET requests | Maximum request queue length n queued items (5). |
| Long wait time for ASP.NET requests | Maximum request wait time n milliseconds (1000). |
| Incorrect ASP.NET API cache usage - low hit ratio | Minimum cache hit ratio n percent (80). |
| Incorrect ASP.NET API cache usage - high turnover rate | Maximum cache turnover ratio n turnovers/second (100). |
| Incorrect ASP.NET output cache usage - low hit ratio | Minimum cache hit ratio n percent (80). |
| Incorrect ASP.NET output cache usage - high turnover rate | Maximum cache turnover ratio n turnovers/second (100) |
| Too many ASP.NET errors | Maximum errors per request ratio (5). |
| Too many unhandled ASP.NET exceptions | Maximum number of unhandled exceptions (0). |
| Too much time in garbage collection | Normal CPU utilizations n percent (70). Maximum time in garbage collection for low CPU utilization n percent (5). Maximum time in garbage collection for high CPU utilization n percent (10). |
| Object allocation problem | Maximum ratio garbage collection generations n percent (20). |
| Too many garbage collection calls by user | Maximum number of induced garbage collection calls (0) |
| Too many exceptions thrown | Maximum number of thrown exceptions per second (50). |
| Contention rate too high | Maximum number of unsuccessful locks per second (50). |
| Incorrect connection string usage | Maximum number of different connection strings to database (10). |
| Slow database open connection | Maximum database open connection time n seconds (2). |
| Slow database requests execution | Maximum database execution time n seconds (10). |
| Slow page load | Maximum page load time n seconds (5). |
| Slow Web service invocation | Maximum Web service invocation time n seconds (5). |
| Slow XML document load | Maximum XML load time n seconds (2). |
| Incorrect garbage collection usage | Maximum number of garbage collection calls (0). |
| Slow serialization | Maximum serialization time per invocation time ratio n percent (10). |
| Slow de-serialization | Maximum de-serialization time per invocation time ratio n percent (10). |
| Too many calls for serialization | Maximum number of serialization invocations per second (100). |
| Too many calls for de-serialization | Maximum number of de-serialization invocations per second (100). |
| Incorrect usage of the Finalize method | Maximum number of calls to the finalized method (0). |
| Too many method invocations | Maximum method time n seconds (0.3). Maximum number of method invocations (100). |
| Too much time in lock | Maximum time in lock n seconds (0.2). |
About the Oracle Collect Bind Variables process parameter
...
Table 7-7 Configurable process parameters and their default values
| Parameter | Default value | ||
|---|---|---|---|
| Maximum number of statements to collect binds for: | 20
| ||
| Maximum number of bind sets per statement to collect: | 3
| ||
| List of mandatory statements to collect binds for: | No default value |
About the Oracle Collect Instance Statistics process parameters
...
Table 7-8 Configurable process parameters and their default values
| Parameter | Default value | ||
|---|---|---|---|
| Collect segment statistics every n hours | 4
| ||
| Maximum number of segments to collect n | 500 | ||
List of mandatory segments n (such as EMP_TBL, EMP_DETP_IDX) | No default value |
About the Oracle Explain Statements process parameters
...
Table 7-9 Configurable process parameters and their default values
| Parameter | Default value |
|---|---|
| Explain only Top-N Statements (based on their In Oracle time) | 1000 |
| Parse Top-N Statements (based on their In Oracle time) | 1000 |
| Timeout if Explain takes more than n seconds | 60 |
| Save the last n Explain plans for each explained statement | 3 |
About the Oracle Load Data process parameters
...
Table 7-10 Configurable process parameter and its default value
| Parameter | Default value |
|---|---|
| Load only Top-N Programs information | 300 |
| Load only Top-N Statements information | 500 |
| Load only Top-N Objects information | 700 |
About the Oracle Object Statistics Changes process parameters
...
Table 7-11 Configurable process parameters and their default values
| Parameter | Default value |
|---|---|
| Keep track on changes in column statistics | Cleared |
| Collect database size statistics every n days | 1 |
About the Oracle Perform SmarTune Analysis on Changes process parameter
...
Table 7-12 Configurable process parameter and its default value
| Parameter | Default value |
|---|---|
| Analyze the impact of changes in the last n days | 30 |
About the Oracle Purge Data process parameters
...
Table 7-13 Configurable process parameters and their default values
| Parameter | Default value |
|---|---|
| Purge schema changes data older than n weeks | 52 |
| Purge database structure data older than n weeks | 26 |
About the Oracle Real Execution Plans process parameter
...
Table 7-14 Configurable process parameter and its default value
| Parameter | Default value | ||
|---|---|---|---|
| Maximum number of statements to collect actual execution plans for | 500
|
About the Oracle Applications Load Data process parameters
...
Table 7-15 Configurable process parameter and its default value
| Parameter | Default value |
|---|---|
| Collect only Top-N records | 1000 |
| Number of executions over total service time | Low |
About the Operating System Load Data process parameters
...
Table 7-16 Configurable process parameters and their default values
| Parameter | Default value |
|---|---|
| Collect only Top-N records | 1000 |
| Size of memory over total CPU time | Low |
| Include Process ID details in time slice summary level | Cleared |
| Include Command and Process ID only got processes with CPU time greater than n seconds per time slice | 10 |
| Mask command according to | No default value |
About the Other Load Data process parameters
...
Table 7-17 Configurable process parameter and its default value
| Parameter | Default value |
|---|---|
| Collect only Top-N records | 1000 |
| Number of executions over total service time | Low |
| Mask Client IP according to | No default value |
About the PMDB Purge Data process parameters
...
Table 7-18 Configurable process parameters and their default values
| Parameter | Default value |
|---|---|
| Purge slice data older than | 4 weeks |
| Purge hour data older than | 4 weeks |
| Purge daily data older than | 3 months |
| Purge weekly data older than | 12 months |
| Purge monthly data older than | 24 months |
About the PMDB Calculate Baselines process parameters
...
Table 7-19 Configurable process parameters and their default values
| Parameter | Default value |
|---|---|
| Retrieve data from the n Summary tables | Daily |
| Calculate based on last n day(s) | 64 |
About the PMDB Maintenance (Weekly) process parameters
...
Table 7-20 Configurable process parameters and their default values
| Parameter | Default value |
|---|---|
| Purge data of instances that are no longer monitored | Cleared |
| Purge job history after n days | 7 |
| Defragmentation threshold after n percent | 50 If the value is 100, no defragmentation is performed. |
About the PMDB Summarize Data process parameters
...
Table 7-21 Configurable process parameters and their default values
| Parameter | Default value |
|---|---|
| Summarize to daily level, only for top n rows | 2000 rows |
| Summarize to weekly level, only for top n rows | 3000 rows |
| Summarize to monthly level, only for top n rows | 3000 rows |
About the PMDB Daily Purge Data process parameters
...
Table 7-22 Configurable process parameters and their default values
| Parameter | Default value |
|---|---|
| Purge short slice data older than n days | 1 day |
About the PMDB Load Data process parameters
...
Table 7-23 Configurable process parameters and their default values
| Parameter | Default value |
|---|---|
| Use Defaults | 30 seconds |
About the SAP Load Data process parameters
...
Table 7-24 Configurable process parameter and its default value
| Parameter | Default value |
|---|---|
| Load only transactions with service time greater than or equal to n seconds per time slice | 0 |
About the SAP Organizational Mapping process parameters
...
Table 7-25 Configurable process parameter and its default value
| Parameter | Default value |
|---|---|
Maps each organization, as it appears in the SAP system, to the physical site where its employees are located. Each organization can be mapped to more than one location. This mapping data is used to show SAP workload statistics according to locations. | Daily |
About the SQL Server Collect Operational Statistics process parameters
...
Table 7-26 Configurable process parameter and its default value
| Parameter | Default value |
|---|---|
| Maximum number of objects to collect: | 500 |
About the SQL Server Collect Schema Changes process parameters
...
Table 7-27 Configurable process parameters and their default values
| Parameter | Default value |
|---|---|
| Load instance definition changes | Selected |
| Load SQL Server Agent jobs definition changes | Selected |
| Load database schema changes | Selected |
| Load database schema changes in syscolumns | Selected |
| Load database schema changes in sysindexkeys | Selected |
About the SQL Server Collect Space Utilization process parameters
...
Table 7-28 Configurable process parameters and their default values
| Parameter | Default value |
|---|---|
| Load DB files size information | Selected |
| Load table and indexes space information | Selected |
| Load partition size information (for 2005 only) | Cleared |
About the SQL Server Explain Statements process parameters
...
Table 7-29 Configurable process parameters and their default values
| Parameter | Default value |
|---|---|
| Explain only the to n batches (based on their In MS-SQL time) | 1000 |
| Do not explain statements that were explained in the last n days | 14 |
About the SQL Server Explain New Statements process parameters
...
Table 7-30 Configurable process parameter and its default value
| Parameter | Default value |
|---|---|
| Explain only Top-N batches (based on their In MS-SQL time) | 30 |
About the SQL Server Load Data process parameters
...
Table 7-31 Configurable process parameter and its default value
| Parameter | Default value |
|---|---|
| Load only Top-N Statements information | 500 |
About the SQL Server Perform SmarTune Analysis process parameters
...
Table 7-32 Configurable process parameters and their default values
| Parameter | Default value |
|---|---|
| Check the following | Findings of Top-N Statements (20) Findings of Top-N Objects (10) History activity for last n days (7) Minimum cost of heavy operators n percent (1) |
| Top statements should have | Minimum In MS-SQL n minutes/hour (1) |
| Scalability change for top statements | Increase in total executions of n percent (10) |
| Considered problematic for top statements | In MS-SQL increased at least by n percent (20) Lock wait time exceeds n percent (10) |
| Top objects should have | Minimum n pages (100) Minimum IN MS-SQL n minutes per hour (15) |
| Major growth of an object defined by | Increase of n rows (10000) Increase of n pages (20) |
| Scalability change for top objects | Increase in total executions of n percent (10) |
| Considered problematic for top objects | In MS-SQL increased by at least n percent (10) Lock wait time exceeds n percent (20) |
| Instance is locked when | Lock wait time exceeds n percent (10) |
| Tempdb is considered a bottleneck when | Tempdb wait time exceeds n percent (10) |
| Buffer cache is considered to be too small when | Buffer cache hit ratio counter is less than n percent (90) Number of buffers written by lazy writer is more than n buffers per second (20) Data pages stay in buffer less than n seconds (300) SQL Server page faults is less than n per second (20) I/O wait time exceeds n percent (5) |
| Other applications influence SQL Server memory resources | SQL Server page faults/sec. exceeds n (20) Non SQL Server page faults/sec. is less than n (20) SQL Server memory is less than n percent of total memory (30) |
| Other applications influence SQL Server CPU resources | SQL Server CPU is less than n percent (20) Non SQL Server CPU exceeds n percent (50) Minimum CPU queue length n (2) |
| Transaction log is considered a bottleneck when | Log wait time exceeds n percent (10) The average log flushes/sec. is greater than n (100) The average log flush waits/sec. is greater than n (10) Log flush wait time exceeds n minutes per hour (5) |
| Statement Findings | The access plan of the statement contains heavy operators (selected) The access plan of the statement has issued a missing indexes warning (selected) Statements accessing the object have missing statistics warnings (selected) The average In MS-SQL time has increased due to a schema change (selected) The average In MS-SQL time increased due to a growth in statement executions (selected) The average In MS-SQL time increased due to a growth in tables (selected) The average In MS-SQL time has increased (but the increase is not due to schema changes, table size or scalability) (selected) The total In MS-SQL time of the statement is consistently high (selected) The statement's lock wait time is very high (selected) |
| Object Findings | Statements accessed the object using heavy operators (selected) Statements accessing the object have missing indexes warnings in their access plan (selected) Statements accessing the object have missing statistics warnings in their access plan (selected) Total In MS-SQL time has increased due to a schema change (selected) Total In MS-SQL time has increased due to a major growth in table size (selected) Total In MS-SQL time has increased due to major growth in total executions of statements (selected) Total In MS-SQL time has increased (but the increase is not due to schema changes, table size or scalability) (selected) The object has unnecessary indexes (containing many updates that are not in use by any SELECT statement) (selected) The object's lock wait time is very high (selected) |
| Instance Findings | Extensive lock wait time (selected) Tempdb is a bottleneck (selected) Buffer cache is too small (selected) Other applications influence SQL Server memory resources (selected) Other applications influence SQL Server CPU resources (selected) The transaction log file is a bottleneck (selected) |
About the SQL Server Purge Internal Data process parameters
...
Table 7-33 Configurable process parameters and their default values
| Parameter | Default value |
|---|---|
| Preserve execution plan details | 6 months |
| Preserve access path and cost changes history | 18 months |
| Preserve schema change log | 6 weeks |
About the Sybase Collect Space Utilization process parameters
...
Table 7-34 Configurable process parameters and their default values
| Parameter | Default value |
|---|---|
| Load devices space information | Selected |
| Load table and indexes space information | Selected |
| Load segments space information | Selected |
About the Sybase Explain Statements process parameters
...
Table 7-35 Configurable process parameters and their default values
| Parameter | Default value |
|---|---|
| Explain only Top-N Batches (based on their In Sybase time) | 1000 |
| Do not explain statements that were explained in the last n days | 14 |
About the Sybase Explain New Statements process parameters
...
Table 7-36 Configurable process parameter and its default value
| Parameter | Default value |
|---|---|
Explain only TopN Batches (based on their In Sybase time) | 10 |
About the Sybase Load Data process parameters
...
Table 7-37 Configurable process parameter and its default value
| Parameter | Default value |
|---|---|
| Load only Top-N Statements information | 500 |
About the Tuxedo Load Data process parameters
...
Table 7-38 Configurable process parameter and its default value
| Parameter | Default value |
|---|---|
| Collect only Top-N records | 1000 |
| Number of executions over total service time | Low |
About the Web Load Data process parameters
...
Table 7-39 Configurable process parameters and their default values
| Parameter | Default value |
|---|---|
| Collect only Top-N URL records | 1000 |
| Number of executions weight over average URL service +network time | Medium |
| Consider SLA breach when filtering data | Selected |
| Collect only Top-N page records | 100 |
| Number of executions over average page response time | Medium |
| Consider SLA breach when filtering data | Selected |
| Collect Client IP | Cleared |
| Collect country | Cleared |
| Collect state | Cleared |
| Collect city | Cleared |
| Mask Client IP according to | No default value |
| Mask Private IP according to | No default value |
About the WebSphere MQ Load Data process parameters
...
Table 7-40 Configurable process parameters and their default values
| Parameter | Default value |
|---|---|
| Collect only Top-N records | 1000 |
| Number of executions over total service time | Low |
| Collection mode: | Basic |
| In extended collection mode, collect from the message body the first n bytes | 250 |
| Include only messages with service time greater than n seconds per time slice | 1 |
| Include only messages that pass through queues that met one of the patterns in | No default value |
| Include only users that met one of the patterns in | No default value |
| Include only messages of applications that met one of the patterns in | No default value |
| Include only messages that their body met one of the patterns in | No default value |
...