james.billings wrote:You're not being crazy- I see the same thing. I think there's an explanation though.
The Long Running Query alert is an Instance-Level alert. If you go to the screen to configure alerts, you'll see once you drill down to a specific database, you cannot configure that particular query.
This works the same when viewing the alerts- as you drill down, you'll see it at the instance level, but once you select an individual database, you'll only see alerts that are DB - level. So although the alert knows which DB raised the fault, the alert isn't occurring at the DB level.
I probably didn't explain that very well, and it's not obvious this happens from the screen, but hopefully it makes sense!
Users browsing this forum: No registered users and 0 guests