Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Memory Expand / Collapse
Author
Message
Posted Sunday, June 22, 2008 1:56 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, September 21, 2010 5:34 AM
Points: 11, Visits: 117
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
Post #521387
Posted Sunday, June 22, 2008 8:29 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, August 13, 2014 9:23 PM
Points: 150, Visits: 220
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 ,
Post #521404
Posted Sunday, June 22, 2008 4:52 PM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Friday, August 15, 2014 11:42 AM
Points: 646, Visits: 732
Which service pack are you on right now.
What Does the SSIS PAckage do?


Maninder
www.dbanation.com
Post #521468
Posted Sunday, June 22, 2008 5:01 PM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Friday, August 15, 2014 11:42 AM
Points: 646, Visits: 732
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
Post #521470
Posted Monday, June 23, 2008 5:31 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, August 10, 2010 5:07 AM
Points: 2,661, Visits: 23,078
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?
Post #521663
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse