Script to display activity monitor output ?

• johnnyrmtl

  Newbie

  Points: 0

  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

• umasingh

  Newbie

  Points: 0

  More actions

  January 26, 2012 at 8:11 am

  #1438817

  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

  Newbie

  Points: 0

  More actions

  January 26, 2012 at 8:32 am

  #1438837

  thanks for that...

• umasingh

  Newbie

  Points: 0

  More actions

  January 26, 2012 at 8:36 am

  #1438843

  Welcome:-)

• johnnyrmtl

  Newbie

  Points: 0

  More actions

  January 26, 2012 at 8:51 am

  #1438868

  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

  Newbie

  Points: 0

  More actions

  January 26, 2012 at 10:00 am

  #1438909

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

  -- Gianluca Sartori

• johnnyrmtl

  Newbie

  Points: 0

  More actions

  January 26, 2012 at 11:11 am

  #1438950

  Thanks Gianluca