Planning Process Service
Updated: 2008-11-14
The Planning Process Service manages isolated or long-running processes asynchronously by using a Microsoft SQL Server 2005 Service Broker (SSB) queuing subsystem. These queues are used for scheduled workflow tasks such as assignments and jobs. For example, PerformancePoint Add-in for Excel users can submit consolidation and calculation jobs to the queue and track those jobs.
The jobs are isolated from the rest of the system so that additional resources can be dedicated to the jobs. This isolation also protect the rest of the system from the resource-intensive requirements of the jobs.
Planning Server creates three SSB queues for each Planning Server application:
dbo.BizRequestAssignmentQueue. The high-priority asynchronous queue that is used for assignment submission.
dbo.BizRequestScheduleQueue. The main scheduler asynchronous queue.
dbo.BizRequestJobQueue. The low-priority asynchronous queue that is used for job execution.
Note
Before you uninstall or perform an upgrade of Planning Server, make sure that the SSB queues are empty. If not, their contents will be deleted. These queues are located in SQL Server Management Studio under Databases\<name of application database>\Service Broker\Queues.
If the SSB queuing subsystem empties, the Planning Process Service will wait and check the queue again later. Wait time is determined in the Poll interval (milliseconds) under the Planning Process Service tab in the Administration Console. If this queue contains items after the first item is processed it will immediately process the next available item without waiting.
For scalability, this pole interval can be set to at least one minute (60,000 milliseconds). During periods of high submission frequency, such as at the end of a budgeting cycle or other deadline, the administrator must balance the need for near instantaneous processing with the normal database and server workload. After this occurs the planning process returns to the queue and looks for more work or commences a waiting period. The assignment status will then be designated as a WaitProcess.
To set Planning Process Service settings
In the Maximum number of queue rows box, type the maximum number of items (rows) that are allowed in the queues.
In the Poll interval box, type the amount of time (in milliseconds) before the queues are checked for new entries. Setting the poll interval too low or too high will cause denial of service errors on the computer that is running Planning Server.
Click Submit.
To reset Planning Process Service to default settings
To reset the Planning Process Service to its default settings, click Reset Defaults. The default settings are described in the following table.
Field Name Default Setting Maximum number of queue rows
1,000
Poll interval (milliseconds)
60,000
Click Submit.