Veeam Backup & Replication console slow or unresponsive

KB ID: 1995
Products: Veeam Backup & Replication;Veeam Backup & Replication Cloud Edition
Version: 7.x, 8.x
Published:
Last Modified: 2016-10-02

Challenge

The Veeam Backup & Replication console is slow to respond when switching between different views. The issue is more noticeable when attempting to search through the history of jobs.

Cause

In rare cases the VeeamBackup SQL DB can have many thousands of previous task sessions which causes queries run by the console to be delayed.

Solution

There are two parts to resolving this, one resolves the issue in the short term by removing old sessions from the SQL DB, the other is to limit how many sessions are stored in the SQL DB.
 
──────────────────────────────────────────────────────────
Clearing old sessions from the SQL DB
──────────────────────────────────────────────────────────
Note: SQL Management Studio is required to perform this task. All jobs must be stopped. 
Note: This stored procedure removes sessions from the database, if the database contains many session entries this may take a very time (hours). Please plan accordingly.

  1. Stop all Veeam services.
  2. Connect to the SQL instance hosting the VeeamBackup database.
  3. Create a backup of the VeeamBackup database. (http://www.veeam.com/kb1471)
  4. Expand the DB to Programmability > Stored Procedures > dbo.DropStoppedOldJobSessions
  5. Right click > Execute... > in the window that appears enter how many days you want to keep
  6. Press OK to executeit will report “Query executed successfully.” when it completes.
  7. Start all Veeam services.
User-added image

──────────────────────────────────────────────────────────
Changing Session history retention
──────────────────────────────────────────────────────────
You can specify session history settings for jobs performed on the Veeam backup server. 
  1. Select Options from the main menu.
  2. Click the History tab.
  3. In the Sessions section, specify the number of sessions to display in the Sessions list of the History view.
In the Session history retention section, specify the number of sessions to keep in the Veeam Backup & Replication database.

User-added image

 

5 / 5 (16 votes cast)

Report a typo on this page:

Please select a spelling error or a typo on this page with your mouse and press CTRL + Enter to report this mistake to us. Thank you!

Orphus system