Error 9961

Severity

17

Message text

DBCC failed to connect to the requested number of worker processes. The number of workers configured is insufficient, or the number of  workers exceeds 128. Use sp_dbcc_updateconfig to reduce 'max worker processes' for this database.

Explanation

dbcc checkstorage processing may require the use of one or more worker processes. Error 9961 is raised when the server is unable to obtain the worker processes necessary for a checkstorage run. Error 9961 is raised with the following states:

State

Meaning

1

There is insufficient memory available to configure more worker processes.

2

checkstorage is unable to start up a worker process.

3

checkstorage is unable to attach to a worker process.

4

Similar to state 3.

5

Similar to state 3.

Action

  1. Determine the resources necessary to run dbcc checkstorage:

    1> use master
    
    2> go
    
    1> sp_plan_dbccdb <target database>
    
    2> go
    

    Write down the process count recommended for the database.

  2. Verify that the following parameter settings provide the number of worker processes needed. Worker process configuration is determined by:

    • max worker processes – specifies the maximum number of worker processes that checkstorage uses for each target database; you set this parameter with sp_dbcc_updateconfig.

    • number of worker processes – defines the total number of worker processes supported by the server; you set this parameter with sp_configure. Note that worker processes are not dedicated to checkstorage operations.

  3. Retry the checkstorage operation.

Additional information

See the chapter “Checking Database Consistency” in the System Administration Guide: Volume 2 for details on configuring worker processes for checkstorage.

Versions in which this error is raised

All versions