November 15, 2011 at 8:04 am
The server is running sql 2008 and analysis services 2008 together.
Memory settings are:
Total RAM = 12GB
SQL = 6GB dynamic
AS = LowMemoryLimit 20% (2.4GB) TotalMemoryLimit 25% (3GB)
Perfmon shows:
Available MB = 7.5GB
Total Server memory (SQL) 1.5GB, Target Server Memory (SQL) 1.5GB
Private Bytes msmdsv (AS) 1GB
Private Bytes sqlservr.exe (SQL) 1.7GB
a) Why is Analysis Sevices running at 1GB when it is defined as 2.4GB/3GB low/total limits?
b) Why is SQL running at 1.7GB when total/target are at 1.5GB and it's defined for 6GB dynamic?
I've seen buffer cache hit ratio drop to 76% for short periods. I thought this would cause SQL to dynamically grab more memory but it doesnt. Also, for Analysis Services, we have seen memory alloc errors during processing but the size of the process never grows beyond about 1.2GB at the most. After a server restart, these are all the values that SQL and AS are initialized with and never seem to grow (much).
November 17, 2011 at 3:13 am
Bueller?....Bueller?....Bueller?
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply