May 13, 2013 at 10:23 am
Hi,
We have two similar reporting servers. Lets assume them Server A and Server B
On Server B, one of the ETL package SQL agent job is failed due an out of memory condition.
On both server Total RAM is 32 GB
Out of 32, 24 GB is allocated for SQL
Our monitoring tools say SQL is using 100% memory on server A
BUT SQL is using only 50% memory on Server B.
Both are identical servers. Why SQL is using only 50% of its allocated memory on Server B?
Do we need to reconfigure the memory on Server B? so that SQL can use 100% of its allocated memory.
8GB used by OS, So 8GB is not sufficient for SSIS procedures? is this a memory leakage?
Thanks
May 13, 2013 at 3:49 pm
nihal9200_kwada (5/13/2013)
Hi,We have two similar reporting servers. Lets assume them Server A and Server B
On Server B, one of the ETL package SQL agent job is failed due an out of memory condition.
On both server Total RAM is 32 GB
Out of 32, 24 GB is allocated for SQL
Our monitoring tools say SQL is using 100% memory on server A
BUT SQL is using only 50% memory on Server B.
Both are identical servers. Why SQL is using only 50% of its allocated memory on Server B?
Do we need to reconfigure the memory on Server B? so that SQL can use 100% of its allocated memory.
8GB used by OS, So 8GB is not sufficient for SSIS procedures? is this a memory leakage?
Thanks
Not sure there is enough info there to answer your question. I assume that the SSIS packages are not identical on both servers? If not then they could be processing very different loads and that's could explain the difference. It is possible that there is a memory leak, make sure that you are service packed up to the latest versions.
You would need to do more analysis to determine what the issue is.
SQL DBA
Every day is a school day, and don't trust anyone who tells you any different.
http://sqlblogness.blogspot.co.uk
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply