can mssql db deadlock be monitored in itrs for random queries?
If MySQL (or MariaDB) exposes the deadlocks, then yes.
The MySQL/MariaDB monitoring starting point is this one:
I can’t recall right now if the sql-toolkit based samplers in this package show any deadlock information, but it will be straightforward to add additional system queries if you can establish how to identify a deadlock.
Peter
Thanks for the answer.
Please share if the deadlock can be monitored for mssql db
Sorry! I misread your original post.
I am not aware of anything we have published to monitor MS SQL / SQL Server at that level, but the same principle as for MySQL would work - create a SQL-Toolkit sampler with a “system” level query (google etc is your friend) that would return information about deadlocks in a dataview.
Peter