Mostly at listing databases. For instance, clone wizard takes about 3 minutes to list the databases available for cloning from existing backup set, and 3 more after I double-click a backup until I can click next, and there's only a dozen databases on the server. The clone process itself takes about 6 minutes, most of it waiting on "Retrieving ONTAP virtual disks information...". The configuration is as follows:
FAS2040 clustered pair running ONTAP 7.3.6
e0a and e0b in single mode vif used for CIFS and NFS
e0c and e0d configured separately and used for iSCSI with MCS
3 hosts running vSphere 4.1 update 1 (ESXi)
2 Windows Server 2008 R2 SP1 guests running MSCS - each guest has a NIC in LAN network, CIFS network, heartbeat network, iSCSI1 network (accesses e0c on both heads) and iSCSI2 network (same for e0d)
Microsoft iSCSI initiator configured to access LUNs on both filer heads using 2 NICs in MCS
Clustered instance of SQL 2008 10.0.4064
SnapManager for SQL 18.104.22.1686
7 databases have "private" LUNs (data LUN on one filer, log LUN on the other, one DB per LUN pair), others sit in a common userdb data + log LUN pair, system databases on a separate LUN, tempdb on a separate LUN, snapinfo on a separate LUN, all the LUNs are using mount points
DNS resolution is instant and correct, storage system preferred IPs are set in snapdrive, snapdrive actions themselves are reasonably quick (not instant, but no more than 3-5 seconds).
Note that the process doesn't fail, and doesn't even produce any error or warning messages - it just takes an uncomfortably long time to progress and finish.
Can you please upgrade to SnapManager - 5.1P2 and upgrade to version 22.214.171.1249 ? There will be lazyload implementation for enhanced wizard performance in the next release and you will observe database enumeration to happen quickly.
Innovative NetApp® technologies enable organizations to extract greater benefits out of their MicrosoftSQL Server® deployments in the area of backup management of SQL Server deployments. The varioustechnologies empower the database administrator to design a robust backup management strategy toprotect the organization’s SQL Server resources.NetApp provides industry-leading solutions in the areas of complete data protection; thin storageprovisioning; data de-duplication; file-based backups and instantaneous SQL Server database backupsand restores.The intent of this document is to discuss the best practices that empower the user to maximize thebenefits from using SnapManager for SQL Server (SMSQL)..
The lazyload implementation is already in 5.2.Which particular wizard are you facing issue with ? Is it in the backup wizard during database enumeration ?Also tell me the version of SDW that you are using .