Activity overview
Latest activity by JeroenvH
Ah, thanks !
I'll look into it. / comments
Ah, thanks !
I'll look into it.
Brian Donahue wrote:
Hello Jeroen,
SQL Response sets a trace flag on SQL Server that causes deadlock information to be written to the SQL Server's ERRORLOG, and then it reads the ERRORLOG to gather the output that you had quoted above.
I'm not sure how profiler and performance counters do this, but I would imagine that you have to set the trace flags to detect deadlocks there as well? For instance, DBCC TRACEON(1204) will put deadlock information into the SQL Server log.
I'll take a look at the errorlog if I find the deadlock there.
Since yesterday SQL-Response reported several more 'ghost' deadlocks and one actual deadlock (with an Victim spid) which also was trapped by profiler with an dead-lock graph. / comments
Brian Donahue wrote:
Hello Jeroen,
SQL Response sets a trace flag on SQL Server that causes deadlock information to be written to the SQL Server's ERRORLOG, and then it reads the ERRORLOG to gat...
SQL Response reports deadlocks where SQl server does not rep
Hello,
I'm evaluating SQL Response right now, and I encounter the following:
SQL Reponse is reporting strange deadlocks: The victim SPID for example is 0.
The running Porofiler trace (with deadlock...