Indexing the Audit Results Table

NOTE   The following "one time" configuration task applies only if a dialog recommends indexing of the Audit Results table. The dialog only displays, if applicable, when a master user logs on to the VSA.

The response time of the Kaseya Server database can be improved by indexing the audit results table. Depending on the number of records in this table, this process could take 1 to 4 hours to complete. The Kaseya Server should be shut down during this process to prevent the possibility of losing audit data.

  1. Click the Stop Kserver button on the System > Configure page.
  2. In SQL Server Management Studio:
  1. Open a new query window and ensure ksubscribers is the selected database.
  2. Run the following stored procedure: Exec spCreateAuditRsltAppsPK

This procedure might run 1 to 4 hours or longer, depending on the number of records in the table and the speed of the SQL Server.

  1. Click the Start Kserver button on the System > Configure page.

NOTE   Creating indexes manually or through the SQL tuning advisor on the ksubscribers database can cause errors during Reapply-Schema and when upgrading to new versions of Kaseya and is strongly discouraged.