Follow

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.

 

SOLUTION:

SQL Broker might be the reason.

Go to (Kaseya URL)/inc/perftest.asp

You can also 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.

Next, make sure that there are no 'Disabled Queues'. Make sure that none of the SQL broker queues are disabled.

(Link to KB to enable SQL broker queue)

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

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Article is closed for comments.