Ran into this again, 5yrs later, and stumbled across my own post. I believe I've got a handle on what's happening here, and thought I could update this in...

Hi R.P. - that's a really good suggestion, it was one of the items we'd originally thought may be causing our problem. A couple years ago we had to...

I think you're right about maxversion_at_cleanup being a symptom of a bigger problem. We dropped the smaller article and re-published it over the weekend and the maxversion_at_cleanup reset back to...

Hi,

Thanks for the response. Confirmed previously that the merge agent is locking tables that have a high maxversion_at_cleanup - one of the two tables that I mentioned - and I've...

Thanks for your reply again, sorry it took a bit for me to get back in here.

I've tried running from BIDS debugger, from dtexec command line, and as a SQL...

I have, and there's plenty of RAM free (8GB of 16GB free when it crashes), but is there another limitation that I'm running into? Something per-process?

I read that there's...

Just to reiterate some of the points from the other thread. Indexes are rebuilt nightly, and fragmentation doesn't seem to be a problem. Statistics are updated automatically, and...

I think I've found a workaround, but I'm not sure why this has to be done this way.

Each log even will only have 1 matching lookup out of the 5....

I was going to look into a 'Plan Guide' to see if I could force the replication stored procedure to use the same clustered index seek that the query uses...

Attached is the profiler trace for when I executed sp_MSenumchanges_belongtopartition manually, showing it taking 8 minutes. Wait time on the process is zero, task state is running the whole...

I think I may be getting somewhere, anyone else have any suggestions on what to look at next? If I execute:

exec sys.sp_MSenumchanges_belongtopartition

38,

100,

'1510638,1510652,1510653,1510654,1510655,1510656',

89259003,

'00000000-0000-0000-0000-000000000000',

'8236EE55-51EF-4E2E-A0A6-B2D26781C214',

1510638,

1510656,

1,

0,

'F6DE0C2C-3305-4F24-B272-7C9B84705A03'

It takes 10 minutes to run.

But, as...

Awesome, thanks Gail, Gus, and everyone else for your input. It only took a few dozen experts to convince me (and Gail explaining her article to me), but I...

GilaMonster (1/2/2013)

---

RAM-only table-variables are indeed a myth.

Table variables (like temp tables) will be in memory if possible and written to disk if not. They are always allocated space in TempDB,...

I know that at this point, for me the answer will still be "test various tempdb storage solutions, benchmark, and pick the best one for my environment". But I'm...

Gus, RE the isolation level, it's the default read committed, with snapshot off.

L' Eomot Inversé (1/2/2013)

---

I think that the source of confusion here is teh difference between allocating space for...