How to Analyze the PERFMON (SYSMON) data?
As you may aware the PERFMON (SYSMON) utility provides much information to analyze on the systems resource usage, I support and suggest to make use of this tool as much as you can with a default templates within our environment. You may be aware the data is saved as a file with .BLG extension which can be opened again using this SYSMON tool. I have asked a question that how can we analyse the .blg file that is saved on the hard disk?
Though it is saved as .BLG file you can still use or save as tab delimeted or .CSV format for ease of analysis, By default is binary file, click the drop down list for more options to save it such formats.
Also Microsoft tools will help to analyze further, such as using ReLog utility that will convert this .BLG file to a different format or whatever fashion you want. Refer to this Relog link. I would like to refer to this link for a baseline performance analysis if you are new to the environment you are supporting. For more information on base line tips refer to this article link.
Also one of our Network Administrator suggested that you can make use of LogMan utility if you are not much comfortable with SYSMON tool, so download Logman FromHere.
**__________________________________**
SQL Server MVP, Sr. DBA & industry expert.
-
Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it. It is also a power and you will gain by sharing it.