BTW, thanks to both of you for explaining the Holloween Effect.

Fraggle

An update on this. The MAXDOP statement worked the best. It took the entire process down from 8-15hours to under 5 minutes.

Thanks,

Nathan

And the moment has arrived. After a total execution time of 15:54:22 I finally have an execution plan for everyone to view.

Jeff/Gila, can either of you explain...

Evil Kraig F (12/14/2011)

---

Personally, I'd start investigating your wait_state on the spid running the process and looking into your locks. You sound blocked, not slow.

EDIT: If you're sure it's...

Ninja's_RGR'us (12/7/2011)

---

In that...

Thanks Ninja. And thanks for mentioning the performance hit. I am sure it will be an awesome one over 120m some odd records. 🙁

Tenagra

ChrisTaylor (8/4/2011)

---

Do you have any resource_semaphore wait types when the server has issues?? Or do you not get any issues per se (or that you're aware of at the time)...

TheSQLGuru (8/4/2011)

---

dbcc memorystatus IS documented online, by Microsoft. It will have LOTS of useful information for you if you are having memory problems. There are also some support...

So as a followup question to this thread, is there a way to tell inside of sql server 2005, to tell where every single byte of memory is being used....

Yes, I was just sitting down to read it now actually.

Fraggle

george sibbald (8/2/2011)

---

Roy Ernest (8/2/2011)

---

As per MSDN

"To determine if hyperthreading is enabled for the processor, compare NumberOfLogicalProcessors and NumberOfCores. If hyperthreading is enabled in the BIOS for the processor, then...

george sibbald (8/2/2011)

---

The article had details on memory usage by memory outside the buffer pool. Might have been an MS engineer blog.

1Gb for the OS does not sound enough for...

Roy Ernest (8/2/2011)

---

The only thing that comes to mind is Hyperthreading being enabled. I have seen cases where the server hangs due to memory pressure and starts throwing the AppDomains...

george sibbald (8/2/2011)

---

😀

Fraggle, I read a good article on setting max memory taking other factors into account recently, but damned if I can...

Ninja's_RGR'us (8/2/2011)

---

Do you have dbs on auto-close. I just saw gail saying this is what happens in that particular case.

How did the server go down? Anything else in...