I am a newbie as far as service broker is concerned.
The problem is with message forwarders. Forwarders are receiving data from multiple sources and as expected, it is supposed to forward all messages to 1 SQL instance. the problem i am experiencing is - on OS level, avg data receipt rate is 2.8 Mbps where as data transmit rate is 200 kbps.
My understanding is that forwarders are like tunnels and they just pass the message across without making any changes. The machines are well spec and when i see network utilization is nearly 0-3% as it is running on 1 GB NIC. Server is running on Win 2008 R2 SP1 and SQL Server 2008 R2 SP2 CU1, 4 CPU cores and 12 GB memory with 8 GB MAX configured for SQL Server. CPU, disk and memory consumption is less than 30%.
I am currently hitting the wall and not able to troubleshoot this issue. any ideas on why data transmit rate is too slow? Anything i need to look from network configuration side. FYI, forwarder is a virtual machine.
also i need help on finding how many pending messages are there from tsql? is it possible? I know there is perfmon counter for it but tsql will be much more helpful.