Missing database name in blocking session alert
When I receive an alert about a blocking session, it does not tell me the database. The mail starts with e.g.
Blocking Session ID: 93
Number of blocked descendants: 1
Total blocking duration for all descendants: 00:03:02
Blocking SQL fragment: CREATE PROCEDURE [dbo]...
In the subsequent blocks (blocked sessions) it shows the corresponding database name, but only after much of scrolling, when the block cames from a long procedure (some with > 1000 lines).
So please add the database name to the blocking session part too.