SQL Explorer Speed?

[CurtLeCaptain]

I'm curious, when I'm doing a "Fine-tune the restore point" restore in SQL Explorer - it takes a good 10 minutes to populate the screen. Right now I'm doing more testing than anything else, and the test DB only has 8 rows within the table. Very simple, very small. Thoughts as to why this takes so darn long?

[Vitaliy S.]

Where is backup repository located at? At the same site as Veeam backup server?

[CurtLeCaptain]

Yes. B&R server is a standalone box for control purposes, with four virtual proxies/repositories. All located within the same datacenter.

[Vitaliy S.]

Does this happen for all databases? BTW, is it a dedupe storage by any chance?

[tsightler]

10 minutes certainly seems crazy long for the scenario you are describing. For comparison, I have a much larger database (tens of thousands of rows, maybe hundreds of thousands) with lots of updates daily, and it take about 45-60 seconds to mount and bring up the fine-tune transaction list. I'm also curious if the source happens to be a dedupe storage system.

[CurtLeCaptain]

First: No, it's standard storage on a Windows box, connected to a V7000 SAN. It happens for all DBs on that server (of which there was only one, and it has only 8 rows.) We have no dedupe at all involved.

[Vitaliy S.]

Hmm... can you open a case and let our team take a look a the debug logs?

[CurtLeCaptain]

Of course. I will do that and go from there!

[veremin]

Once the case is opened, please, post its number here for the convenience of future readers. Thanks.