https://login.veeam.com/en/oauth?client_id=nXojRrypJ8&redirect_uri=https%3A%2F%2Fwww.veeam.com%2Fservices%2Fauthentication%2Fredirect_url&response_type=code&scope=profile&state=eyJmaW5hbFJlZGlyZWN0TG9jYXRpb24iOiJodHRwczovL3d3dy52ZWVhbS5jb20va2IxOTk1IiwiaGFzaCI6ImI2OGIzODEzLTE1NzktNGNkMC1iMmU2LTZjYzNhZjFlYzE2YyJ9
1-800-691-1991 | 9am - 8pm ET
EN

Veeam Backup & Replication console slow or unresponsive

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.


Clear old job sessions

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.

 

  1. Stop all Veeam services on the Veeam Backup Server.
  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 execute, it will report “Query executed successfully.” when it completes.
  7. Start all Veeam services.

User-added image

 


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

KB ID:
1995
Product:
Veeam Backup & Replication, Veeam Cloud Connect
Version:
7.x, 8.x, 9.x
Published:
2015-01-29
Last Modified:
2020-09-28
Please rate how helpful this article was to you:
5 out of 5 based on 1 ratings
Thank you for helping us improve!
An error occurred during voting. Please try again later.

Couldn't find what you were looking for?

Below you can submit an idea for a new knowledge base article.
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!

Spelling error in text

Knowledge base content request
By submitting, you agree that your personal data will be managed by Veeam in accordance with the Privacy Policy.
Your report was sent to the responsible team. Our representative will contact you by email you provided.
We're working on it please try again later