Post reply

AppDomain <no> (mssqlsystemresource.dbo[<xxx>].<no>) unloaded

  • August 26, 2011 at 6:03 am

    #242941

    Hi

    Our server is on SQL 2008 enterprise edition

    In the windows log i got the following event logged:

    AppDomain <no> (mssqlsystemresource.dbo[ddl].<no>) unloaded.

    What does this mean?

    Thanks

  • August 26, 2011 at 7:16 am

    #1373749

    Does it say it is getting unloaded due to memory pressure? You are running into memory issues.

    -Roy

  • August 26, 2011 at 5:18 pm

    #1374165

    What is the max memory setting for SQL Server? and the total ram on the server? is it 64bit or 32?

    ===========================================
    Better try and fail than not to try at all...

    Database Best Practices[/url]

    SQL Server Best Practices[/url]

  • August 30, 2011 at 5:08 am

    #1374884

    Hi...

    I have researched a bit and it points to memory issues.

    This topic is huge !!! ... so its not gonna be easy to understand all concepts.

    More details:

    Windows server - 64 bit - SQL , also 64 bit

    Server have 72 GB of RAM.

    Here's what has happened so far:

    I have decreased SQL max memory to 60 GB , to give the OS and other external components called by SQL Server

    more memory.

    SQL still pushes past the max to 66 - for external components called by SQL Server.

    The error still persists:

    AppDomain <no> (mssqlsystemresource.dbo[ddl].<no>) unloaded.

    Pls let me know if anyone have recommendations on optimal settings

    and how do we go about calculating what is needed for these settings

    Thanks in advance

    :w00t:

    'It's a big black hole!!'

  • August 30, 2011 at 5:14 am

    #1374887

    I do not know how far the below link would help,

    However it would be a good starting point to further analyse your needs.

    http://www.sqlservercentral.com/blogs/glennberry/archive/2009/10/29/suggested-max-memory-settings-for-sql-server-2005_2F00_2008.aspx

  • August 30, 2011 at 6:10 am

    #1374910

    Interesting blog, thanks. will keep as reference for settings.

    Have started off with the recommended settings, and is now set on 60 GB.

    How do i determine what is the best settings for my server?

  • August 30, 2011 at 6:14 am

    #1374913

    Usually you leave 10 to 15% mem for the OS. In your case you have left 12 GB. That should be more than enough.

    Do you have hyper threading enabled on your server? When you start getting this error, are you doing a restart of the SQL Server?

    -Roy

  • February 10, 2012 at 3:02 pm

    #1445803

    Are you using Change Data Capture?

    We started noticing these same entries in the log when we were running some of the CDC functions that utilize CLR behind the scenes (such as cdc.fn_cdc_get_net_changes_[tablename]).

    It doesn't say it unloaded due to memory pressure, and we've seen them on completely quiet systems, so it seems to be more of an informational message, although we're a bit puzzled as to what it's supposed to inform us of. :hehe:

    Are there any CLR experts out there that can explain what a ddl appdomain is, and why it gets unloaded when calling CDC functions? Should we be concerned when this happens?

    - Jeff

  • October 14, 2013 at 2:19 am

    #1658186

    Hi Jeff,

    Did you narrow down the issue. I also run CDC and are having the same issues. Would increasing the VAS memory help?

    Regards,

  • October 14, 2013 at 7:13 am

    #1658263

    We did get resolution to this error message after a long back-and-forth with Microsoft. The messages will disappear if you enable CLR on your system. Change Data Capture uses CLR functions in the background, and these messages are a side-effect of utilizing them on a system without CLR enabled.

    sp_configure 'show advanced options', 1;

    GO

    RECONFIGURE;

    GO

    sp_configure 'clr enabled', 1;

    GO

    RECONFIGURE;

    GO

    - Jeff

  • September 14, 2015 at 10:25 pm

    #1826590

    Hi Jeff

    Thank you. The solution worked.;-)

Viewing 11 posts - 1 through 10 (of 10 total)

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