Analysis Services taking all available memory

Hi James,

The Memory Limit settings in SSAS don’t really limit what the server can use. They just configure when the maintenance processes run to release un-needed memory. Yours seems to either not be releasing the memory correctly, or you have more content on the AS instance that the server can manage with its existing resources. Usually the first course of action in a situation like this is to ensure that your SQL Server Instance has all of the available SQL Server service packs and hotfixes. Microsoft often releases updates that address AS memory allocation issues.

Here’s the latest Service Pack: http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=27594

Here are the Cumulative Update packages: http://blogs.msdn.com/b/sqlreleaseservices/

Best,

Chris

Hi James,

The Memory Limit settings in SSAS don’t really limit what the server can use. They just configure when the maintenance processes run to release un-needed memory. Yours seems to either not be releasing the memory correctly, or you have more content on the AS instance that the server can manage with its existing resources. Usually the first course of action in a situation like this is to ensure that your SQL Server Instance has all of the available SQL Server service packs and hotfixes. Microsoft often releases updates that address AS memory allocation issues.

Here’s the latest Service Pack: http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=27594

Here are the Cumulative Update packages: http://blogs.msdn.com/b/sqlreleaseservices/

Best,

Chris

Thank you Chris:

I should have mentioned we are running SQL Server 2008 R2 and we are on SP1 (latest).  I have tried some of the steps in the link below, so far without success.

Analysis Services Query Performance Top 10 Best Practices:

http://technet.microsoft.com/en-us/library/cc966527.aspx

James