Thanks for the reply and sorry for the delay after the US Soccer game i crawled into a corner and cried for a few hours. The original code is...

Doing that now qnd ill report back. I did that with our main clusters that have 256gb of ram but not this one. Ill try it and report...

I will get those for you. Max mem has no limit SQL is allowed to have it all. this is a dedicated server.

Stats: Note it just happened...

Yeah I have wrote an app to generate the publications and subscribers. Right now its all Push but I do have the distributor on a different server and subnet...

Arni thanks that's what I thought. Well I will be testing with 1,500 so I'll post my results once done

Why did you rebuild the publication and subscriptions after a simple subscriber reboot? The transactions would of just built up on the publication DB and then synched up once...

SQL Cluster 2008 need not the exact same hardware but rather compatible hardware. I'm currently running a 2 node cluster with Node A (64proc, 256GB) the primary and Node...

SQL has zero problems failing over VLDB's and I can contest to that since I have 2 node clusters that fail over 1,380 databases ranging from 100GB to 1.5TB without...