question

PHACTOR avatar image
PHACTOR asked

SQL 2005 table query timeout with merge replication

We have a table that is giving us a query timeout whenever you try to update it through the application or the SQL editor we can however we can update it through query analyser but it can take up to 60 seconds, it should also be noted that the table has merge replication setup on it. When we do a backup and restore (restore as different name) of the same database in the same environment and add merge replication we are able to update the table with no problems. We don’t want o take down the live database as we have 167 subscribers that will be affected. Any help would be greatly appreciated?

replicationmerge
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Fatherjack avatar image
Fatherjack answered

I would suggest running SQL Profiler to capture what is actually going on when the scripts run. Is the server very busy? How often is replication running? It could be some unfortunate locking going on with different processes

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.