Merge Replication IIS Worker Process Error

Question

Everyday between 18:00 and 20:00 nearly 1000 PDA Subsriber anonymously
synchronise via Merge Replication and at least two time he have the error :

IIS Worker Process
Faulting application w3wp.exe, version 6.0.3790.1830,
faulting module sscerp20.dll, version 2.0.7331.0,
fault address 0x000110f4.

And subscriber which synchronising meanwhile becomes suspect.

Can someone offer a suggestion as to the cause of and correction for
this
error?

Thanks,

Hakan G

Here is some details about our system:

Client Side
OS: Windows Mobile [phone]
DB: SQL CE 2.0
Microsoft SQL Server CE (ssce20.dll) 2.00.4415.0
Microsoft SQL Server CE Client Agent (ssceca20.dll) 2.00.4415.0
Development Tools: VB.NET 2003
Service Pack: .NET Compact Framework 1.0 SP3

Server Side
OS: Microsoft 2003 SP1
Internet Information Services (INETINFO.EXE) 6.0.3790.1830
(srv03_sp1_rtm.050324-1447)
IIS Worker Process (w3wp.exe) 6.0.3790.1830 (srv03_sp1_rtm.050324-1447)
HW:IBM XSERIES_346 Intel(R) Xeon(TM) CPU 3.60GHZ (2CPU) 5,00 GB RAM DB:
SQL CE 2.0
DB:SQL Server Standart Edition 8.00.2039(SP4)

SQL CE Server 2.0
Microsoft SQL Server CE Server Agent (sscesa20.dll) 2.00.7331.0
Microsoft SQL Server CE Replication Provider (sscerp20.dll) 2.00.7331.0

Merge Replication Properties
-----------------------------
status : 1
retention : 21
sync_mode : 1
allow_push : 1
allow_pull : 1
allow_anonymous : 1
centralized_conflicts : 1
priority : 100.0
snapshot_ready : 1
publication_type : 1
enabled_for_internet : 0
dynamic_filters : 1
has_subscription : 0
snapshot_in_defaultfolder : 1
alt_snapshot_folder : NULL

Merge Agent Profile:
parameter_name                   value
-------------------------------- ---------
-BcpBatchSize                    100000
-ChangesPerHistory               100
-DestThreads                     4
-DownloadGenerationsPerBatch     500
-DownloadReadChangesPerBatch     500
-DownloadWriteChangesPerBatch    500
-FastRowCount                    1
-HistoryVerboseLevel             1
-KeepAliveMessageInterval        300
-LoginTimeout                    15
-MaxDownloadChanges              0
-MaxUploadChanges                0
-MetadataRetentionCleanup        1
-NumDeadlockRetries              5
-PollingInterval                 60
-QueryTimeout                    300
-SrcThreads                      3
-StartQueueTimeout               300
-UploadGenerationsPerBatch       100
-UploadReadChangesPerBatch       100
-UploadWriteChangesPerBatch      100
-Validate                        0
-ValidateInterval                60

 

Answer 1

You have a high-volumne replication scenario going on there and while I have not seen this specific error, I know you can increase the default thread pool used on the IIS server to broker all of this replication.  There is a way to get -SrcThreads 3 to a larger number and I just saw it in the Books OnLine recently - I'll have a look and see if I can give you more details on this.

In the meantime perhaps Laxmi knows how to tune this setting off the top of his head.

 

-Darren

 

Answer 2

For configuring SQL Mobile Server Agent on IIS: Here are typical knobs,

1) MAX_THREADS_PER_POOL - No.of threads to handle the incoming sync requests

2) CLEANUP_INTERVAL - Sync sessions cleanup

3) USAGE - Restricting the support only to RDA/Merge/Both

Darren, Sorry I did not get what is meant by SrcThreads. 

Thanks,

Laxmi Narsimha Rao ORUGANTI, MSFT, SQL Mobile, Microsoft Corporation