January 24, 2011 at 1:17 pm
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]
January 25, 2011 at 5:27 am
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;-)
January 25, 2011 at 12:31 pm
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