playback tool

sql2k
Is there a tool that I can:
Box1 and Box2 start with exactly the same data.
Collect all activity for a day on Box1. Inserts/ Updates/ Deletes/ all
queries/ everything except maybe for jobs.
Run all of those activities on Box2. The goal being to make performance
adjustments and see if they do anything.
TIA, ChrisRhI
SQL Profiler will capture database activity and you can script the output as
a SQL file. You can also use the data from profiler to feed into the Index
tuning wizard, therefore if you have a reasonable profileof the live system
you can see what it suggests.
John
"ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
news:B9839F43-5BC8-44DC-922D-D4A20EFD175C@.microsoft.com...
> sql2k
> Is there a tool that I can:
> Box1 and Box2 start with exactly the same data.
> Collect all activity for a day on Box1. Inserts/ Updates/ Deletes/ all
> queries/ everything except maybe for jobs.
> Run all of those activities on Box2. The goal being to make performance
> adjustments and see if they do anything.
> TIA, ChrisR|||Yes,
Read the help file in the SQL Profiler. There are about 6 items that you
must log in order to do this.
Rick Sawtell
MCT, MCSD, MCDBA
"ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
news:B9839F43-5BC8-44DC-922D-D4A20EFD175C@.microsoft.com...
> sql2k
> Is there a tool that I can:
> Box1 and Box2 start with exactly the same data.
> Collect all activity for a day on Box1. Inserts/ Updates/ Deletes/ all
> queries/ everything except maybe for jobs.
> Run all of those activities on Box2. The goal being to make performance
> adjustments and see if they do anything.
> TIA, ChrisR|||The help file is quite lengthy. Could you point me in the right direction?
What do I type in the Index?
"Rick Sawtell" wrote:

> Yes,
> Read the help file in the SQL Profiler. There are about 6 items that you
> must log in order to do this.
> Rick Sawtell
> MCT, MCSD, MCDBA
>
> "ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
> news:B9839F43-5BC8-44DC-922D-D4A20EFD175C@.microsoft.com...
>
>|||I'm able to trace to a trace file and replay. But its trying to replay in
Master. I dont see where to specify which db to replay in?
"John Bell" wrote:

> hI
> SQL Profiler will capture database activity and you can script the output
as
> a SQL file. You can also use the data from profiler to feed into the Index
> tuning wizard, therefore if you have a reasonable profileof the live syste
m
> you can see what it suggests.
> John
> "ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
> news:B9839F43-5BC8-44DC-922D-D4A20EFD175C@.microsoft.com...
>
>|||Hi
The replay will use the default database of the account you logged in as,
therefore it looks like you are issuing a USE statement and have not
included it in the replay or you are using a different account?
John
"ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
news:564DF6FA-D4BE-48B6-83C2-D8831447607C@.microsoft.com...[vbcol=seagreen]
> I'm able to trace to a trace file and replay. But its trying to replay in
> Master. I dont see where to specify which db to replay in?
> "John Bell" wrote:
>
output as[vbcol=seagreen]
Index[vbcol=seagreen]
system[vbcol=seagreen]
performance[vbcol=seagreen]|||As well as standard Profiler you might want to have a look at
Support Tools Available For Stress Testing & Performance Analysis
http://www.microsoft.com/downloads/...&DisplayLang=en
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"ChrisR" <ChrisR@.discussions.microsoft.com> wrote in message
news:B9839F43-5BC8-44DC-922D-D4A20EFD175C@.microsoft.com...
> sql2k
> Is there a tool that I can:
> Box1 and Box2 start with exactly the same data.
> Collect all activity for a day on Box1. Inserts/ Updates/ Deletes/ all
> queries/ everything except maybe for jobs.
> Run all of those activities on Box2. The goal being to make performance
> adjustments and see if they do anything.
> TIA, ChrisR