DavidB (9/11/2008)

---

Richard - If you can really split easily then that is going to be your quickest gain. Additionally, you will immediately split the IO which again is a bonus....

Thanks Gail, I read that article too and it was the one that made me think peer-to-peer replication is what I need to do.

Please everyone understand that I am not...

Adi Cohn (9/11/2008)

---

You are asking the forum’s readers to do the impossible thing – to help improve performance of a database that we know nothing about. If tuning the...

To everyone has replied, I really do appreciate the info.

I have only been here a week so really have not had time to investigate properly. I totally understand that proper...

I have not had a chance to investigate too much, but do know that long running queries are maxing out the CPU.

Someone else identified that IIS was under pressure, hence...

Thanks for the replies. They already had a performance guru in for 2 weeks and he did some of the things you mentioned, but it was not enough.

I suspected that...