Save the xml in an .XDL file and open the deadlock graph using Solarwinds Plan Explorer.

It has nice replay  features to help you detangle it all

Restore-DbaDatabase -SqlInstance server1\instance1 -Path Z:\Backup -DestinationDataDirectory Z:\Restore -DestinationLogDirectory Z:\Restore

Restore-DbaDatabase : The term 'Restore-DbaDatabase' is not recognized as the name of a cmdlet, function, script file, or operable program. Check...

#RCA :

- Instance was installed and prepared on 2023-08-08.

- AD-groups were created and granted for the instance.

- 2023-08-14 for some reason the AD-group has been deleted and recreated in Active...

blocking issues ?

Is someone else also using that table at the same time?

Double check for cascading deletes and triggers !

What collation are you using for these columns ?

If you are actually using case sensitive collations:

How about using lower(userid) , lower(name) and lower(firstname) with the insert statement

or...

Just use powershell DBATools ( free modules ) DBARestore

$File = Get-ChildItem c:\backups, \\server1\backups
$File | Restore-DbaDatabase -SqlInstance Server1\Instance -UseDestinationDefaultDirectories

Just keep in mind the target server service account...

according to the docs:

If performance is your goal: just one huge warning: "Which Version of SQL Server Should You Use?"

• Does the sqlagent service account have the authority to perform the wmi query?
• Does the sqlagent job step proxy account have the needed authority to perform the wmi query...

We have a couple of "data domain dedicated" sql stand alone instances ( std edtn ) that only serve as SQLAgent job scheduling environment.

A number of SQLAgent proxy accounts have...

• This reply was modified 2 months, 3 weeks ago by  Johan Bijnens.

If I'm corrent you can use "Return 1" (or higher) to fail your ps script in sqlagent

ongoing for a while

Thanks for the feedback....

But the failed logins report from the extended events session is giving logins which have not been able to login. How will creating this extended events...

Track down these connections and search for the applications that do not end their transactions and not close their connections.

hint: "Logon monitoring in SQL Server and Azure Managed Instances...

Happy it worked out !