By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,363 Members | 2,143 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,363 IT Pros & Developers. It's quick & easy.

SQL2005 performance problem

P: n/a
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
Share this Question
Share on Google+
2 Replies


P: n/a
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

P: n/a
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.