IQ Auditing

[raymond_lackey]

Is anyone aware of custom / third party software which will conduct detailed auditing of the use / non-use of tables, columns etc in IQ at the DB level?

The use of the stored procs, ie sp_iqtableuse column use etc are possibly useful at a connection / workload level but have their limits.

dbtrans also limited and raises concerns re overhead on a fully loaded DB.

Would appreciate anyones thoughts or suggestions.

Thanks

[former_member194571 · Accepted solution]

Raymond,

are you aware of the Request Level Logging feature?

- Volker

[raymond_lackey · Accepted solution]

Thanks for the reminder , have used Request Level Logging for problem solving, Still thinking about how to turn it and other features into some sort of on-demand app.

[RolandKramer]

Did you implemented the SAP IQ Cockpit for further monitoring?

Best Regards Roland