cancel
Showing results for 
Search instead for 
Did you mean: 

Database Audit

SAPSupport
Employee
Employee
0 Kudos

Hi SAP.

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?

Best regards,


------------------------------------------------------------------------------------------------------------------------------------------------
Learn more about the SAP Support user and program here.

Accepted Solutions (1)

Accepted Solutions (1)

SAPSupport
Employee
Employee
0 Kudos

Dear customer,

SQL Audit isn’t a SAP related feature, so there is no much information about to setting it up.

Following Microsoft for your reference:

https://learn.microsoft.com/en-us/sql/relational-databases/security/auditing/sql-server-audit-databa...

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.
***

Best regards,
Joe

Answers (0)