Post reply

Tempdb - monitoring queries

  • October 22, 2012 at 1:21 pm

    #283356

    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

    Thanks

  • October 23, 2012 at 7:12 am

    #1551880

    sqldba_newbie (10/22/2012)

    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

    Thanks

    2.dbcc inputbuffer(spid)

    3,4,5 you will get all the details from sysprocesses.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply