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 |
|
treehouse
Starting Member
2 Posts |
 Posted - 2008-09-30 : 21:11:12
|
| In SQL profiler, I have a trace file with columns of CPU, Reads, Writes, and Duration. I replay this trace file on another database server. I want to investigate the changs of the value of CPU, Reads, Writes, and Duration. But in the results of replay, I cannot find the columns CPU, Reads, Writes, and Duration. How do I exam the result of trace replay in SQL Profiler? Thank you. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-09-30 : 22:47:31
|
| Why can't you start over new trace with that Database as filter type ? |
 |
|
|
treehouse
Starting Member
2 Posts |
Posted - 2008-09-30 : 23:28:23
|
I have to use "trace replay" since the trace file contains the database operations that I want to repeat on another database server. So I cannot start a new trace.quote:
Originally posted by sodeep
Why can't you start over new trace with that Database as filter type ?
|
|
|
|
saurabhsrivastava
Posting Yak Master
216 Posts |
Posted - 2008-10-01 : 21:07:57
|
| YOu can use READ80TRACE utility to get the output trace in HTML format for READ/Write CPU time etc. sometimes it fails as well depending on events captured because READ80TRACE wants certain events to be in trace for successful processing. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-10-02 : 09:37:59
|
quote:
Originally posted by saurabhsrivastava
YOu can use READ80TRACE utility to get the output trace in HTML format for READ/Write CPU time etc. sometimes it fails as well depending on events captured because READ80TRACE wants certain events to be in trace for successful processing.
This doesn't relate to what OP is looking for. |
|
|
|
|
|
|
How to exam the result of trace replay?