Conor Lillis (1/26/2015)

---

If you have space you could rebuild your indexes onto new files / file groups and simply drop the old files (bar the PRIMARY file) once the reindex...

Hi,

Thank you all for the help on this. I tried the below listed steps but maybe I am doing something wrong? I...

I have run into the exact same issue as the original poster. I believe his method to fix this issue would work for me as well but I could...

Still can't seem to find out what is causing this issue. Any other troubleshooting suggestions to determine what is causing the avg wait time to sky rocket and hold?...

JeepHound (7/22/2014)

---

I digress on this one, I was using it as a benchmark for splitting out the tempdb. I also read the recommendation to be below 20, however I...

JeepHound (7/22/2014)

---

Could it be AVG write stall like I use in the below query? With 2 out of 16 of my instances I get high write stall in the...

It is a stored procedure that is built into the database (that is what it says when ou scroll over the command...

These are the results from the query that is run:

tempdb (Data) Size:5000 MB File: T:\tempdb\tempdb.mdf

Avg Wait:0 ms/read Reads:900195 ...