October 8, 2012 at 12:10 am
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.
October 9, 2012 at 6:09 am
How you got the values 2.8Mbps & 200Kbps??
November 6, 2012 at 7:50 pm
Sorry for the late reply, this value is taken from VMWare network utilization chart.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply