I have a large SQL database that gets a lot of very fast insertions - sometimes up to 250 per second - possibly more.
The machine is pretty powerful (6 core XEON, hyperthreaded, 32Gb RAM) - and I have a duplicate on the same network. My question is - how fast should this sort of database be able to replicate to a second server? The data is financial, and time-sensitive - so a few seconds delay is not acceptable; I might just about get away with a second.
The servers are both running MS SQL 2008, 64 Bit edition - one as Standard Edition (publishing), and the other is Web Edition (subscriber).