SQL Server Performance Forum – Threads Archive
Reading .blg or perfmon files
I have scheduled performance monitor files, it ran for 5 hours and it created a file as .blg file under c
erflogs.
Using this file, I want to find out the problem if any exist in the server.
Could anyone help me out understand this perf monitor file.
Thanks,Bala
Hi,
Untill you don’t told us the reason/what you are looking for in Perfmon we could not give you suggestion. What kind of performance issue you are facing? Hemantgiri S. Goswami
MS SQL Server MVP
————————-
"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri S. Goswami http://hemantgirisgoswami.blogspot.com
As Hemant mentioned give us more info to get the right answers… You can the following…
Tips for Using Performance Monitor
http://www.sql-server-performance.com/performance_monitor_tips.asp
MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided “AS IS†with no warranties for accuracy.
I am trying to give some statistics to my manager about the production sql server which is going to be live soon. As a team member, I was asked to find if there is any performance problem in sql server. So I am using performance monitor and sql profiler to identify any bottlenecks in sql server. I have scheduled the performance monitor for 9 hrs and captured the log(and also captured the sql queries) when the system was tested by the testing team by some testing tools. Since I am using the performance monitor for the first time, I am finding hard time to understand the statistics(graph). I need some help to understand the log which I captured thru perfmon to identify any sql server hardware bottlenecks. Please let me know if you need more details. Mohammed, Thanks for the url which is very useful. Thanks,
Bala
Check the following articles…
http://www.sql-server-performance.com/performance_monitoring_tutor_part4.asp
http://www.microsoft.com/technet/community/chats/trans/sql/sql0513.mspx
http://www.databasejournal.com/features/mssql/article.php/3506526
MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided “AS IS†with no warranties for accuracy.
http://sqljunkies.com/Article/7F8518F9-FDAA-4FF3-8FC5-25E8946C8D0C.scuk also helps you 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. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
Thanks All For the help. The links were really useful. Thanks Once Again
]]>