Jonas,

Can you post the error message(s) from the Event Log and/or SQL logs?  Also a brief description of what the package looks like would make it easier for others to...

Do you know what context the package(s) are running under?  In the first post in this thread, seeing a directory path that has 'Administrator.CBI' normally would indicate that it's using...

From memory I thought you could modify the drill through query for a partition. 

But anyway, before doing this, it sounds to me like you're getting what you should be...

Maybe take a look at some hints from some good guys in Australia.  From memory it talks about having an anonymous site and a secured site (for admin) whch maybe...

Switch to AS2K5 or maybe go 64bit?

I thought with a 32bit machine the process itself could access a max of 3gb?  This means...

Hey Stefan,

That makes it a little more interesting.  I haven't tried this but one thing you could do (given time and effort) is to write an app that monitors the...

Well, if you used a specific user account to access the AS datasource in RS, then you could create a role that contains only that user account.  Then any other...

What service pack level do you have on your AS (not SQL)?

Are there any entries in any event logs related to AS?  Part of the problem with AS2K (benefit of...

you could try looking in the repository (AS2K uses either MSAccess [default] or MSSQL as it's metadata repository).  Alternatively you could try an AS documentor (like this one).

Have you got some very large dimensions in some/one of your AS databases?  AS2K loads all dims in to memory and if you've got a lot of large ones, this...

At least you know it's a query issue

Have you made sure that your attribute relationships are all ok?  The perf doc actually outlines...

Jacques,

Can you explain the situation again?  Were SSAS 2005 and SQL 2005 installed on the one virtual server?  If they ran together for 2 months *before* the migration was...

Hey Saru,

I would be guessing that because you're using Standard Edition you can't use the Perspectives feature.  You will need to either upgrade to Enterprise (or any other edition that...

Have the data volumes changed from Test to Prod?  Did you do the install and config of both systems?   Do you still have the virtual machine to review it's server...

I know it's a lot of reading but if you check out the new (AS 2005) Performance Guide it covers off the memory usage for both processing and querying and...