Kbase P107915: How to measure the performance impact of auditing a database?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
12/29/2008 |
|
Status: Verified
GOAL:
How can I measure the performance impact of auditing a database?
GOAL:
How to view performance impact associated with auditing?
FACT(s) (Environment):
All Supported Operating Systems
OpenEdge 10.1x
OpenEdge 10.2x
FIX:
There is no specific performance metric which isolates auditing from the rest of the system as it is treated by the database as any other table.
To find auditing specific performance impact without looking at a before and after picture is done just like identifying the performance of any other table's over head (activity).
It cannot be done by CPU usage as there is no metric to isolate that without a before and after scenario.
It can however be done through additional I/O overhead but that is only part of the overall performance picture.
Use promon or _tablestat to see the I/O overhead of the tables associated with auditing. (_tablestat and the command line argument parser have been enhanced to deal with negative values)