cannot view the server side audit logs

Question

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

Answer 1

Admiles,

 

You can try to select on those log files, or open it on a server with higher memory.

---

Fabrizzio A. Caputo
MCT
Certificações:
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
Twitter: @FabrizzioCaputo
Email: [e-mail]

Answer 2

So 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/

Answer 3

Yes, even when I select one individual log file via load log button, it takes awhile trying to open and it fails.