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

NovaBACKUP xSP / Remote Workforce
Last Updated: Oct 31, 2012 10:33PM PDT

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:

new query


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

 

?
CREATE INDEX [dbo.IDX_ApfComputerAccount_UserId] <SPAN class=highlight>on</SPAN> [dbo].[apfcomputeraccount](UserId)
CREATE INDEX [dbo.IDX_Apf<SPAN class=highlight>Storage</SPAN>Encrypti<SPAN class=highlight>on</SPAN>_ComputerAccId] <SPAN class=highlight>on</SPAN> [dbo].[apf<SPAN class=highlight>storage</SPAN>encrypti<SPAN class=highlight>on</SPAN>](ComputerAccId)
CREATE INDEX [dbo.IDX_ApfStoredVolume_ComputerAccId] <SPAN class=highlight>on</SPAN> [dbo].[apfstoredvolume](ComputerAccId)
CREATE INDEX [dbo.IDX_ApfStoredVolume_DataSourceComputerAccId] <SPAN class=highlight>on</SPAN> [dbo].[apfstoredvolume](DataSourceComputerAccId)
CREATE INDEX [dbo.IDX_ApfStoredVolumeFileHistory_StoredVolumeFileId] <SPAN class=highlight>on</SPAN> [dbo].[apfstoredvolumefilehistory](StoredVolumeFileId)
CREATE INDEX [dbo.IDX_ApfStoredVolumeFiles_StoredVolumeId] <SPAN class=highlight>on</SPAN> [dbo].[apfstoredvolumefiles](StoredVolumeId)
CREATE INDEX [dbo.IDX_ApfStoredVolumeFiles_FileName] <SPAN class=highlight>on</SPAN> [dbo].[ApfStoredVolumeFiles](FileName)
CREATE INDEX [IDX_Users_UserName] <SPAN class=highlight>ON</SPAN> [dbo].[users](UserName)


 

copy-paste-execute

 


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

indexes 

NovaCare Status

NovaStor Support

Contact Us

  • E-Mail NovaStor Support

    Click Here to submit your case to the NovaStor Support Team.

  • Phone Support

    If you have NovaCare Support you can call our support line:

    US Support:
    Call +1(805) 409-3140
    Press 2 for Technical Support
    Monday through Friday
    8am - 5pm PST

    EMEA Support:
    Call +49 (40) 63809 - 989
    Monday through Friday
    9am - 5pm CET (GMT+1)

TeamViewer