Post reply

Change Data Capture: Calls to sys.fn_cdc_increment_lsn and sys.fn_cdc_decrement_lsn write entries to the event log

  • November 18, 2009 at 7:19 am

    #385810

    Hi

    When calling either of the two Change Data Capture functions, sys.fn_cdc_increment_lsn or sys.fn_cdc_decrement_lsn in SSMS, I've found that they both write two entries to the application event log.

    An example of the event description is:

    AppDomain 347 (mssqlsystemresource.dbo[ddl].346) unloaded.

    Has anyone noticed this and, if so, does anyone know of a way to suppress this? The reason I ask is that I call this function within a loop and each time it is called, it populates the event log, which seems unnecessary.

    I've looked into possibly querying the fn_dblog function to return the LSN, as a means of avoiding the log writes, though am not sure how safe that is to do.

    Thanks.

  • September 11, 2010 at 9:53 am

    #1219640

    This is not a CDC specific message. The "AppDomain 347 ( <any managed code assembly) unloaded." indicates your system was under memory pressure and the managed code assembly was cleared/unloaded from memory.

    --Chris Skorlinski

  • June 28, 2012 at 10:30 am

    #1506740

    (Pardon the bump, just wanted to leave this here for anyone else who finds this thread.)

    I was also seeing this warning, and the function would often take a few seconds to return. Found that by enabling CLR integration on the server, the warnings disappeared and the function would return right away.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply