Pat, you misunderstood my problem. We had all the timeouts maxed out or set to 0 for no timeouts. Despite this, we were having problems with the timeouts.

I'm not sure...

Jeff Moden (4/22/2014)

---

ChrisM@Work (4/22/2014)

---

The easiest method I've seen was shown to me by a prawn fisherman in Ullapool and I've only tried it with herring but it would probably work...

What are...

qew420 (4/21/2014)

---

Some tables are huge also but still all was good before adding replication

...

I can check the missing Indexes but again only counting the # of records .. system...

*THAT* is a filleted fish?

Ummm, would you take it the wrong way if I begged you to keep your day job and forget about opening that restaurant? @=)

It doesn't matter that everything was good until Replication was added. When you added Replication onto the server, you added an extra load plus you added a whole bunch of...

Hey, run this script on the Subscriber and see if you're getting lots of small waits or some (or lots) of long waits. Post the results, please.

select * from...

:crying:

Why, oh why, oh why do people insist on pulling scripts off the internet then asking us to modify them to do what they want the scripts to do without...

I do not think your issue is Replication. I think it is either I/O or bad indexes (or both).

A few things to look at on your side:

How wide is your...

Not immediately. I'm in the middle of my own urgent project. But I will work on it as I have time. In the meantime, if you know how to do...

It works the same way.

Edit: Just realized you were referring to a system proc, so deleting my previous statement. Google the error you received when you put in the...

That works wonderfully. Thanks.

Nevermind. I'm in brain-dead mode this...

How do I figure out what the problem is when I add a reference and it has the yellow warning next to it?

Oh, good grief. I'd never have found that. Thank you.