Informix anomalies

The Informix collector allows to insert the following types of anomalies in an Anomalies Profile:

Cache read hit ratio

Percentage of time a required data block is found in the data cache. This alarm is raised when the data cache hit rate falls below the ranges defined by the thresholds. Low rates indicate Informix is doing a lot more disk reads than it should. If the values ae lower than 80%, you need to consider increasing the value of the BUFFERS paramter in your Informix Configuration file to achieve a higher read cache rate.

The default anomaly conditions are:

Severity 1: < 95%
Severity 2: < 90%
Severity 3: < 85%

Cache write hit ratio

Percentage of time a required data block is found in the data cache. This alarm is raised when the data cache hit rate falls below the ranges defined by the thresholds. Low rates indicate Informix is doing a lot more disk reads than it should. If the values ae lower than 80%, you need to consider increasing the value of the BUFFERS paramter in your Informix Configuration file to achieve a higher read cache rate.

The default anomaly conditions are:

Severity 1: < 87%
Severity 2: < 80%
Severity 3: < 75%

Rollback ratio

Percentage of time a transaction has been rolledback.

The default anomaly conditions are:

Severity 1: > 5 %
Severity 2: > 10 %
Severity 3: > 20 %

Disk sort ratio

This ratio records the proportion of sorts that were too large to be completed in memory.

The default anomaly conditions are:

Severity 1: > 5 %
Severity 2: > 10 %
Severity 3: > 20 %

Number of sessions opened

The default anomaly conditions are:

Severity 1: > 50
Severity 2: > 100
Severity 3: > 200
 

Percentage of locks waiting

Percentage of locks waiting to be granted. Any time a connection waits for another connection to complete its transaction, the overall response time for an application is affected.

Creating indexes on tables on which lots of update and delete are executed can resolve the problem.
The default anomaly conditions are:

Severity 1: > 15%
Severity 2: > 20%
Severity 3: > 25%





Go back to the Learning center:


Copyright © AgileLoad. All rights reserved.
Agile Load testing tool| Contact AgileLoad | Terms of Use | Sitemap