performace issue

[som...@js.com]

hi, i defined a transational publication in server 1 and when I try to add a
subscription in server 2, cause server 1 database access very slow, for
example, aspx applicaiton timeout when
adding subscription and initial data. Is it normal? how to avoid that?
Please advice. Thanks.

[Hilary Cotter]

This is not normal.

I've seen this when creating publications or adding articles, but not when
creating a subscription.

Is it possible you are doing this through the Wizard?

Can you try to do it via sql commands (ie sp_addsubscription).

Also does your snapshot agent automatically kick off?

<som...@js.com> wrote in message
news:e1UDJFwZ...@TK2MSFTNGP02.phx.gbl...

[som...@js.com]

Thanks Hilary,

Use sp_addsubscription works fast now. One more question, if I re-select
articles/re re-generate articles, is it will slow down my production?

"Hilary Cotter" <hilary...@gmail.com> wrote in message
news:983CCEF2-5223-4ACB...@microsoft.com...

[Hilary Cotter]

By default - no!

<som...@js.com> wrote in message
news:#rWcRiGa...@TK2MSFTNGP04.phx.gbl...

[som...@js.com]

Thanks Hilary,

How about change selected ariticles? will it slow down the production? Do I
need to avoid busy trafiic time reinitilal?

"Hilary Cotter" <hilary...@gmail.com> wrote in message

news:42BFABD9-9F54-4CC4...@microsoft.com...

[Hilary Cotter]

Any time you add/change and article it will generate a snapshot. In SQL 2005
this snapshot generation process is as unobtrusive as possible, but it will
still consume cpu cycles.

So you might want to schedule this for a period of low activity on your
server.

<som...@js.com> wrote in message
news:#p47ZXHa...@TK2MSFTNGP02.phx.gbl...

[som...@js.com]

Thanks. where can find the information about how long a snapshot will take?

"Hilary Cotter" <hilary...@gmail.com> wrote in message

news:674E959B-2AA7-4771...@microsoft.com...

[Hilary Cotter]

You can't. History will provide the best information.

Its highly variable due to the volume of data and the current workload on
your server.

<som...@js.com> wrote in message
news:OD7sgoTa...@TK2MSFTNGP05.phx.gbl...

[Paul Ibison]

Any time you add an article it will require a snapshot to be generated.
This snapshot will be of the new article only in transactional replication.
In SQL 2005 the snapshots are taken concurrently - this'll create some
locking but not the exclusive locks on the data which we had by default in
SQL 2000.
Cheers,
Paul Ibison