I don't know if NetApp SnapManager is a niche product. But the Restore Wizard is very slow, and I was wondering if anyone else had encountered this problem. I kill the SPID after 15 minutes of waiting. For DR, we have would to completely avoid the restore wizard, and instead do a clone copy to development, and copy data from there.
The waiting happens on the screen that says "Double-click to select a backup under the database you want to restore." After double-clicking, that's when the waiting starts. Looking at the database activity, SnapManager is gathering the database names from each backup in the snapshot. ( RESTORE FILELISTONLY )
The problem is that there are 38 databases listed under the snapshot, with 40 items each, which means it is trying to restore file lists 1,500 times.
The only reason I would use this feature is in an emergency situation, but it's so slow that it won't cut it.
Example: Under backup "sqlsnap__SQL_09-15-2013_23.36.08__Daily", it looks like this on the right pane:
Database - 1 Admin
...and so on... on to the next database
Database - 38 WHD
For a total of over 1,500 items.
Did we configure something incorrectly?