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.