March 27, 2007 at 3:47 am
When I try to process a database in Analysis Services, my database Sql Server tempdb increases a lot (more than 2 GB) and I get an error for low disk space.
How can I do to fix this problem?
Thanks
March 27, 2007 at 8:10 am
Either use logging or tracing to review the query that AS is sending to SQL, most likely for the fact processing (but could be a larger dimension, you'd need to supply more detail), as it sounds like you have either a problem with the query (e.g some sort of join /performance issue) or potentially you've create a fact query with a lot of caluclation or similar. If you can extract the query being run, you should see similar performance when running it thru Query Analyzer or SWQL Mgt Studio.
Steve.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply