Home Forums SQL Server 2005 SQL Server 2005 Performance Tuning need one doubt clarification application team trying to execute a simple query RE: need one doubt clarification application team trying to execute a simple query

  • November 27, 2012 at 2:47 am

    #1562562

    select count(*) from acmt

    1. if the query is getting slow to execute what should we check in activity monitor other than spid !

    2. can we trace any thing in the activity monitor lock by object if so what is it?

    Thanks
    Naga.Rohitkumar