Slow View Event Database

After upgrading my environment from View 5.3.2 to Horizon View 6.0.1, I started having the following issues once production loads returned to normal:

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

This is discussed in VMware KnowledgeBase article – The Event database performance in VMware View 6.0.x is extremely slow (2094580)

To resolve this issue, you have to create an index.  Run the following 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.  In my case it was VDI_event_data so I ran:

CREATE INDEX IX_eventid ON dbo.VDI_event_data (eventid)

So now recent Events load in View Administrator in seconds instead of minutes.