Hi all,
It appears SM SQL 5 reduces the maximum number of databases from 100 (SM SQL 2) to 35 due to a 'Microsoft Limitation' on a storage volume.
https://now.netapp.com/Knowledgebase/solutionarea.asp?id=kb53310
This article references
http://support.microsoft.com/kb/943471/en-us
If the NetApp Snapshot occurs at the Volume level nearly instantly via SnapDrive api call, what part of SM SQL uses VDI/VSS ? I understand that SM SQL has to queisce the DB momentarily for a consistent snapshot - is this when VDI/VSS is called ?
It would appear that upgrading our SD/SM SQL version has resulted in a chunk of extra work in splitting out databases out onto more volumes/luns to accommodate this limitation. Its tempting to go back to the previous version.
Most of the DB's are small MS CRM / SharePoint ones with minimal loading (ie the SQL box isn't being hammered and the DB's themselves aren't big).
Before we go down this track of adding more drives and splitting out the databases (our DBA's are less than pleased at the prospect) have other people struck SM SQL 5 backup issues since upgrading due to the number of databases on a lun ?
Thanks in advance, Raj.