VMware Cloud Community
ooajala
Enthusiast
Enthusiast

Broker Agent service causing SQL blocking and deadlocks?

Hi Community,

I am not sure if anyone can help me with this before I put in an official SR with vmware. So we have a couple of connection servers that have the broker agent installed which are our View Pods.

We have had issues with the broker agent service using most of the RAM and in addition, the database team have complained about SQL deadlocks and blocking occurring. Those blocking are gone when I stop the broker agent service. I know this cannot be the fix because I definitely need the service on to record Horizon connected sessions metrics etc.

pastedImage_0.png

The below is on the SQL database server managing one of the connection servers.

pastedImage_1.png

Is anyone experiencing this kind of issue?

Please advise.

Thanks in advance.

--
*** If you like my response, please click "Like" below, if you think I answered your question to the best of my abilities, please mark post as Correct Answer ***

3x vROps Environments implemented across my organization. VDI vROPs 8.4 ::: Epic vROPs 8.4 ::: Shared vROPs 7.0
vROPs Adapters in use: EpicCare & Horizon View Adapter 2.1
Reply
0 Kudos
2 Replies
EvanEverett
Contributor
Contributor

Hello ooajala,

Were you ever able to get an answer on this? It would seem our organization is running into a similar issue...

Thanks!

Evan

Reply
0 Kudos
EvanEverett
Contributor
Contributor

In case anyone else runs into this issue, this is a bug with Horizon View. Per VMware Support:

As covered, this is a known issue identified on the Horizon View side.  It is targeted for the 7.10 release of Horizon view (tentatively Q3, but subject to change).

The only workaround is to lower the Event Settings configured in View Configuration > Event Configuration tab to as low as you can for the interval seen there.

As a side note and word of caution, be careful when you adjust the Event Configuration from 3 Months (Max) to 1 Week (Min) retention policy. The SQL DB is purged and causes extreme congestion with IO at the disk level. I also tested going from 3 Months to 2 Months (next lowest retention policy) and still had the issues of maxing out the SQL DB I/O. The solution for us was to create a new SQL DB, change the event retention to one week, and then point to the new SQL Database on the events.

Thanks,

Evan

Reply
0 Kudos