Page History
...
Row count information is captured as part of an audit event and gathers information from both, traces and extended events.
| Note |
|---|
When enabling the ‘Capture DML and SELECT activities using SQL Server Audit specifications’, row count information does not show. This happens because the auditing is being processed through audit logs. Row Count information does not show when capturing DML and SELECT activities using SQL Server audit specifications. |
...
When you expand the audit events, the Audit Event tab shows the row count information in the event details.
Row count Alerts
IDERA SQL Compliance Manager allows you to set alerts on row count and data access. Alerts can be set by row count alone or adding a specific time interval.
Row count
...
Reports
IDERA SQL Compliance Manager allows you to generate reports on data access, including the new row count feature. You can generate reports with the SQL Compliance Manager console and with Reporting Services.