I'll just add this info about Kerb, in case someone's looking...

Your two servers must have their system times set closely...Within two mins, I believe. If not, you will get...

Well, I dug through the logs on the Repubs, and the Master, as well as the default traces.

I found that I could see exactly when the repubs started...

Thanks for replying, NJ.

It might be it. They said a "full sync" fixed it...I'm going to assume they mean a re-initialization. One guy hacked the sysmergearticles table to...

I'll re-read it today, with this information in mind....

Yes, the low filter is 5%....Probably a bit low, eh? Perhaps 10%...

So, the difference between 5 and 10 is enough to really bloat it?

K, so this was a general...

Thanks for the suggestions...

So, it's not unusual, then, to see such log usage during index rebuilds, based on the size of the large tables.....

We use something similar...It's not blindly rebuilding them.

It's gonna be awesome!

Gail, what is your Avatar a picture of?

-Grubb

Thanks for the links, Steve!

As an aside, Gail is teaching an entire class on Execution Plans at this year's PASS conference:

Seven delicious hours!! See you there!

Thanks for the help, Ignacio!

Yeah, I use that one all the time, but just in case, I pulled the link.....And there I discover that sp_change_users_login is deprecated!! "ALTER USER"...

Is this "purge job" is something you authored?

I've had a lot of trouble on busy servers trying to get SQL Server to store enough history to be useful. Frequently-running...

Great idea, Michael...Thanks!

Yes, the number of executions is a huge problem...

In fact, we're averaging 600 sessions at any given time, and I see login peaks of 2300-4400 logins per second. We're...

Sorry for the delay, guys...I didn't abandon, just went to lunch!

Here's the "after" plan....

Ninja's, some data there:

No long-term locking affecting it (lowest I can set the threshold is one second). However, running that often, every bit is a problem!

However, would a block...