High CPU usage on SQL server after installation of version 12 of the NovaBACKUP xSP Storage Server

NovaBACKUP xSP / Remote Workforce

There is a Create Index script that needs to be run for any Backup Server database versions 12.0.11 and prior.

These are the additional indexes that needs to be generated on the backupserver database v12, which will help improve the high SQL server memory usage that are some of our customers are experiencing. Please try to run the query during the Backup Server storage downtime and expect to have these scripts to be included on the next Storage Server build.

1. Open SQL Server Management Studio, click on New Query and select the backup server database name:

2. Copy and paste Create Index script to sql query pane and click execute. Note: There should be a total ofeight (8) Indexes needs to be created.

CREATE INDEX [dbo.IDX_ApfComputerAccount_UserId] on [dbo].[apfcomputeraccount](UserId)

CREATE INDEX[dbo.IDX_ApfStorageEncryption_ComputerAccId] on [dbo].[apfstorageencryption](ComputerAccId)

CREATE INDEX [dbo.IDX_ApfStoredVolume_ComputerAccId] on [dbo].[apfstoredvolume](ComputerAccId)

CREATE INDEX [dbo.IDX_ApfStoredVolume_DataSourceComputerAccId] on [dbo].[apfstoredvolume](DataSourceComputerAccId)

CREATE INDEX [dbo.IDX_ApfStoredVolumeFileHistory_StoredVolumeFileId] on [dbo].[apfstoredvolumefilehistory](StoredVolumeFileId)

CREATE INDEX [dbo.IDX_ApfStoredVolumeFiles_StoredVolumeId] on [dbo].[apfstoredvolumefiles](StoredVolumeId)

CREATE INDEX [dbo.IDX_ApfStoredVolumeFiles_FileName] on [dbo].[ApfStoredVolumeFiles](FileName)

CREATE INDEX [IDX_Users_UserName] ON [dbo].[users](UserName)

3. Here is a quick snapshot of the following Indexes that should be created after you ran the query successfully.

Articles in this section

High CPU usage on SQL server after installation of version 12 of the NovaBACKUP xSP Storage Server