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 |
|
Carat
Yak Posting Veteran
92 Posts |
 Posted - 2007-07-03 : 10:45:51
|
| In SQL Server 2005 it is possible to correlate System Monitor Data with SQL Server Profiler Traces. But how does it works?I do the following:- I start a trace for lets say 10 minutes- In the trace I include the StartTime and EndTime columns- I stop the traceNormally I should open 'File\Import Performance data' but this is grayed out. What am I doing wrong?I also tried to run a Counter Log together with my trace but this also didn't work for me.Thanks. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-03 : 12:45:35
|
| Did you save trace to anywhere? Used default template? |
 |
|
|
Carat
Yak Posting Veteran
92 Posts |
Posted - 2007-07-04 : 05:50:08
|
| I saved the trace to a file and also enabled file rollover.And I used the Tuning template where I specified the columns and events that I wanted including Startime and EndTime. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-04 : 17:14:51
|
| Then you can open it by double click the file in windows explorer. |
|
|
|
Carat
Yak Posting Veteran
92 Posts |
Posted - 2007-07-05 : 04:27:27
|
| When I open the file, I can choose to import the performance data.So it works.I didn't know that I have to close the file and reopen it.Thanks!!! |
|
|
|
|
|
|
Using Profiler together with System Monitor