Hi again,

I think i've just worked this out... its spills.

I've not noticed in the past but on checking some execution plans there are spill warnings for tempdb.

This points to either...

Hi there,

Thanks for the replies, answers below

1) What metric you gave do you think indicates that SQL Server has lots of free RAM do devote to temp objects?

The main one...