A processing pool is a type of an Analysis Services worker thread pool used to process an incoming query request. Threads from the processing pool are used for activity that takes place in the storage engine including dimension scans, partition scans, and aggregation scans.
This performance counter monitors the rate of non-I/O jobs through the processing thread pool such processing ROLAP related jobs and writing new files into the storage engine cache.
DBAs, Server administrators, BI developers
- To disable per NUMA node thread pool behavior, change the value of PerNumaNode property to 0
- Consider adding more CPU core
- If you are seeing consistently high queue lengths, but not high CPU utilization you many want to adjust your MaxThreads and/or CoordinatorExecutionMode properties for your SSAS instance