Enable And Disable contraint issue

We are using SQL transaction replication to replicate data between PROD to BI server. During the application application db changes we will be running disable constraint, execute all change and then enable constraints. This enable and disable constraints is taking more than 15 min in production which transaction replication happening, QA/UAT same process happening in 1 min.

Is this the normal behavior.How to solve this

Script used

Total constraints :2600

alter table T_ATTN_QUEST NOCHECK constraintname (sample)

May 21st, 2015 7:21am

The same configuration( RAM, hardware etc) on QA/UAT and production? Maybe on production sever, other software consume much resources.

Use profiler to monitor your SQL Server on production server, check if you have block processes.
Free Windows Admin Tool Kit Click here and download it now
May 22nd, 2015 3:04am

Production server is higher specs than QA/UAT. My impression is whether Transaction replication will cause the slowness as there disable constraint have "Alter table" command which is a schema change.
May 22nd, 2015 3:38am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics