Adding Indexes on VeeamBackup Database Tables

[FilipHolub]

I was wondering if I am allowed to add a new index that can help performance and reduce the CXPACKET wait type in my case.

I would like to create this index:

CREATE NONCLUSTERED INDEX [NC_BackupModelSqlOIBs] ON [VeeamBackupDB].[dbo].[Backup.Model.SqlOIBs]
(
[group_db_id]
)
INCLUDE ([obj_id])
WITH(ONLINE = ON,SORT_IN_TEMPDB = ON)
GO

or modify the existing index below, so I can add column [obj_id] to the INCLUDE part of the index.

USE [VeeamBackupDB]
GO

/****** Object: Index [IX_SqlOIBs_guest_db_id] Script Date: 8/9/2024 5:07:59 PM ******/
CREATE NONCLUSTERED INDEX [IX_SqlOIBs_guest_db_id] ON [dbo].[Backup.Model.SqlOIBs]
(
[guest_db_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 80, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
GO

It's SQL Server 2019 - Version - 15.0.4365.2

Thanks a lot.

Cheers.
Filip Holub

[david.domask]

Hi Filip, welcome to the forums.

May I ask, why do you want to add these additional indices? Are you seeing difficulties with the Veeam Configuration Database or behaviors with the product you think are related to database performance?

Manual edits of the Veeam Configuration Database are unsupported, and must only be done under the guidance of Veeam Support. If you suspect you're having issues related to the Configuration Database, please open a Support Case as noted when creating a topic and describe the situation to Support. Allow them time to review the information and advise on the behavior.

Thanks!