Activity Monitor (Locks by Object Page/ Locks by Process Page) is missing in 2008?

• Mathew M.Varghese

  SSCommitted

  Points: 1929

  More actions

  January 12, 2011 at 9:20 am

  #230285

  Hi,

  In sql server 2008 Management studio/Activity monitor, where i can view the Locks by Object Page Locks by Process Page)

  In SQL 2000, I was using Lock/Object and i feel it is a very useful tool.

  Is the same feature available in sql server 2008.?

  Please advice

  Thanking you

  Mathew

• SQLBuddy123

  One Orange Chip

  Points: 28294

  More actions

  January 12, 2011 at 10:27 am

  #1272485

  AFAIK, Those pages are available only in the previous versions but not in SQL 2008 bcs MS has completely rewritten the Activity Monitor in 2008.

  Thank You,

  Best Regards,

  SQLBuddy

• Mathew M.Varghese

  SSCommitted

  Points: 1929

  More actions

  January 12, 2011 at 11:19 pm

  #1272815

  Thanks for your reply.

  In sql 2008, where i can see the lock/process information.

  Only way is to use sp_lock or any better way to view it

  Regards

  Mathew

• crazy4sql

  SSCoach

  Points: 19590

  More actions

  January 12, 2011 at 11:45 pm

  #1272823

  select * from sys.dm_tran_locks

  ----------
  Ashish