Enterprise Managers "current activity":How in SQL?

Manfred Braun wrote:
> Hi All !
> Can someone show, how to obtain that, what Enterprise manager calls "curre
nt
> activity", in SQL? I really would like to see the same output, not that,
> what sp_who, sp_lock etc give.
> I just have currently not the right knowledge to make all the neccessary
> relationships from sp_who/sp_lock/sysprocesses etc
> Any help would be great.
> Thanks so far and
> best regards,
> Manfred Braun
>
Hi Manfred
You could try to run a trace while you open "Current activity". This
would most likely reveal which sql statement EM is running to view that
info.
Regards
Steen Schlter Persson
Database Administrator / System AdministratorAlso, take a look at this procedure by Erland:
http://www.sommarskog.se/sqlutil/aba_lockinfo.html
HTH
Kalen Delaney, SQL Server MVP
"Steen Persson (DK)" <steen@.asavaengetREMOVETHIS.dk> wrote in message
news:OllyWgkjGHA.836@.TK2MSFTNGP02.phx.gbl...
> Manfred Braun wrote:
> Hi Manfred
> You could try to run a trace while you open "Current activity". This would
> most likely reveal which sql statement EM is running to view that info.
>
> --
> Regards
> Steen Schlter Persson
> Database Administrator / System Administrator|||Hi All !
Can someone show, how to obtain that, what Enterprise manager calls "current
activity", in SQL? I really would like to see the same output, not that,
what sp_who, sp_lock etc give.
I just have currently not the right knowledge to make all the neccessary
relationships from sp_who/sp_lock/sysprocesses etc
Any help would be great.
Thanks so far and
best regards,
Manfred Braun|||Manfred Braun wrote:
> Hi All !
> Can someone show, how to obtain that, what Enterprise manager calls "curre
nt
> activity", in SQL? I really would like to see the same output, not that,
> what sp_who, sp_lock etc give.
> I just have currently not the right knowledge to make all the neccessary
> relationships from sp_who/sp_lock/sysprocesses etc
> Any help would be great.
> Thanks so far and
> best regards,
> Manfred Braun
>
Hi Manfred
You could try to run a trace while you open "Current activity". This
would most likely reveal which sql statement EM is running to view that
info.
Regards
Steen Schlter Persson
Database Administrator / System Administrator|||Also, take a look at this procedure by Erland:
http://www.sommarskog.se/sqlutil/aba_lockinfo.html
HTH
Kalen Delaney, SQL Server MVP
"Steen Persson (DK)" <steen@.asavaengetREMOVETHIS.dk> wrote in message
news:OllyWgkjGHA.836@.TK2MSFTNGP02.phx.gbl...
> Manfred Braun wrote:
> Hi Manfred
> You could try to run a trace while you open "Current activity". This would
> most likely reveal which sql statement EM is running to view that info.
>
> --
> Regards
> Steen Schlter Persson
> Database Administrator / System Administrator