SQL Server Performance

Analysing Perfmon files

Discussion in 'SQL Server 2005 Performance Tuning for DBAs' started by satya.sqldba, May 9, 2007.

  1. satya.sqldba New Member

    I trying to analyse my server's performance over a given period of time.

    So I go to Performance Logs and ALerts and hit on new log settings to schedule a log file to be run during a given period of time.

    Now it is getting saved as a .blg file and how can I be able to open the log file or study what is in it?

    My question would rather be how can we analyse the .blg file that is saved on the hard disk?

    Thanks
    Satya

  2. MohammedU New Member

    Instead of using binary file (.blg) you can use tap delimited or csv or sql table using datasource which will be easy for analysis...

    By default is binary file, click the drop down list for more options...


    You can use Relog utility to convert .blg file to differnt format for analysis... if you don't want chnage the binary file option...

    Relog
    http://www.microsoft.com/resources/...roddocs/en-us/nt_command_logman.mspx?mfr=true


    MohammedU.
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.
  3. satya.sqldba New Member

    Ok Mohammed


    That was helpful. I will try doing that

    Thanks
    Satya
  4. Haywood New Member

  5. MohammedU New Member

  6. satya.sqldba New Member

    What do you think the monitoring interval should be if I plan to do it over a 24-hour period to analyze my server's performance for the following counters:

    1. Pages/sec
    2. Buffer cache hit ratio
    3. Total server memory etc.

    The default is 15 seconds, but when we monitor over a 24-hour period, should it be the same to get a good idea of server's performance?

    Thanks
    Satya


  7. satya Moderator

    By default is best value 15 seconds, so far I have adopted the same.
    If you have any specific time such as if a query is taking more than one minute then in order get benchmarking might change to 60 seconds.

    Take help ofhttp://www.sql-server-performance.com/sql_server_performance_audit.asp article by Brad about performance audit that gives you complete idea of your problem to resolve.

    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