Home Forums SQL Server 2008 SQL Server 2008 Performance Tuning What should be the best approach to identify performance problems in Production environment RE: What should be the best approach to identify performance problems in Production environment

  • August 21, 2013 at 1:13 am

    #1643334

    vinod.saraswat (8/20/2013)

    @RTalor : Can you please share the list of counters and their threshold values to have baseline for the system.

    How do you analyze this data i.e.on weekly basis or monthly basis. I am curious to know about creating a baseline for the system.

    Google - erin stellato baseline

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass