Ok. I'll get the max memory set on all instances and see what happens from there.

Thanks!

David, thank you for your reply.

I hadn't made it that far in the documentation. I now see that you specifically point that out under the Create Job...

Great, thank you!

I'm just getting time to come back to this memory task. I have yet to modify any settings yet, but I know in the last post we were saying...

I do see that it does create the temp tables in each step if they don't exist. I don't see where it would be storing permanent values, at least...

I know that this thread is old, but I'm hoping you're still answering questions David. These articles are extremely helpful! Very easy to follow for a beginner.

I had...

I want to execute it within an SSIS job.

Thanks for the info.

Craig - I really appreciate the info! Thank you very much for the help and great explanation.

I'm glad to hear that SQL seems to be ok on memory. Although I'm...

Thank you all for your responses. I will get to reading up on the links you posted!

I reviewed the max settings on each instance and it looks like only...

Six instances reside on the box.

(For some reason I can't gather counters for the last instance, so you'll only see 5 in attachment)

Steve Jones - Editor (2/12/2010)

---

How much memory is on the box, what's the version / edition of SQL and Windows?

If there's nothing on the box, no reason, typically, to limit...

David,

I just had a thought. The servers that are working are running under the default port #, the others that I'm having issues with are not. ...

David Bird (2/4/2010)

---

I've experienced the timeout error when SQL Server is down or I VPN from home using a different domain. Some containers fail from being unable to obtain a...