High Running Query

[eqDoBBs]

Hi

My database monitoring solution has identified that the following query spends a large amount of time in the database with high wait times. I am looking for a way to understand what this query is and why it is being executed so much.

Code: Select all

CREATE PROCEDURE [dbo] 
.[CollectVbrInfraInfo]  
WITH RECOMPILE AS BEGIN  
IF @@TRANCOUNT = 0  
BEGIN 
   ;  
   SET TRANSACTION ISOLATION LEVEL SNAPSHOT ;  
END;  
SELECT *  
FROM [dbo].[VbrInfraItemsInfoView], [dbo] 
   .[VbrJobsInfoView], [dbo] 
   .[VbrBackupsInfoView], [dbo] 
   .[VbrReplicasInfoView], [dbo] 
   .[VbrAppliancesInfoView], [dbo] 
   .[VbrSessionsInfoView], [dbo] 
   .[VbrOptionsInfoView], [dbo] 
   .[VbrOtherInfoView]  
END;  

I am using Veeam 9.5.4.2866

thanks

[alexander sh]

Hi Mark!

This query is executed by Veeam Shell, I believe every 15 seconds by default, to figure out which tabs and buttons should be displayed in the UI. So essentially it checks multiple tables for presence of certain data.

There's a known optimization for this query that we included in V10 that may help you (of course it's hard to be certain without seeing some additional info like detailed time stats and execution plan). If you plan to update soon, please do so and let us know if the problem still persists. If you don't plan to update, I would suggest opening a support case. We'll send you a private fix and investigate further, if needed.

Cheers, Alexander.