SQL Server Performance
  1. california6 New Member

    When using profiler to monitor, i was wondering, what events are worth monitoring? My users complain that at ever 12:30 PM, SQL Server response time is very bad and even a simple query takes several minutes. I was wondering, what events i need to monitor from profile?

    Appreciated if someone please advice?

    Thanks,
  2. Luis Martin Moderator

    TSQL: Completed.
    RC: Completed.


    Luis Martin
    Moderator
    SQL-Server-Performance.com

    All in Love is Fair
    Stevie Wonder


    All postings are provided “AS IS” with no warranties for accuracy.



  3. satya Moderator

    http://sqlserver-qa.net/blogs/perftune/archive/2007/05/25/identify-and-troubleshoot-slow-running-queries-in-sql-server.aspx

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

Share This Page