Monday, January 23, 2012 8:38 PM
I've setup SQL Audit (Server Side Audit Specifications) on our SQL 2008 server using the SQL Server Management Studio GUI .
Currently there are 30 GB worth of audit logs accumulated since and each audit log file is 500 MB in size.
I'm having trouble opening the saved audit file for viewing.
When I go to Microsoft SQL Server Management Studio > Security > Audits > audit-20120102.... > view audit logs, it tries to open the audit logs but after awhile, it fails with:
Exception of type
'System.OutOfMemoryException' was thrown.
I've also tried to open just one single audit file by going to
Microsoft SQL Server Management Studio > Security > Audits > audit-20120102.... > view audit logs > Load log > selecting one single log file and it does the same thing.
Thanks in advance
Tuesday, January 24, 2012 12:08 AM
You can try to select on those log files, or open it on a server with higher memory.
Fabrizzio A. Caputo
Oracle OCA 11g
MCITP SQL Server 2008 Implementation and Maintenance
MCITP SQL Server 2008 Developer
Blog Pessoal: www.fabrizziocaputo.wordpress.com
Blog Empresa: www.tripletech.com.br/blog
- Proposed As Answer by Peja TaoModerator Wednesday, January 25, 2012 3:05 AM
Wednesday, January 25, 2012 7:35 AMSo do you have a problem to open audit log of 500MB? Do you have 60 files?
Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
Wednesday, January 25, 2012 7:31 PM
Yes, even when I select one individual log file via load log button, it takes awhile trying to open and it fails.