The client production server CPU starts thrashing. Task manager indicates
that SQL server is gobbling CPU cycles. Having a look at the replication
monitor, it is obvious that indivual synchronisations to the mobile devices
are taking significantly longer expected.

Observing an indivual synchronisation attempt, the Upload changes to
Publisher rows are very quickly resolved.

The Download changes to Subscriber seems to take up a very long time.

Along the way, the estimated completion does a few interesting things, like
going from 100% complete with no estimated time to complete, back to
seomthing like 77% with 2 minutes left to complete.

This sort of behaviour occurs when there are only a hundred rows to download.

Synchronisations for minimal amounts of data suddenly taking anywhere from 2
to 15 minutes. Totally unacceptable form the client perspective but seems
that 2005 behaves quite different from 2000 and the tricks are yet to reveal
themselves.

Note - It is a server hardware issue as there is in excess of 3 GB ram, the
database is on a SAN and there are 4 3Ghz CPUS in operation.

Any possible help appreciated as this issue is beginning to drag on.