Strange Login and AppDomain xx created

Salam ELIAS 112 Reputation points
2021-03-15T18:23:55.973+00:00

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

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,274 questions
0 comments No comments
{count} votes

23 additional answers

Sort by: Most helpful
  1. Erland Sommarskog 106K Reputation points MVP
    2021-03-15T22:38:12.017+00:00

    In addition to Tom's post: these AppDomain relates the CLR, running .NET inside SQL Server, which apparently Master Data Services uses.

    0 comments No comments

  2. CarrinWu-MSFT 6,866 Reputation points
    2021-03-16T05:09:02.387+00:00

    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.

    0 comments No comments

  3. Salam ELIAS 112 Reputation points
    2021-03-16T11:45:31.237+00:00

    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


  4. Salam ELIAS 112 Reputation points
    2021-03-16T13:04:09.32+00:00

    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

    0 comments No comments