how to find the long running quries without running profiler?

• suri1984

  SSC-Addicted

  Points: 463

  More actions

  August 1, 2008 at 10:47 am

  #71770

  Hi,

  Is there any way to findout the long running quries without using profiler?

  Thanks

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736255

  More actions

  August 1, 2008 at 12:38 pm

  #852125

  You can look at sp_who2 and check the CPU time for xx length of queries.