VMware Horizon View – Maximum concurrent connections within a certain period

Last week, I received the question from a client wether it was easy to see the maximum concurrent connections in VMware Horizon View between two distinct dates.

There are several ways to do this:

  • Through vRealize operations manager for Horizon
  • In the standard VMware Horizon View console you can see the maximum number of concurrent connections from the time of installation or from the last time you reset the value, so this is not really that useful

ViewAdministrator_maximumconcurrentconnections

  • By executing some PowerCLI commands: See this post From Ivo Beerens
  • By executing some SQL commands.
    • The SQL command I use to get this information is
SELECT TOP 1
[Time]
as date
,convert(numeric,rtrim(substring[ModuleAndEventText],79,100)))
as 'Maximum concurrent sessions'
FROM [yourvieweventdatabasename].[dbo].[event.historical]
WHERE [EventType]='BROKER_DAILY_MAX_DESKTOP_SESSIONS'
and [Time]<=DATEADD(dd,-15,getdate())
and [Time}>=DATEADD(dd,-30,getdate())
ORDER BY [Maximum concurrent sessions]

This query will return the maximum number of concurrent connections between 30 days ago and 15 days ago.

SQLQuery_maximumconcurrentconnections

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.