Audit Collection Database
The audit database is a SQL Server 2005/2008 database (OperationsManagerAC) and has similar requirements to the operations database and reporting database. The most critical resource used by the audit database is the I/O subsystem, but the CPU and RAM are also important.
The database handles a large number of operations due to the volume of security events collected. In addition, the database conducts daily maintenance at 2:00 a.m. every morning, which places an additional load on the server. The edition of SQL is an important factor in the maintenance; in SQL Server Standard Edition, the database is paused and in SQL Server Enterprise Edition, the database continues to accept data.
Factors that impact the audit collection ...
Get Microsoft® System Center 2012 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.