Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

This section includes the following topic:

...

With the Load Data process parameters you are able to filter the Load Data results better, providing you with a better overview of the actual data. After selecting this parameter, you can select the instance for which you want to make changes to the default settings.

The following parameters that can be edited in AdminPoint>Warehouse Processes. Technology is the basis for the division of the process parameters:

...

Table of Contents

...

maxLevel

...

2
minLevel2

Info

PMDB processes will not be executed if any of the following collector instances is down: SQL Server, Oracle, Sybase, or DB2.

DB2

About the DB2 Explain Statements process parameters

...

ParameterDefault value
Purge plans data older than n days14
Save the last n plans for each Explain Statement3

J2EE

About the J2EE Load Data process parameters

...

ParameterDefault value
Collect only Top-N records1000
Number of executions over total service timeLow
Load Data30

Microsoft .NET

About the Microsoft .NET Perform SmarTune Analysis process parameters

...

ParameterDefault value
Too many queued ASP.NET requestsMaximum request queue length n queued items (5).
Long wait time for ASP.NET requestsMaximum request wait time n milliseconds (1000).
Incorrect ASP.NET API cache usage - low hit ratioMinimum cache hit ratio n percent (80).
Incorrect ASP.NET API cache usage - high turnover rateMaximum cache turnover ratio n turnovers/second (100).
Incorrect ASP.NET output cache usage - low hit ratioMinimum cache hit ratio n percent (80).
Incorrect ASP.NET output cache usage - high turnover rateMaximum cache turnover ratio n turnovers/second (100)
Too many ASP.NET errorsMaximum errors per request ratio (5).
Too many unhandled ASP.NET exceptionsMaximum 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 problemMaximum ratio garbage collection generations n percent (20).
Too many garbage collection calls by userMaximum number of induced garbage collection calls (0)
Too many exceptions thrownMaximum number of thrown exceptions per second (50).
Contention rate too highMaximum number of unsuccessful locks per second (50).
Incorrect connection string usageMaximum number of different connection strings to database (10).
Slow database open connectionMaximum database open connection time n seconds (2).
Slow database requests executionMaximum database execution time n seconds (10).
Slow page loadMaximum page load time n seconds (5).
Slow Web service invocationMaximum Web service invocation time n seconds (5).
Slow XML document loadMaximum XML load time n seconds (2).
Incorrect garbage collection usageMaximum number of garbage collection calls (0).
Slow serializationMaximum serialization time per invocation time ratio n percent (10).
Slow de-serializationMaximum de-serialization time per invocation time ratio n percent (10).
Too many calls for serializationMaximum number of serialization invocations per second (100).
Too many calls for de-serializationMaximum number of de-serialization invocations per second (100).
Incorrect usage of the Finalize methodMaximum number of calls to the finalized method (0).
Too many method invocationsMaximum method time n seconds (0.3). Maximum number of method invocations (100).
Too much time in lockMaximum time in lock n seconds (0.2).

Oracle

About the Oracle Collect Bind Variables process parameter

...

ParameterDefault value
Collect only Top-N records1000
Number of executions over total service timeLow

Operating system

About the Operating System Load Data process parameters

...

ParameterDefault value
Collect only Top-N records1000
Size of memory over total CPU timeLow
Include Process ID details in time slice summary levelCleared
Include Command and Process ID only got processes with CPU time greater than n seconds per time slice10
Mask command according toNo default value

Other

About the Other Load Data process parameters

...

ParameterDefault value
Collect only Top-N records1000
Number of executions over total service timeLow
Mask Client IP according toNo default value

PMDB

About the PMDB Purge Data process parameters

...

ParameterDefault value
Use Defaults30 seconds

SAP

About the SAP Load Data process parameters

...

ParameterDefault 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

SQL Server

About the SQL Server Collect Operational Statistics process parameters

...

ParameterDefault value
Preserve execution plan details6 months
Preserve access path and cost changes history18 months
Preserve schema change log6 weeks

Sybase

About the Sybase Collect Space Utilization process parameters

...

ParameterDefault value
Load only Top-N Statements information500

Tuxedo

About the Tuxedo Load Data process parameters

...

ParameterDefault value
Collect only Top-N records1000
Number of executions over total service timeLow

Web Load Data

About the Web Load Data process parameters

...

ParameterDefault value
Collect only Top-N URL records1000
Number of executions weight over average URL service +network timeMedium
Consider SLA breach when filtering dataSelected
Collect only Top-N page records100
Number of executions over average page response timeMedium
Consider SLA breach when filtering dataSelected
Collect Client IPCleared
Collect countryCleared
Collect stateCleared
Collect cityCleared
Mask Client IP according toNo default value
Mask Private IP according toNo default value

WebSphere MQ

About the WebSphere MQ Load Data process parameters

...