Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Service Broker Expand / Collapse
Author
Message
Posted Monday, October 8, 2012 12:10 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, August 27, 2014 3:52 PM
Points: 528, Visits: 1,258
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.
Post #1369623
Posted Tuesday, October 9, 2012 6:09 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 1:35 AM
Points: 2,598, Visits: 3,884
How you got the values 2.8Mbps & 200Kbps??
Post #1370349
Posted Tuesday, November 6, 2012 7:50 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, August 27, 2014 3:52 PM
Points: 528, Visits: 1,258
Sorry for the late reply, this value is taken from VMWare network utilization chart.
Post #1381771
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse