5.5 Row Count

IDERA SQL Compliance Manager audits and reports on the frequency that users access sensitive data, alerting about suspicious behavior.

The Row Count feature allows users to: 

• Audit and capture row count for all event types and SQL statements. 
• Audit and capture row count for joined query statements.
• Report on row count and access to data and sensitive data. 
• Set alerts based on thresholds for row counts, users, sensitive data, and specific queries.   

Row count information is captures as part of an audit event and gathers information from both, traces and extended events. 

event properties