I posted that 6 hours ago....

1) the function could be a big problem here. Not sure of the code for it

2) I doubt the index on your temp table is helpful

3) why use a...

see my other post on a similar thread as this. ADQL is useless, use avg disk sec/read and /write. Or the sys.dm_io_virtual_file_stats DMV - even better.

CirquedeSQLeil (4/7/2010)

---

I would focus your time on the indexes and not so much the statistics. Tune your indexes and combine them where appropriate.

In 2000 there is also no script...

ADQL is completely useless as a disk performance metric in the modern age. Use avg disk sec/read and avg disk sec/write instead. Even better, use the SQL Server...

CirquedeSQLeil (4/7/2010)

---

TheSQLGuru (4/7/2010)

---

And...

And before someone...

Jeff Moden (4/7/2010)

---

Heh... summer intern evaluating code for performance problems. I believe that probably won't...

Marts (4/6/2010)

---

Not just you 😉 I keep looking at those orphaned files and want to move them.

When I created the new expandable log files, I created two per database that...

If the primary is empty then it doesn't matter where it is. 🙂 Just avoid putting things there to avoid fragmentation as it grows back out.

Good points. In my experience, existing database-hitting code is generally only revisited for 3 reasons:

1) fix a bug

2) add a feature

3) performance becomes unacceptable.

#3...

That's what I get for trying to rush out a few posts before taking my daughter to school - missed several points! Thanks for clarifications Paul. 🙂

Marts (4/6/2010)

---

I can check with my IT guy to see if something can be arranged. Does the tempdb storage need to be quick, or just seperated from other stuff?

Hmm chkdsk...

Paul White NZ (4/6/2010)

---

Marts (4/5/2010)

---

On our current setup without any modifications, I could move the logs and/or the tempdb to the system drive (raid 1), away from the data files....

Jeff Moden (4/5/2010)

---

Stop. It's a waste of time to do...