We have an installed site with two SQL2005 servers (workgroup, SP2).

At the publisher we recently (yesterday) bulk inserted about 2million lines
into a table from a third server that's going to be part of the replicating
group. However, since importing these records (using 'Import Data' to get
the data in and then running a no-change update to make replication aware of
them) the performance has become dreadful. The hard-drive is swamped with
disk writes.

The first symptom that something was wrong was when replication started
timing out, even when I turned off all subscriptions except for one - and
that one didn't have any of its tables modified by the import. Even putting
the agent on a slow profile with extended query timeouts doesn't .

Any suggestions?

Many thanks.

Jim
--
http://www.ursaMinorBeta.co.uk
"When one of the local cats, an especially fluffy creature with a vast
tail, rushed down the street towards me the other day, mewing delightedly,
I have to admit it was probably shouting 'HAZ CHEZBURGR?' " - Bella, ucsm

On 2008-03-20, Jim <jim@magrathea.plus.com> wrote:
> We have an installed site with two SQL2005 servers (workgroup, SP2).
>
> At the publisher we recently (yesterday) bulk inserted about 2million lines
> into a table from a third server that's going to be part of the replicating
> group. However, since importing these records (using 'Import Data' to get
> the data in and then running a no-change update to make replication aware of
> them) the performance has become dreadful. The hard-drive is swamped with
> disk writes.

I should also point out that it's still swamped 24hrs later. Replication is
switched off currently.

Jim
--
http://www.ursaMinorBeta.co.uk
"When one of the local cats, an especially fluffy creature with a vast
tail, rushed down the street towards me the other day, mewing delightedly,
I have to admit it was probably shouting 'HAZ CHEZBURGR?' " - Bella, ucsm

hi!
Can you in activity monitor see what the corresponding session is
waiting on
or if its blocked?
/Bjorn