• Thanks Vegard, just a quick question:

    What is the impact of the service broker on the tempdb?

    I have, amongst others, 2 DB on this server - one is the application database and the other hosts the service broker. And the 2 DB communicate with each other through

    the service broker, passing XML and sending thousands of messages each day. Could this also add to an increase in tempdb?

    I will definitely look into the cleanup op temp tables as well - thanks.