Script to display activity monitor output ?

Question

Post reply

Script to display activity monitor output ?

johnnyrmtl

Hall of Fame

Points: 3505
More actions
January 26, 2012 at 8:05 am

#144879

Hello all,
I can't seem to find the simple script that will display the same data as the activity monitor output ?
thanks again

Viewing 7 posts - 1 through 6 (of 6 total)

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

umasingh Ten Centuries Points: 1182 More actions · Answer 1

Here is your query.

http://sqlblog.com/blogs/john_paul_cook/archive/2009/08/24/using-the-processes-query-outside-of-activity-monitor.aspx

johnnyrmtl Hall of Fame Points: 3505 More actions · Answer 2

johnnyrmtl

Hall of Fame

Points: 3505

January 26, 2012 at 8:32 am

#1438837

thanks for that...

umasingh Ten Centuries Points: 1182 More actions · Answer 3

umasingh

Ten Centuries

Points: 1182

January 26, 2012 at 8:36 am

#1438843

Welcome:-)

johnnyrmtl Hall of Fame Points: 3505 More actions · Answer 4

just one more question ... in the output , the database column only show the 'master' DB for some rows and nothing for the rest of the databases in use ?

Any ideas

spaghettidba SSC Guru Points: 105732 More actions · Answer 5

Why would one ever want activity monitor when you can have Adam Machanic's sp_whoIsActive?

-- Gianluca Sartori

johnnyrmtl Hall of Fame Points: 3505 More actions · Answer 6

johnnyrmtl

Hall of Fame

Points: 3505

January 26, 2012 at 11:11 am

#1438950

Thanks Gianluca 🙂