SQL Server Performance Forum – Threads Archive

High Load data replication locking issues

Hi,
I’m currently encountering a problem with transactional replication on SQL 2K. An application needs to drop and recreate tables nightly, that are necessary for replication. These tables (only a handfull) have ~250000 records in them. These tables are also required for replication, so I’ve scripted seperate drop, recreate and initialize t-sql scripts, that are executing within DTS packages. Due to continuous activity with the application and database, I’m currently encountering irregular table lock timeouts in MSSQL, which is causing the application to fail. I have checked that concurrent snapshots are set, and have set each agent to use a seperate agent each. I have also extended the timeout on all 3 agents. The distributer is local.
Does anyone have any suggestions as to how I can reduce or stop these lock timeouts? Thanks. [xx(]

http://www.sql-server-performance.com/transactional_replication.asp
http://www.sql-server-performance.com/replication_tuning.asp
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/tranrepl.mspx For your information and investigation on the current problem. Satya SKJ
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

Thanks Satya.

]]>