Timeout (ms) parameters in client monitor

aavio

Hi,
can some one tell me difference between Timeout (ms) & Elapsed Time (ms) parameters in client monitor?

in client monitor i found one set of entries with
Timeout (ms) : 200
Source Text : }
SQL Statement : SET SHOWPLAN_ALL ON SELECT * FROM ....
Elapsed Time (ms) :15

what does Timeout (ms) : 200 mean?
does this Source Text actually consume 200 (ms)?? :-k

thanks

kriki

If you want to lock some records and another process already locked them, SQL will wait that amount of time before giving the error that someone else locked your record and you need to retry your operation. If the process that locked the record releases it (and no other process locks it before you can) SQL will lock the record and go ahead.

aavio

aavio wrote:

Timeout (ms) : 200
Source Text : }
SQL Statement : SET SHOWPLAN_ALL ON SELECT * FROM ....
Elapsed Time (ms) :15
thanks

so nav takes 200ms for the Source Text : }?? :shock:
but why for commented code SQL locks? its suppose to be skipped right?