March 26, 2008 at 11:44 pm
Im running 3 SQL 2005 instance and 1 analysis server in one box with 12 GB. allocated memory as follows
Default - 2GB, SQL A - 4 GB, SQL B - 4GB
and Analysis Server, Low memory 30 and total 50.( Hope this is persentage )
What I need to know is this analysis server (running on SQL A) getting that 30% to 50% from SQL A memory area or from rest of the 2 GB ?
- Cheers!.
March 28, 2008 at 6:59 am
Hopefully someone will verify this - having run both SQL 2005 and SSAS on the same machine, we see it's looking at the total memory that the OS sees.
Also be aware that this does not seem to be an absolute value - SSAS will grab what it can. I think it more of general set points for agressive garabage collection. Carefully watch the memory - especially if you have a runaway query in SSAS. If SSAS uses all free memory, it will start pushing memory out of SQL. 2005 is much better than 2000 at managing memory, but you can still get in trouble.
Was hoping for a query govenor in 2008, but it appears this is just on the SQL side.
Greg E
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply