Seconds in wait

The term “seconds in wait” means the number of seconds that a SQL Statement, Database User, etc. was waiting on an event. It is possible that the total number of “seconds in wait” exceeds the total amount of time in the period. The following example will illustrate how this occurs.

 

Example: Assume that one session locks a row that is needed by ten other sessions. All ten sessions will wait for the lock. Also assume that the session holds the lock for one hour. Since each of the ten sessions waited for one hour, Ignite will show total wait time of ten hours during the one hour period.

 

The maximum theoretical wait time during a period is the number of session multiplied by the length of the period.

关注dbDao.com的新浪微博

扫码关注dbDao.com 微信公众号:

Speak Your Mind

TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569