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.
Google turned up this thread http://communities.netapp.com/thread/15761 which is similar (only worse), but 2 years old and still not answered.
My problem was related to having the data and management ports on the same network. After they were separated, the slowness was gone (and it was a general behavior, not only for a specific database).
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)..
*Good FRIENDS are hard to find, harder to leave, and impossible to forget*
Have you tried disabling antivirus and firewall software on the windows SQL server host, to see if it makes a difference?
I believe snapmanager communicates with the filer using http over port 80. We saw cases where our AV software was interfering and we had to add an exclusion for the netapp software processes.
Hi Boris ,
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.
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 .