It was a congestion in the tempdb.

In the end even "normal" inserts were taking ages. A restart of SQL Server and thus recreating the tempdb solved the problem for now.

In...

Hi, thanks for the answer.

CPU and RAM on the machine are fine. when running the procedure there is no significant CPU or memory stress in SQL Server (or outside).

How can...

Hi guys,

after some testing and som trial-and-error in my test lab I found a way to do replication without snapshot or backup initialisation.

The trick is basically

a) not to initialise...

That (Ins, Upd, Del) wouldn't actually be a problem because the table only has inserts, but I get your point.

I will look into Service Broker.

Thanks for the answers.

Maybe I wasn't clear enough on what I intend to do.

It is not about replicating only a few tables instead of all.

It is about replication only parts...

Sorry for coming back so late on this.

Yesterday I finally had time to set up a lab and run some tests.

Here the findings:

- Yes, partitioned tables can be...

Wow, thanks for that. If that is true, that totally solves it. cool.

I...

(almost) live means I could get through with being up to 10 minutes behind live, within 5 minutes would be good. < 1 min would be fantastic.

Yep, you are absulutely right. I seem to have succumb to that myth.

I even tried...

Well, several issues with this, but the foremost issue is with using

where ... in (select...)

Please don't. You already have your IDs in a table and a Primary Key (hopefully...