• Oh, the 'query wait (s)' property is an Advanced Option. So you can turn on advanced options by running:

    sp_configure 'show advanced options', 1

    RECONFIGURE

    ... then you can see all of the options.

    Jim Murphy
    http://www.sqlwatchmen.com
    @SQLMurph