0

is there a way to add Session ID and timestamp to your first responders scripts? In particular the sp_BlitzLock. I am trying to find out when and by who some adhoc scripts are run that cause blocking on old SQL Server versions (2008R2/ 2012) .

2
1

First, sp_BlitzLock only helps you analyze deadlocks, not blocking.

Second, it won't run on 2008R2 -- it's 2012+ only. The deadlock XML definitions are sufficiently different to make supporting both unwieldy.

Third, it already includes the timestamp of the deadlock event, along with other identifying information. I don't think spid would be helpful.

NUTS

Not the answer you're looking for? Browse other questions tagged or ask your own question.