This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(64, 19%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESE%3C/text%3E%3C/svg%3E)
On a sql 2k16, when I go through error logs, I find a lot of messages las follows
Server Date Process Count Text
SQL2K12 2021-03-15 13:30:44.640 spid17s 1 AppDomain 39 (MDS.mds_schema_user[runtime].38) unloaded.
SQL2K12 2021-03-15 13:00:15.550 spid62 1 AppDomain 40 (master.sys[runtime].39) created.
SQL2K12 2021-03-15 13:00:15.550 spid62 1 AppDomain 40 (master.sys[runtime].39) created.
SQL2K12 2021-03-15 10:00:43.090 spid45s 1 AppDomain 39 (MDS.mds_schema_user[runtime].38) created.
Not sure what this appDomain creating and unloading?
Thanks
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(67.2, 1%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETP%3C/text%3E%3C/svg%3E)
That is completely normal and expected when you are running MDS.
In addition to Tom's post: these AppDomain relates the CLR, running .NET inside SQL Server, which apparently Master Data Services uses.
Hi @Salam Elias ,
Represents an application domain, which is an isolated environment where applications execute. This class cannot be inherited. Application domains provide a unit of isolation for the common language runtime. They are created and run inside a process. Application domains are usually created by a runtime host, which is an application responsible for loading the runtime into a process and executing user code within an application domain. The runtime host creates a process and a default application domain, and runs managed code inside it. Please refer to AppDomain Class and Using Application Domains to get more information.
Best regards,
Carrin
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
So many thanks. I would like to accept all your answers but it seems I can't. In this case I will ask the following question and I think is related to this probelm.
I receive an alert indicating
SQL2K12 2021-03-16 10:01:12.400 SALAM\SQL2K12$ 1 ::1 Reason: Could not find a login matching the name provided
I am not aware of any application I have that uses such login in my domain salam. I tried to do a trace on the sql server, entering "winNtLogin = SALAM\SQL2K12$", nothing is logged in the profiler in spite of the fact that I still get the alert every 60 minutes
@Salam Elias , although you can't mark more than one answer, you can still upvote the others that helped.
Did you capture the audit login failed event in your trace?
SQL2K12 2021-03-16 10:01:12.400 SALAM\SQL2K12$ 1 ::1 Reason: Could not find a login matching the name provided
>
I am not aware of any application I have that uses such login in my domain salam.
SQL2K12$ is a machine account. That is, this is something that runs on the machine SQL2K12 on a local account, like Local Service or for that matter NT Service\MSSQLSERVER.
But this really a separate question, and is unrelated your AppDomain.
Erland, I use powershell script to alert me, I get this alert when not excluding "MDS.mds_schema_user[runtime", when it is not excluded I get those messages with the login in question
No, I rerun right now with Audit fail, I thought Audit login in and out will show something, sorry.
I will let you know, I will wait for my script to run