I have 2 servers : a database server (SQL Server 2008, called server A) and an application server (called server B) which send SQL queries to the first one.
They are actually in the same LAN, but we planned to separate them in 2 different geographical sites. I try to estimate the minimum bandwidth required between the 2 servers, so that my application doesn't suffer from performance issues. How can I estimate the amount data that are exchanged between the two servers ?
I'd like to have, for example : for day xx/xx/xxxx, there was approximately 1.5 GB of data send from A to B and 750 MB from B to A.
Is there a diagnostic tool on SQL Server to measure that ? Or just a network tool ?
I have no access to any physical hardware device, but I'm admin of both servers. Thanks.