469,138 Members | 1,283 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,138 developers. It's quick & easy.

SQL2005 performance problem

Jim
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 help.

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
Mar 20 '08 #1
2 1437
Jim
On 2008-03-20, Jim <ji*@magrathea.plus.comwrote:
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
Mar 20 '08 #2
hi!
Can you in activity monitor see what the corresponding session is
waiting on
or if its blocked?
/Bjorn
Mar 21 '08 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Tawfiq | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
1 post views Thread by Mortomer39 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.