I know there are many different forums out there related to tempdb, but i couldn't find the one which suits my requirements. While i do more research i just wanted to check if someone else has the script which i need.
I need to monitor the following.:
i) Amount of tempdb in MB space used for each spid.
ii) will also need to know the exact sql statement running for that spid.
iii) time when it was running
iv) host name
v) login name