473,320 Members | 2,092 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Constipated publisher (SQL 2005)

Jim
We have a 2005 Publisher that is publishing to one 2005 subscriber and two
2000 subscribers. It's been fine, but yesterday I had to import some data
into one of the tables that is being published.

The data isn't huge in terms of number of rows (less than 3,000) but each
record contains a lot of data. Since importing, the subscriptions for that
table are failing, claiming not to be able to query row metadata at the
subscribers. In addition the Publisher starts using more and more memory
(the replmerge process) and slows down until it's virtually unusable.

I'm guessing that perhaps a custom profile might be of use here, but I'm not
at all clear as to which aspects to alter. I'd be inclined to up the query
and keepalive timouts, but would altering the read and write batch sizes
down from 100 to, say, 5 help?

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
Apr 10 '08 #1
0 1254

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: mokles | last post by:
Hello All, The setting is SQL server 7, on Windows NT. If the distributor can not access the log on the publisher database ( but subscribers are not deleted yet), will the full backup of the...
0
by: Ron | last post by:
Hi All, I am fairly new to MS SQL Replication. I have two servers one is setup as the publisher and the other is setup as both the subscriber and the distributor. Due to server reboots, the...
2
by: Query Builder | last post by:
I have a wired situation..! I set up transactional replication on one of my development server (SQL 2000 Dev Edition with sp4). It is running fine without any issues and all of a sudden, i...
2
by: Charles Zhang | last post by:
I used Visual Studio 2005 to create a "Windows Installer Package". When I ran the package on a Windows XP computer, I got a warning -- "Unknown publisher". My question is: what steps do I need...
0
by: =?Utf-8?B?TWFyayBX?= | last post by:
I have just upgraded Visual Studio from 2003 to 2005 and am in the process of converting my VB applications. Most conversions have gone quite smoothly. However, I have several Add-Ins that I...
1
by: PatrickW | last post by:
Hi, I am trying to set up a Updatable Subscriptions for Transactional Replication with SQL 2005 (queued updating). I have a stored procedure "SYS_spShellTest" which is replicated to the...
6
by: pugalenthi | last post by:
I am trying to connect to the SQL Server and then to create a database table using PHP script. The code is as follows,<job id="sqlserver1"> <script language="PHPScript"> $connection =...
1
by: Mike Husler | last post by:
If we are doing a 1-way replication from a SQL Server 2000 (Publisher) through a firewall to a SQL Server 2005 (Subscriber), do any ports need to be opened from the Subscriber back to the...
0
by: tsharp89 | last post by:
We currently have SQL Server 2000 and have merge replication. We have the following process 1. Data is transfered to a laptop, data on the laptop is changed and the data on the server is 'locked'...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.