Hi:
Analysis Services is taking all available memory on our server (running T-Stats). I have adjusted the SQL memory and the Analysis Services lowmemory and totalmemory limits, but the server memory is being completely consumed by Analysis Services. Has anyone else experienced this and if so what did you do to fix it? I currently restart the SQL Server Analysis service to release the memory.
Thanks,
James
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
__________________________________________ Chris Wallingford T-Stats Product Manager | JCA 575 Eighth Ave., 21st Floor | New York, NY 10018 Phone: 203-468-9123 | Fax: 212-465-2349 chris.wallingford@jcainc.com | twitter www.jcainc.com | twitter | blog
Helping Non-Profits Work Smarter Visit JCA’s blog for the latest insights into how nonprofits can work smarter!
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