Search code examples
sql-server-2005redgate

long running database mail

I've got Redgate's SQL Monitor 2 running against my 2005 production server, and I keep getting alerts about the Database mail having a long running query. I've currently got my alerts set up to flag after a minute and mark it red after 2 minutes, and this is routinely popping up as red.

I need to know if this is something that I need to look into, or if this is normal behaviour and I can set up the alert to ignore this.

Solution

  • Red-Gate bug from April 2009 (!). Workaround/exclusion here

    And first hit on the world's favourite search engine