Search the VMware Knowledge Base (KB)
View by Article ID

The Event database performance in VMware Horizon View 6.x and 7.0.x is extremely slow (2094580)

  • 24 Ratings
Language Editions

Symptoms

  • The Event database performance in VMware Horizon View 6.0.x is extremely slow when browsing within Horizon View.
  • There is high CPU usage on the SQL server, hosting the Event database.
  • The larger the Event database becomes, the slower the queries run.

Cause

This issue occurs because a table in the Horizon View Event database has no index. As a result, searches become very slow due to a table scan being done.

Resolution

To resolve this issue, create an index:

To create an index:
  1. Run this command on your SQL Event database:

    CREATE INDEX IX_eventid ON dbo.VDIevent_data (eventid)

    Substitute VDIevent_data for the table name using your Event database prefix.

See Also

Request a Product Feature

To request a new product feature or to provide feedback on a VMware product, please visit the Request a Product Feature page.

Feedback

  • 24 Ratings

Did this article help you?
This article resolved my issue.
This article did not resolve my issue.
This article helped but additional information was required to resolve my issue.

What can we do to improve this information? (4000 or fewer characters)




Please enter the Captcha code before clicking Submit.
  • 24 Ratings
Actions
KB: