June 22, 2008 at 1:56 am
Hi Everyone,
I am facing a memory problem on my development server.
I have 12.5 GB RAM available. During any SSIS run the memory drops to less than 1 GB and never recovers after the run is completed. I am overcoming this by restarting the sql service or restating the server machine; which will free the memory unto 11 GB. Sadly, after any other SSIS run the memory drops again to 1GB. Kindly advice how to overcome this headache.
Thx
June 22, 2008 at 8:29 am
hi,
do you use scripts ?
what other components do you use ?
is it One package or all of your packages ?
what version do you have ? (with SP )
Yaron ,
June 22, 2008 at 4:52 pm
June 22, 2008 at 5:01 pm
Do you have Huge tables?
Do you use lookups to join those tables.?
Is your server 32-BIt and which SQL Server Edition do you have? ENT/STD/.
Maninder
www.dbanation.com
June 23, 2008 at 5:31 am
First, how did you end up with 12.5gb of memory in a server? 3 4gb dims and a .5gb dim? It is a strange number.
Are you running 32bit or 64bit SQL Server?
What is actually using the memory? Is there a dtexec process hanging, or has SQL Server simply cached a lot of data?
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply