This is a small sample of scripts that the Philadelphia Regional Arts Consortium uses to manage the Tessitura database.
Most of these scripts were found online over the years, and they may help determine which process (and specific query) is causing blocking, what queries are currently being run in the database, etc.
sp_who2 is also a favorite script, but that one should ship with the impresario database, so it's not included in this zip file.
~Katie