Posts
Sort by recent activity
Unable to send test email. Please check your settings
I can send alert e-mails to my e-mail address, but as soon as I try to send a test e-mail to myphone#@txt.att.net, it fails. I can send texts to my phone without problem from our e-mail system. I...
Database ID not identified in deadlock alert
We get a lot of deadlock alerts that look like this:Deadlocked processes: 139 139 139 139
Object blocked: Unknown
Deadlocked processes
SPID Victim Lock details Statement type
139
No Event:
Port: 0x...
Deadlock with no SQL Query Fragment
I have a deadlock alert that provides the following:Object blocked: Index/(Key) 72057595237695488
Deadlocked processes
SPID Victim Lock details Statement type
139 dbid: 10, object id: 72057595237...
Trouble with deadlock object id
We just purchased SQL Monitor and I'm trying to learn how to use it. I'm having trouble identifying the object id for the 'Victor' in a recent deadlock.
Clicking on the Victor process shows this:
...