BUG: xp_trace_addnewqueue Timeout is in Seconds (263886)

The information in this article applies to:

Microsoft SQL Server 7.0

This article was previously published under Q263886

BUG #: 55633 (SQLBUG_70)

SYMPTOMS

Microsoft SQL Server 7.0 Books Online states that the timeout parameter of the xp_trace_addnewqueue system stored procedure is the number of seconds before the timeout temporarily pauses the trace queue. The value is actually a millisecond value.

STATUS

Microsoft has confirmed this to be a problem in SQL Server 7.0.

MORE INFORMATION

When you use xp_trace_addnewqueue Microsoft recommends that you use a timeout value of at least 5000 milliseconds. For example:

EXEC xp_trace_addnewqueue 4000,   -- Max items in queue
    5000,                         -- Trace queue timeout (ms)
    95,                           -- Thread boost %
    90,                           -- Thread reduce %
    @column_value,                -- Required columns
    @queue_handle OUTPUT          -- Queue handle

Modification Type:	Major	Last Reviewed:	10/16/2002
Keywords:	kbBug kbDSupport KB263886