We have SQL Server 2005 database, and want to know if we can get Application performace monitor (v2.5) to monitor the changes made to the tables and by whom. Please let me know if this is possible.
Thanks,
APM's doesn't have a monitor that looks specifically at tables. You can run any SQL Query with the SQL Query monitor. Is that change info available via a query?
Thanks Danny for your reply, You can get the audit information by writing custom stored procedures, triggers, and ddl notifications on the database. Can we integrate these procedures into APM module?
I'll add a SQL Table Change Monitor to the feature request list. So would you be able to describe more about the business problem? Are you or a SQL DBA using APM? It's not a frequent request, so more detail will help us understand the problem space better.
Hi Denny, From an audit perspective we want to monitor the changes being made to sensitive data, and we were checking to see if Orion APM can do that. For example if any time a change is made to a table, we can see what change was made and by whom. If you do feature request, how long does it normally takes for that feature to become available.
Thanks a lot,
-Freeha
Hi.
I am interested to know if this feature was made available. I have a case where I might be able to use this feature but I can confirm that only after having a look at it.
