That is completely normal and expected when you are running MDS.
Strange Login and AppDomain xx created
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
23 additional answers
Sort by: Most helpful
-
Salam ELIAS 117 Reputation points
2021-04-01T06:42:00.85+00:00 Correct, here is the right snapshot, it is "NT Service\SQLSERVERAGENT" account and this is there since the setup of SQL 4 or 5 years ago, never touched it
-
Salam ELIAS 117 Reputation points
2021-04-02T07:09:38.593+00:00 Agree, but as I said earlier in a snapshot, job is disabled. In this case, why it is not able to find the login and always saying
"Reason: Could not find a login matching the name provided"
what does this mean? -
Salam ELIAS 117 Reputation points
2021-04-02T13:31:31.437+00:00 Sorry for this, the server when was setup initially with SQL2K12, I named the server SQL2K12 but it has been migrated around 2017 to to 2K16 but I kept the name sql2k12, didn't change it
-
Salam ELIAS 117 Reputation points
2021-04-02T17:32:34.89+00:00 Except 1 task I have done recently reading error logs and populate a table in 1 database, I am not aware of any other task.
However, while I was searching before responding, I found a 2 very strange tasks in a directory called XBLGameSave.How those were schedueled and installed Xbox related stuff !!!!! This a server not win 10, any idea?