Groups | Blog | Home
all groups > sql server replication > january 2006 >

sql server replication : Replication Performance


GC
1/20/2006 11:50:02 AM
Hi,

I made a vb.net application that create a subscriber and subscribe it to an
article that I have created.

Yesterday when I start this application it took 2 minutes to create the
subscriber and copy the database from the publisher to the subscriber

Today I start the same application but on another laptop for another
subscriber and after 55 minutes the process was not finish. I stop the
application and I delete all the objects that was create in the replication
for that new subscriber.

Because of that, users that use another application that queries the same
database
get a connection timeout.

Do you have any idea of where should I look to find the nature of the problem?

Hilary Cotter
1/20/2006 9:24:42 PM
Can you figure out at what part of the process does it stall? Creating the
database, connecting with the publisher/subscriber, deploying the snapshot?

--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

[quoted text, click to view]

GC
1/23/2006 5:47:02 AM
The Process is not stall, there still activity.
When I go on the subscription of the subscriber I can see that the
subscription is running. If I do a refresh I can see that some row are
download to the subscriber
because the amount of rows that are downloaded differ each time I do a refresh

May be my problem is the way I create my Articles.
I am a beginner in replication so I dont expect to have the best strategie
the first time.

By the way I want to thank you for all the support that you do to all of us
It is appreciated.

[quoted text, click to view]
Michael Hotek
1/23/2006 6:46:37 AM
sp_who2

Find out who is generating a block.

--
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.

[quoted text, click to view]

AddThis Social Bookmark Button