July 7, 2014 at 5:53 am
Hi everyone. I hope this is in the correct category and the correct way to represent my problem.
I'm having issues with SQL Server Audits, when I try and enable one of my audits, DMLAudit and DMLAudit1 it fails right away.
I believe the issue lies within the following dmv's containing references to my earlier attempts to create my audit solution.
Is there any way to clear these entrys or should I try and provide more information?
SELECT * FROM sys.dm_server_audit_status
audit_idnamestatusstatus_descstatus_timeevent_session_addressaudit_file_pathaudit_file_size
65536DMLAudit3TARGET_CREATION_FAILED2014-07-04 09:54:35.68800000x000000027C8F9A41NULLNULL
65538DMLAudit13TARGET_CREATION_FAILED2014-07-04 10:17:17.03500000x00000004C8C902A1NULLNULL
65542DMLAudit0START_FAILED2014-07-04 12:58:28.6160000NULLNULLNULL
65545DMLAudit0START_FAILED2014-07-04 12:59:03.6790000NULLNULLNULL
SELECT * FROM sys.server_audits
*empty*
SELECT address, name, buffer_policy_desc, flags, flag_desc, create_time FROM sys.dm_xe_sessions
addressnamebuffer_policy_descflagsflag_desccreate_time
0x00000004FF2D0141system_healthdrop_event1flush_on_close2014-06-26 23:17:33.783
0x00000004FBA28041sp_server_diagnostics sessiondrop_event17flush_on_close private2014-06-26 23:17:33.973
0x000000027C8F9A41DMLAudit$Ablock33flush_on_close zero_unused_buffer_data2014-07-04 09:54:33.953
0x00000004C8C902A1DMLAudit1$Ablock33flush_on_close zero_unused_buffer_data2014-07-04 10:17:15.263
Thanks for reading, Martin
July 8, 2014 at 2:17 pm
Hi, the issue is gone now but I didn't find a clear way on how to resolve it. I did however notice that upon restarting the SQL Server Engine that the invalid mapping is gone.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply