Under Wait Events, I see a 60,000ms Wait Time that comes and goes - but, sometimes will sit there for hours and also disappear for days.
It is for a Wait Type of "invalid". I cannot seem to find what an "invalid" Wait Time is. It is under the category MISC.
No host identified, no SQL available, no database identified, only the user "sa" is listed.
It usually represents 95 - 99% of my Wait time.
If this is a real issue, I'd like to know what it is so that I can track it down and resolve it.
If it is just noise (e.g. "idle" time), I'd like to get rid of it as it ruining my ability to monitor true Wait Time.
In reply to Gita Sharifi: