RE: Replay Trace
From: John Bell (JohnBell_at_discussions.microsoft.com)
Date: 10/19/04
- Next message: Uri Dimant: "Re: Left or right justify columns using SQl code"
- Previous message: John Bell: "RE: file group creation ."
- In reply to: Rick: "Replay Trace"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 19 Oct 2004 00:33:03 -0700
Hi
You can have a multiple copies of profile running, possibly on different
machines. You may well have issues with conflicts if you are writing to a
trace table rather than a file on a high speed disk. Also you may want to
script the SQL to run rather than replay the trace, that way you can add
additional commands such as DBCC FREEPROCCACHE and DBCC DROPCLEANBUFFERS. To
get consistent results you will also have to restore from a backup first to
make sure that the data is in the same state.
John
"Rick" wrote:
> Hi,
>
> I have a trace table I want to replay. I have got it to replay. However, I
> want to trace the replay. I am troubleshooting some potential performance
> problems. So, I have a trace off production server where we see the duration
> for some inserts in the 1000s. I want to reproduce that with my trace
> replay, then do some tuning, then replay again to see if my tuning is
> working.
>
> Thanks,
> Rick.
>
>
>
- Next message: Uri Dimant: "Re: Left or right justify columns using SQl code"
- Previous message: John Bell: "RE: file group creation ."
- In reply to: Rick: "Replay Trace"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
