Counting of INSERT & UPDATE statement into a table during last one hour
Being DBA I have to deal with badly written application that generate 1000 of insert statements into a log table followed by 1000 update statement after every insert to update a column and all that happening on clicking of button on web application. Unfortunately correction of code is not possible it has to be re-written from beginning and it will take time.
Before we getting into new dev task, I need to give evidence that how many rows has be inserted and how many updated in last hour. what could be best way?
Kashif