Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Tempdb - monitoring queries Expand / Collapse
Author
Message
Posted Monday, October 22, 2012 1:21 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, July 21, 2014 3:43 PM
Points: 1,274, Visits: 2,936

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
Post #1375697
Posted Tuesday, October 23, 2012 7:12 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, July 17, 2014 6:40 AM
Points: 2,567, Visits: 3,799
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.
Post #1376021
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse