I currently experiencing a threading issue when trying to process cubes. Before starting the cube we select sql server the detemine the number of threads/cpus's to use. The error I am getting is.....
OLE DB error: OLE DB or ODBC error: The query processor could not start the necessary thread resources for parallel query execution.; 42000
The server in question has 16 cpu's (8 dual cores), MS 2008 R2 x64 o/s & SQL 2008 R2 x64, 32Gb RAM of which 22Gb is allocated to SQL.
I installed the newly released SP1 yesterday and "hoped" this service pack would fix the issue. Has anybody else had this problem ??
Also, 'MAXDOP' is set to '8', max degree of parallelism' is set to '0', 'max worker threads' is also '0'.