SQL CLR error caused by memory pressure(?) - need help to troubleshoot

  • I got the error below, and I need to check whether the CLR is under memory pressure on my 64-bit SQL-2008 instance.

    Max memory: 22 GB (buffer pool)

    Server RAM: 32 GB

    I have several SQL-CLR assemblies running on the server.

    In the SQL ERRORLOG I see the following entries:

    ...

    2011-01-24 14:52:16.28 spid19s AppDomain 2 (dbName.dbo[runtime].1) unloaded.

    ...

    Anyone have any DMV queries (or any other ideas) to help me troubleshoot this issue?

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

  • Check out this link might help

    http://www.sqlskills.com/resources/Whitepapers/SQL%20Server%20DBA%20Guide%20to%2

    0SQLCLR.htm

    NEVER NEVER EVER GIVE UP;-)

  • Thank you!

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

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

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