Indexing your Horizon View Database

I am currently troubleshooting some issues with the Horizon event database having some performance issues. Working with support they pointed me to KB2094580.

By Default the view event database is not indexed. I was curious as to way I always had issues pulling up events in the Horizon View Administrative interface, but as soon as I followed the steps, it was almost immediate now, where i use to have to wait an extremely long time.

To create an index on your event database run the following command on your SQL event database. XXX is the prefix of your database, if you do not have a prefix set, just leave it as dbo.event_data.

CREATE INDEX IX_eventid ON dbo.XXXevent_data (eventid)

Your Horizon View DB is now Indexed. Enjoy the Speed!

Share on