Tuning the syb_blocking_pool

Use the monWorkQueue monitoring table to determine an appropriate size for syb_blocking_pool.

Enlarge the size of syb_blocking_pool if it contains too many queued requests and requires a significant wait time.

Reduce the size of the pool if the WaitCount and WaitTime are zero.

sp_sysmon displays blocking pool statistics in the “Kernel” section of its output. You may need to increase the pool size if the “Blocking Call Activity” section shows a high percentage for “Queued Requests” relative to “Serviced Requests” or high “Total Wait Time.”