SP_Who2

• sqlfriend

  SSC Guru

  Points: 52781

  More actions

  February 21, 2013 at 5:28 pm

  #274395

  I am using

  sp_who2 'active' to check if there is any active sessions,

  I also know there is a free download sp_whoIsActive,

  Do they both mean the same thing?

  Thanks

• Query Shepherd

  SSCrazy

  Points: 2988

  More actions

  February 22, 2013 at 6:29 am

  #1590320

  The answer my friend!

  Greetz
  Query Shepherd

• Anish-1093520

  SSC Veteran

  Points: 268

  More actions

  February 24, 2013 at 3:30 pm

  #1590677

  sp_whoIsActive gives much easier results to analyze and wisely used by the DBAs.