I'm working on a SQL server storage solution for a customer where the future storage requirement will be approximately 100TB. This includes space for their SQL Server user database, system databases, temp database and log files and 7 days worth of SnapShots. We are going to propose using SMSQL to back up the SQL server instance. The FlexVol and LUN layout proposal is as follows:
<servername>_usrdb1: 12.68TiB, containing 1 x 11.16TiB LUN, for the .mdf file
<servername>_usrdb2: 38.05TiB, containing 3 x 11.16TiB LUNs, for the .ndf files
<servername>_usrdb3: 38.05TiB, containing 3 x 11.16TiB LUNs, for the .ndf files
<servername>_usrdblog: 7955GB, containing 1 x 7000GB LUN, for the .ldf file(s)
Other smaller FlexVols and LUNs for the tempdb and systemdb files
My question is, does anyone have experience with using SMSQL to SnapShot very large database LUNs and underlying FlexVols? The customer has concerns about SMSQL performance and time to complete the backup when backing up such a large SQL server instance. I'm expecting the performance of SMSQL, in terms of backup completion time to be the same as if I was backing up a much smaller database with the same LUN / FlexVol layout. Is this the case?
NetApp PSC, ASEAN