Memory

  • 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

  • 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 ,

  • Which service pack are you on right now.

    What Does the SSIS PAckage do?

  • 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/.

  • 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