Apparently we're getting some Long Running SQL alarms that aren't valid.


The last time I researched this, the recommended solution was to update.  Which we did.  Then the problem trailed off.  Recently they started up again.

Basically, the alarms state that the SQL has been running for X amount of time, but it's incorrect.  The SPID will only have been running for a much shorter duration.  We end up wasting time on researching things that aren't actually problems.

Anyone else have to deal with this?  Anyone have a solution?