This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

"invalid" Wait Time Type

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.

Parents Reply Children
No Data