Veeam Backup & Replication console slow or unresponsive

KB ID: 1995
Product: Veeam Backup & Replication | 7.0 | 8.0 | 9.0 | 9.5
Veeam Cloud Connect | 8.0 | 9.0 | 9.5
Published: 2015-01-29
Last Modified: 2021-12-09
Get weekly article updates
By subscribing, you are agreeing to have your personal information managed in accordance with the terms of Veeam's Privacy Notice.

Cheers for trusting us with the spot in your mailbox!

Now you’re less likely to miss what’s been brewing in our knowledge base with this weekly digest

error icon

Oops! Something went wrong.

Please try again later.

Article Applicability
This article documents an issue relevant only to Veeam Backup & Replication versions before v10. Starting with Veeam Backup & Replication v10, improvements were made to how the GUI retrieves information from the configuration database. 

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

Note: If you are using Veeam Backup & Replication 9.5 U3 (9.5.0.1536), and are observing slow GUI performance within the console, this may be related to a known issue found only in 9.5.0.1536. This was corrected in the next update, please ensure you have the latest update installed, https://www.veeam.com/updates.html.

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.

Under most circumstances having the default session retention is acceptable. The need to enforce retention of sessions often occurs when one or more jobs repeatedly fail, causing the creation of excessive failed job records in the database.

Clear old job sessions from Database

Notes:

  • SQL Management Studio is required to perform this task. 
  • All jobs must be stopped.
  • This stored procedure removes sessions from the database, if the database contains many session entries this may take a very long time (hours). Please plan accordingly. You can check progress by observing the size reduction of the dbo.Backup.Model.JobSessions table using the "Disk Usage by Top Tables" report (Right-click Database>Reports>Standard Reports>Disk Usage by Top Tables).
  1. Stop all Veeam services on the Veeam Backup Server.
Get-Service Veeam* | Stop-Service
  1. Connect to the SQL instance hosting the VeeamBackup database.
  2. Create a backup of the VeeamBackup database. (http://www.veeam.com/kb1471)
  3. Expand the DB to Programmability > Stored Procedures > dbo.DropStoppedOldJobSessions
  4. Right click > Execute... > in the window that appears enter how many days you want to keep
  5. Press OK to execute, it will report “Query executed successfully.” when it completes.
  6. Start all Veeam services.
Get-Service Veeam* | Start-Service
Stored Procedure examples shown in SQL Management Studio

Changing Session history retention

The sessions to be stored in the configuration database are controlled by retention defined in number of weeks. If you have many jobs running often the default setting may cause the database to retain many entries. You can specify session history settings within the Veeam Backup & Replication console.

  1. From the main menu, select General Options.
  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.
  4. In the Session history retention section, specify the number of weeks for which Veeam Backup & Replication must keep session information in the configuration database.

User-added image

Click here to send feedback regarding this KB, or suggest content for a new KB.
To report a typo on this page, highlight the typo with your mouse and press CTRL + Enter.

Spelling error in text

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
Thank you!

Thank you!

Your feedback has been received and will be reviewed.

Oops! Something went wrong.

Please try again later.

KB Feedback/Suggestion

This form is only for KB Feedback/Suggestions, if you need help with the software open a support case

By submitting, you are agreeing to have your personal information managed in accordance with the terms of Veeam's Privacy Notice.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
Verify your email to continue your product download
We've sent a verification code to:
  • Incorrect verification code. Please try again.
An email with a verification code was just sent to
Didn't receive the code? Click to resend in sec
Didn't receive the code? Click to resend
Thank you!

Thank you!

Your feedback has been received and will be reviewed.

error icon

Oops! Something went wrong.

Please try again later.