MDA Functionality

[Former Member]

What functionality do is gained (or lost) by using:

"object lockwait timing"

"enable stmt cache monitoring"

in ASE 15.7-SP132 and  ASE 16-PL03?

[former_member350489 · Accepted solution]

"object lockwait timing controls whether Adaptive Server collects timing statistics for requests of locks on objects"

This means that you for example will get information about for how long a table has been locked and the information is put into various MDA tables

"enable stmt cache monitoring enables or disables Adaptive Server to collect monitoring information about the statement cache. Once enabled, monStatementCache and monCachedStatement display valid data."

This means that you can capture the code that is run against your ASE into the MDA tables

So you have to query those MDA tables later when the statistics has been collected into them

But remember that MDA tables are fifo, that means that the data is not stored forever, so it is recommended that you proxy mount them and save the data into another database, that you query, since it is not recommended either to query the MDA tables directly !

In both cases you can get more monitoring statistics and output from what is run against the ASE and against what objects. And in both cases you risk to lose "some" performace in you ASE...