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 |
|
Artful
Starting Member
2 Posts |
 Posted - 2008-07-09 : 15:07:26
|
| I've created a trace file with some counters of interest, and saved it. But I can't figure out how to actually run it. What am I missing here? Any help gratefully appreciated.Arthur |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-09 : 15:20:49
|
quote:
Originally posted by Artful
I've created a trace file with some counters of interest, and saved it. But I can't figure out how to actually run it. What am I missing here? Any help gratefully appreciated.Arthur
Counters are in Perf mon . Did you save the trace ? Stop the trace and open the file. |
 |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2008-07-10 : 01:58:53
|
| Assuming you save it as a file (or have stored the data in a table) just open it in Profiler .Jack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
|
|
|
Artful
Starting Member
2 Posts |
Posted - 2008-07-10 : 12:01:04
|
| Now I've got it. I opened a new trace based on the "Locking Issues" template and I was shocked at how it impacted engine performance. So now I'm paring it down to report only deadlock issues, if any.Thanks,Arthur |
|
|
|
|
|
|
Trace and Profiler