How to modify server queue settings (SQL Server Profiler)

To modify server queue settings

1. On the File menu, click Open, and then click Trace Definition.
2. In the Trace Properties dialog box, click the server icon.
3. In the Source Server dialog box, in the Number of rows to buffer on server box, enter a number between 0 and 20,000.

   This value represents the maximum number of items buffered or stored in the trace queue. The recommended value is 1000.

4. In the Server timeout (seconds) box, enter a number between 0 and 10.

   This value represents the time-out value for the trace queue. When the time-out value is reached, the trace queue stops accepting new events. The default value is 5.

5. In the Boost priority (%) box, enter a number between 1 and 100.

   This value represents the percentage of the buffer limit in the trace queue that causes the trace queue consumer to receive a boost in priority, and it increases the priority setting for the specified application thread. The default value is 95.

6. In the Reduce priority (%) box, enter a number less than the boost priority number and between 0 and 99.

   This value represents the percentage of the buffer limit in the trace queue that causes the trace queue consumer to receive a reduction in priority, and it decreases the priority setting for the specified application thread. The default value is 90.

See Also

Advanced Options