Server performance / SQL broker

Problem:

I don't see any activity on the database side and none of the processes are spiking. Server is still slow and agents are dropping in and out.

 

Cause:

SQL Broker might be the reason.

 

Resolution:

Go to <Kaseya VSA URL>/inc/perftest.asp

or

Run the following query in SQL.

select SUBSTRING(far_service,1, 50) 'conversation_endpoints FarServiceName', state_desc 'state', count(*) cnt FROM sys.conversation_endpoints
GROUP BY far_service, state_desc
ORDER BY cnt desc

Go to the Service Broker Information section. Make sure that the Service Broker is properly registered to the server. If the message is in green, this indicates that it is properly registered.

2018-03-26_08_40_45.png

Next, make sure that there are no 'Disabled Queues'.

How do I enable the disabled SQL broker queues?

Next, check the Open and Closed Conversation count. If you see the "conversationEndSyncService" is high, don't worry about it. However, if  you see any of the other queues are high. The count depends on the number of agents that you have. If you have 2000 agents and the count is at 400, this is perfectly fine. However, if you have 300 agents and the count is at 1000, then this can be a problem.

To reset the SQL broker queue, run the following command.

ALTER DATABASE ksubscribers set NEW_BROKER WITH ROLLBACK IMMEDIATE

 

Applies to:

Kaseya VSA (all versions)

Was this article helpful?
4 out of 4 found this helpful
Have more questions? Contact us