tempdb

  • 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

  • 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