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...
> > 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
>
>|||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 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
>
>|||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...
> 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
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
> >
> >
> >|||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/details.aspx?FamilyID=5691ab53-893a-4aaf-b4a6-9a8bb9669a8b&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

plan for box upgrade

sql2k sp3
Im going to be moving sql from one box to a newer one
with better hardware today. This is my plan:
Restore a backup of Master and MSDB onto the new box.
Detach and attach the user db's.
Ive used detach and attach but never in this scenario.
Does anyone see a problem with this?
TIA, ChrisYour plan is perfect, only thing is that the restored
master database will still have entries for user
databases, even if they don't exist on new server yet. I
believe you can get rid of them by issuing drop database
command.
Then start attachig user databases, and then msdb.
hth.
>--Original Message--
>sql2k sp3
>Im going to be moving sql from one box to a newer one
>with better hardware today. This is my plan:
>Restore a backup of Master and MSDB onto the new box.
>Detach and attach the user db's.
>Ive used detach and attach but never in this scenario.
>Does anyone see a problem with this?
>TIA, Chris
>
>.
>|||My plan wasnt to detach and attach msdb at all. It was to
backup/ restore it. Will this still work?
>--Original Message--
>Your plan is perfect, only thing is that the restored
>master database will still have entries for user
>databases, even if they don't exist on new server yet. I
>believe you can get rid of them by issuing drop database
>command.
>Then start attachig user databases, and then msdb.
>
>hth.
>>--Original Message--
>>sql2k sp3
>>Im going to be moving sql from one box to a newer one
>>with better hardware today. This is my plan:
>>Restore a backup of Master and MSDB onto the new box.
>>Detach and attach the user db's.
>>Ive used detach and attach but never in this scenario.
>>Does anyone see a problem with this?
>>TIA, Chris
>>
>>.
>.
>|||you can backup/restore or attach/detach msdb database. or
just rename new mdf and ldf files for msdb on new server
(just for backup) and then copy original mdf/ldf files in
their place when the sql server is not running.
You can do same for master database as well, if you don't
want to use backup/restore.
hth.
>--Original Message--
>My plan wasnt to detach and attach msdb at all. It was to
>backup/ restore it. Will this still work?
>
>>--Original Message--
>>Your plan is perfect, only thing is that the restored
>>master database will still have entries for user
>>databases, even if they don't exist on new server yet. I
>>believe you can get rid of them by issuing drop database
>>command.
>>Then start attachig user databases, and then msdb.
>>
>>hth.
>>--Original Message--
>>sql2k sp3
>>Im going to be moving sql from one box to a newer one
>>with better hardware today. This is my plan:
>>Restore a backup of Master and MSDB onto the new box.
>>Detach and attach the user db's.
>>Ive used detach and attach but never in this scenario.
>>Does anyone see a problem with this?
>>TIA, Chris
>>
>>.
>>.
>.
>

PK field generate by SQL server using Bulkload

Hi, I'm a bit of Bulkload newbie.
I would like to import XML files into my SQL2k table,
but PK field (identity-yes field) in this table has to be
generated by SQL server.
What have I to write in my XSD file for this PK field?
Thanks for guru :-)Just make sure that bulkload has KeepIdentity=False set on the API, that
should do it.
Irwina
"Gen" <anonymous@.discussions.microsoft.com> wrote in message
news:061301c52a47$36077470$a501280a@.phx.gbl...
> Hi, I'm a bit of Bulkload newbie.
> I would like to import XML files into my SQL2k table,
> but PK field (identity-yes field) in this table has to be
> generated by SQL server.
> What have I to write in my XSD file for this PK field?
> Thanks for guru :-)|||It works!
Thank you so much

>--Original Message--
>Just make sure that bulkload has KeepIdentity=False set
on the API, that
>should do it.
>Irwina
>"Gen" <anonymous@.discussions.microsoft.com> wrote in
message
>news:061301c52a47$36077470$a501280a@.phx.gbl...
be
>
>.
>

PK field generate by SQL server using Bulkload

Hi, I'm a bit of Bulkload newbie.
I would like to import XML files into my SQL2k table,
but PK field (identity-yes field) in this table has to be
generated by SQL server.
What have I to write in my XSD file for this PK field?
Thanks for guru :-)
Just make sure that bulkload has KeepIdentity=False set on the API, that
should do it.
Irwina
"Gen" <anonymous@.discussions.microsoft.com> wrote in message
news:061301c52a47$36077470$a501280a@.phx.gbl...
> Hi, I'm a bit of Bulkload newbie.
> I would like to import XML files into my SQL2k table,
> but PK field (identity-yes field) in this table has to be
> generated by SQL server.
> What have I to write in my XSD file for this PK field?
> Thanks for guru :-)
|||It works!
Thank you so much

>--Original Message--
>Just make sure that bulkload has KeepIdentity=False set
on the API, that
>should do it.
>Irwina
>"Gen" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:061301c52a47$36077470$a501280a@.phx.gbl...
be
>
>.
>