check process running 1

[peac3]

Hi guys,

I am trying to find SPIDs are currently running,

I tried to have a look in job activity monitor, I can see the processes running but unfortunately it doesnt give me the SPID.
Im using SQLSERVER 2005

Any advice about this?

Cheers guys,

 

[Crowley16]

erm, yes it does, process id = spid...

you could also use sys.sysprocesses...

--------------------
Procrastinate Now!

 

[TysonLPrice]

exec sp_who2 'active'

 

[peac3]

I was using Database 2005 but the interface is SQL 2008, so it's totally rewritten for the "Activity monitor".

the SQL2008 feature has processes, Resource Waits, Data File I/O etc,

but I still like old 'Activity Monitor' better, hence im still using sp_who2, what do you guys think?

 

[Crowley16]

I generally like to use sys.sysprocesses since I can easily put where clauses in, but who2 is just as good if the server doesn't have lots of connections...

--------------------
Procrastinate Now!