Can DPA store dml, ddl events so I can query historical changes?
When you refer to DDL Events, I assume you are referring to changes to tables/indexes/etc, i.e. their structures. DPA would currently capture any DDL that occurs on an object assuming it runs for longer than 1 second (DPA polls once a second).
What would you like to see related to DML events. DPA also collects the UPDATE/INSERT/DELETE statements that occur, but is there something else you would like to see?
Though the post is quite old, i would need some inputs on the same. Is DPA capable of showing "ALL" DML events - Insert / Update / Delete.
Has some already created a query that can run on the DPA database repository to showcase the DML events?
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 190,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.