SSAS occupy about 75M when starting SSAS.
After processing or making several MDX query, I found that SSAS occupy 400M memory.
And SSAS always occupy 400M memory until restarting SSAS.
It causes SSAS working slowly.
Is there anyway for SSAS release memory automatically
thanks!
SSAS 2005 can't release memory
Hot Topic
- Solution in SSIS
- Looking for simple sample
- Package from Package Sore does not work as Job
- how to synchronize between sql mobile 2005 & sql 2000?
- "product level is insufficient" message during flat file import
- Mining Algorithms
- 2005--Management Studio
- Surface Area for Features not connecting
- one to one relationship
- Database Mail Configuration?? Very Urgent
SQL Server
- Cube Browser
- RPC Server is unavailable
- Database Diagram error on SQL 2005
- Error at parse query
- Script Component failed validation and returned validation status "VS_ISBROKEN". Error: 0xC0047062
- Where is the SQL Server 2005 Express Manager Sep CTP?
- firehose
- Report Builder fatal error
- SQL Server Operations Guide - Q. for Dave Wickert
- SOLVED: TDSSNIClient initialization failed with error 0x7e
SSAS 2005 can't release memory
Anders Rydén
The guide is SQL 2000.
Does the memory management of SSAS 2005 work same as 2000
Thanks!
Keyur
_-_-_ dave
Rick M
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/anservog.mspx
in the section titled: "Memory" and "Memory Allocation"
It explains how memory is allocated and controlled in Analysis Services.
_-_-_ Dave