Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2008-02-05 : 12:08:52
|
Troubleshooting SQL Server requires the use of both PerfMon (Performance/System Monitor) and SQL Trace files created by SQL Profiler or directly by SQL Server trace. Analysis of the gathered data is much easier if you can correlate your trace file with the PerfMon counters. In this article I'll show how to create a PerfMon counters log file and SQL Profiler Trace file, how to read them both and how to correlate the two files in SQL Profiler. Read Integrating Profiler and PerfMon Log Files |
|
|
euan_garden
Microsoft SQL Server Product Team
34 Posts |
Posted - 2008-02-07 : 23:44:54
|
| I'd recomend reducing the capture window in Perfmon from the 15s you have to 5s or less. Because the SQL Server events are so granular (many per s) the correlation algorithm gets confused sometimes because the granularity of perfmon events is not low enough. |
 |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-02-08 : 08:43:24
|
| thanx for letting us know euan!_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com <- new version out |
|
|
|
samwise_007
Starting Member
3 Posts |
Posted - 2008-03-04 : 19:06:08
|
| Something that got me in a bit of a bind once...ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/e1b3072c-8daf-49a7-9895-c8cccd2adb95.htm"To guarantee accuracy of correlation with System Monitor data, the trace must contain both StartTime and EndTime data columns."You must have Startime and endTime in your SQL Trace. |
|
|
|
lionofdezert
Aged Yak Warrior
885 Posts |
Posted - 2009-01-26 : 05:12:25
|
| soooooooooooooooooooooooo helpful... thanx |
|
|
|
sagitariusmzi
Posting Yak Master
113 Posts |
Posted - 2009-01-29 : 06:49:11
|
| i am getting error, when i use File > Import Performance Data,and help ?correlation is not possible because there is no intersection between trace and performance data time ranges |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2009-01-29 : 07:33:52
|
i think that the error message is self explanatory  ___________________________________________________________________________Causing trouble since 1980Blog: http://weblogs.sqlteam.com/mladenpSpeed up SSMS development: www.ssmstoolspack.com <- version 1.1 out! |
|
|
|
|
|
|
Article: Integrating Profiler and PerfMon Log Files