?
Solved

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

Posted on 2014-01-10
1
Medium Priority
?
2,255 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Percona Live Europe 2017 | Sep 25 - 27, 2017

The Percona Live Open Source Database Conference Europe 2017 is the premier event for the diverse and active European open source database community, as well as businesses that develop and use open source database software.

Question has a verified solution.

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

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Suggested Courses

762 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