SQL Server Performance Forum – Threads Archive

Analysing Perfmon files

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

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.

Ok Mohammed
That was helpful. I will try doing that Thanks
Satya

This is the second in a series of articles for baselining Terminal Services with Perfmon, but the analysis steps apply to SQL Server as well… This link will show you how to analyze your collected data. http://www.msterminalservices.org/a…e-Monitor-Baseline-Terminal-Server-Part2.html

Take a look…
http://www.sql-server-performance.com/gv_baselining_tips.asp And also take look LogMan utility… without using pefrom log….
Logman
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.

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

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.

]]>