So while the query is executing on Prod, do you see any blocks? is the query on running state all the time or suspended? do you know what is the...

Do you have resource governor enabled?

May be you can try updating stats on all the 8 base tables. Also check fragmentation on all the 8 tables. Verify the MAXDOP settings on both the machines.

yeah I see what you are saying. Yeah, I don't think there is a way without dropping the replication. you ve to drop and recreate it.

So you are replacing both Distributor and subscriber keeping the publisher same ?What is the problem in creating a new publication ?

Great, It works! Thanks a lot

I m not using any vertical filtering. The final goal is to transfer all the data including identity column. I never had this issue in transactional replication.

Thank you

Thank you very much ,That is helpful. Right now, we don't see performance issues. We should be good.

Thank you very much for your inputs. The provided links are the real place to start with .

Thanks for the reply.

We applied the similar load as in production, the load will be exactly same after it goes to production.

I collected the above data in for 20...

yeah. May be I should try passing the variable in the DLL itself.

Thanks for the quick reply.

GRANT VIEW SERVER STATE to 'Login'

This is the minimum permission required to see the DMV information

Sample file looks like:

Header:

Column A Column B Column C

333 ...

Thank you so much. It works.

Thanks guys! The script works great.