Skip to content

Instantly share code, notes, and snippets.

/*
Readme
This tool lets use inspect what is happening in the DB at a given time (including the actual SQL that is running, SPID info, and the actual query plan)
First, run the SQL int he comment. This will generate the temp table. Then run the while loop for as long as you want to inspect the DB
Some useful queries
SELECT TOP 40
QueryText,
COUNT(*)
@ffailla
ffailla / keybase.md
Created February 5, 2015 19:52
keybase.md

Keybase proof

I hereby claim:

  • I am ffailla on github.
  • I am ffailla (https://keybase.io/ffailla) on keybase.
  • I have a public key whose fingerprint is A26D BA78 481D E7C7 55C8 B544 86D7 B173 E435 D947

To claim this, I am signing this object: