GilaMonster (7/9/2012)

---

opc.three (7/9/2012)

---

This is the first time I have heard this. Do you have a reference by...

No, using sp_configure that way will change the instance-level default. That takes over when no fill factor is specified when creating the index, as you have done above. I recommend...

If you're only ever inserting into...

I do not do much AD work these days, let alone from PowerShell, but I do know of the AD cmdlets MS published. http://technet.microsoft.com/en-us/library/ee617195

Here is what I got (using replacement)...

This is the first time I have heard this. Do you have a reference by chance where...

Is it a 2-proc/8-core machine meaning 16 ways? Or 2 procs w/ 4 cores each, i.e. 8 ways?

Fly Girl (7/9/2012)

---

Yep, PageLatch and PFS indicated as the issue. I can certainly try creating more files. Should be fairly easy to see if there is improvement. Anyone want to...

I just read the title of the post again. Page latch (not IO) wait on tempdb file 8...chances are adding more data files will help. Gail, please correct if I...

What are the processes waiting on? If the web app is creating lots of temp tables you may actually benefit from creating additional data files. No matter how many you...

Also note that you cannot edit SSIS 2005 packages in BIDS/VS 2008 without upgrading them first, which will make them unusable on a SQL 2005 server.

BIDS/VS 2005 is required to...

If just starting out I highly recommend getting into PowerShell. It really has no peer in the Microsoft stack in terms of a command-line scripting tool. VBScript and JavaScript are...

My bad, I neglected to consider the total memory on your system. I use the /3GB switch to solve the problem you have with proc cache size, but on a...

You can help your cause a little by adding the /3GB switch to your boot.ini, and optionally the /USERVA option to restrict the VAS split to less than 3:1.

tymberwyld (7/5/2012)

---

One thing to watch out for here with "processing a file as soon as it arrives" is that you don't know if that file is done copying or not....

That's a neat idea. I...