Deletes in the subscriber

Hi,
I'm having a problem with replication.
The situation is the following:
Operating System of the server: Win server 2003
Database: SQL 2000
Subscribers: SQLCE in PDA's HP5550
Number of subscribers: 23
Subscription: Daily
Somme of the subscribers (PDA) take some a long time to process all the information from the replications. This process of replication take 30 to 45 minutes. In the replication monitor i see that it sends something like 230 000 deletes. It′s a lot for a
PDA processing.
What can i do to improve this situation.
Thatk's for your atention
Best Regards
PPereira
Hi PPereira,
You might be interested in the following document:
Diagnosing and Troubleshooting Slow Partitioned Merge Processes
http://msdn.microsoft.com/library/de...artitioned.asp
Hope this helps,
Reinout Hillmann
SQL Server Product Unit
This posting is provided "AS IS" with no warranties, and confers no rights.
PPereira wrote:
> Hi,
> I'm having a problem with replication.
> The situation is the following:
> Operating System of the server: Win server 2003
> Database: SQL 2000
> Subscribers: SQLCE in PDA's HP5550
> Number of subscribers: 23
> Subscription: Daily
> Somme of the subscribers (PDA) take some a long time to process all the information from the replications. This process of replication take 30 to 45 minutes. In the replication monitor i see that it sends something like 230 000 deletes. It′s a lot for
a PDA processing.
> What can i do to improve this situation.
> Thatk's for your atention
> Best Regards
> PPereira