Its probably a bad idea to have any data going into your last partition. We always leave an empty partition at the end for this reason. Its a best practice...

Thanks Wayne...

You are correct.. We have Multiple San boxes. Each is striped and then our data is striped across the boxes. We took a big jump on this one.. we...

I have a simular issue that just "popped up". Ok well maybe I just noticed it. Did anyone ever come up with a reason for this behavior?

tia

Allen,

I found the culprit.... our networking group was doing some "maintenance". They were replicating 2 terabytes of data to a mirrored server... it must have eaten all the bandwidth. They...

"Where is above information from?"

Query Analyzer Client Statistics

allen,

here are the results.. the final portion of the SP returns 333 rows.

Application Profile Statistics  

  Timer resolution (milliseconds) 0 0

  Number of INSERT, UPDATE, DELETE statements 0 0

  Rows effected by INSERT, UPDATE, DELETE...

Allen,

So am I!

the confusion comes from the fact that the trace says its taking seconds to run and the actual results... even in QA take several minutes. I am...

allen,

the totals are....

Duration 2155 

CPU 2275 

Reads 3388 

Writes 33