Problem, extremely slow getting restore points

[juan.madriaga]

I want to restore a database from the last restorepoint. The job is of type "application aware". The problem is that it takes a long time to bring me the restorepoints. Here are some tests:

Measure-Command { $data1 = Get-VBRApplicationRestorePoint -SQL -Name $vm }
1h 18m
Measure-Command { $data2 = Get-VBRApplicationRestorePoint -Name $vm }
1h 3m
Measure-Command { $data3 = Get-VBRApplicationRestorePoint -SQL }
1h 12m

I have even tried as follows:
Get-VBRApplicationRestorePoint -SQL -Name $vm | Select-Object -First 1

How can I do that faster and more efficiently?

[HannesK]

Hello,
and welcome to the forums.

Could you maybe share more information about our environment? Number of VMs, restorepoints, whether you use SQL express or SQL standard edition? If your backup server is a VM and you use SQL express, does that VM have virtual CPUs or virtual Cores (asking because that has performance impact for SQL express)

There are some older posts on performance of Get-VBRApplicationRestorePoint and this should already be fixed.

Best regards,
Hannes

[juan.madriaga]

Thank you HannesK,
This is my environment data, hope it can help

- Number of VMs with Backup: 950
- restorepoints obtained with "Get-VBRApplicationRestorePoint -SQL": 12010
- We use SQL standard in a SQL Cluster
- VM's SQL: CPU:4, cores per Socket: 1, Memory: 32Gb (the same configuration for the other VM in the cluster)
- VM Veeam: CPU:8, cores per Socket: 1, Memory: 32Gb

Could you do some other test or some other type of verification?
Any ideas how I can do that faster and more efficiently? Do I need to make any changes to my settings?

[HannesK]

Hello,
sounds like the speed you see, is what your infrastructure can provide. I mean, you could add more CPU and / or RAM where you see most load. But in any case, it will take some time.

Best regards,
Hannes