These cubes have been working in SQL 2005 on another box. I copied the SQL db and the SSAS Project over to this new box and a fresh install of SQL 2008, sp2 Std Ed, 32 bits. Box has Server 2003 R2 Enterprise Ed SP2,
• 2x 2.3GHZ
• 12GB RAM
• D: 120GB SSD Drive Partition For Data
• C: 73 GB Drive Partition for System
• 1 GB NIC
A few of the dimensions will not refresh, they give the message
"The query processor could not start the necessary thread resources for parallel query execution.; 42000"
The dimension I have been testing has 34 attributes, all directly related to the key attribute, and no hierarchies. There are 246,000 unique members in the source table. If I make another dimension from the same source table, it refreshes fine as long as there
are only a few attributes, but when I add the rest, I get this message again.
Drive C, where Visual Studio is installed, has 69 Gb free disk space. The SQL and SSAS data are on D also has 69 Gb free.
Why was SQL 2005 able to handle this, but SQL 2008 cannot? I am thinking of uninstalling 2008 and going back to SQL 2005. Other suggestions?
View Complete Post