[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

AppDomain 2 (mssqlsystemresource.dbo[ddl].1) unloaded in SQL Server Log

Posted on 2014-01-10
1
Medium Priority
?
2,468 Views
Last Modified: 2014-01-12
Periodically we see the following messages in one of our SQL Servers:

AppDomain 7 (mssqlsystemresource.dbo[ddl].6) unloaded.

Unsafe assembly 'microsoft.sqlserver.mpusqlclrwrapper, version=10.0.0.0, culture=neutral, publickeytoken=89845dcd8080cc91, processorarchitecture=msil' loaded into appdomain 4 (mssqlsystemresource.dbo[runtime].3).

AppDomain 4 (mssqlsystemresource.dbo[runtime].3) created.
AppDomain 3 (mssqlsystemresource.dbo[ddl].2) unloaded.
AppDomain 2 (mssqlsystemresource.dbo[ddl].1) unloaded.

Common language runtime (CLR) functionality initialized using CLR version v2.0.50727 from C:\Windows\Microsoft.NET\Framework64\v2.0.50727\


Is this anything to be concernened about?

Thank you
0
Comment
Question by:aiopsit
1 Comment
 
LVL 28

Accepted Solution

by:
Ryan McCauley earned 1500 total points
ID: 39773831
I wouldn't be concerned as long as you're not seeing any connection drops or other negative behavior associated with the message.

SQL Server (starting with 2005) allows .NET code to be called from T-SQL (with proper configuration and precautions). The term "UNSAFE" (in the .NET assembly sense) isn't a term to be concerned about - it just denotes an assembly that may access components of the system that are protected. Specifically (from TechNet):

UNSAFE  code permission is for those situations in which an assembly is not verifiably safe or requires additional access to restricted resources, such as the Microsoft Win32 API.

Though I've never seen this message specifically, it just means that SQL Server has unloaded the assembly to free up memory or because it's not currently being used.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
In this article, we will show how to detach and attach a database and then show how to repair a corrupt database and attach it, If it has some errors. We will show how to detach and attach using SSMS or using T-SQL sentences.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…
Suggested Courses

640 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question