In our ECC Productive System, we need to know if it is possible to activate some type of audit at the database level that allows us to know what connections it received during the last month.
What type of audit could we activate that does not affect the performance of the system?
SQL Audit isn’t a SAP related feature, so there is no much information about to setting it up.
Following Microsoft for your reference:
If SQL Server Audit is going to be used, please do a performance test to make sure a system's workload is not impacted as mentioned in 1609057 - SQL Server Setup Check Overview and Explanation
There have been customer systems, especially in cases where heavy auditing is configured, where performance has been severely impacted.
If SQL Server Audit is going to be used, please do a performance test to make sure a system's workload is not impacted.