I would recommend setting min/max memory to 28GB if you have 2 cores. If you have one then I would set it to 30GB. I would also configure lock pages...

I am doing an insertion with a procedure.All the tables inside procedure is heavilly weighted.

Procedure contains following process.

Table A contains 5m data - insertion

Table Aa contains 14m data -- Child...

Glad I could help 😀

I think what you want is information from the system tables that are on your publishing or subscribing database depending on your replication architecture. Mine are on my publishing databases...

I think you've come up with a smart idea - msdb.dbo.sysjobhistory. I agree with you that there should be an easier way to deal with messages in T-SQL :pinch:...

You can see you have some heavy hitters weighing in this subject (not so much myself,...

You only need one distribution database, and it can be on any server. The next thing to do is test the communication between your publishing server and distributing server, which...

The Database Engine maintains both schema-bound and non-schema-bound dependencies. These dependencies are automatically refreshed during any operation that impacts dependency tracking, for example when upgrading a database from an earlier...

Is your O/S and SQL on 64 bit or 32 bit platform? What is the result of the following statement?

Select @@version

No, it's not. You should use a 3rd database called the distribution database that takes care of all the metadata and transactions. I use a 3rd server for this, but...

The individual hired to be a DBA should be a trusted resource. If you can't trust the DBA (and they can sometimes be untrustworthy, but the majority of us are...

When you select from sys.sql_dependencies you get nothing? If so, how many table are returned from

Select * from sys.tables?

I wouldn't use perfmon, I would stick with profiler. For a real time query you can also use:

SELECT --top 1 Object_Name(resource_associated_entity_id),

CASE WHEN resource_type = 'Object' THEN OBJECT_NAME(resource_associated_entity_id)

...

I suggest looking at the actual execution plan for figuring out whether the optimizer did anything different. You are correct that the optimizer can and will take liberties with T-SQL...

You need to query the distribution database and the mssubscriber_info table.