2011-01-17 05:45 PM
We are looking out moving our SQL 2005/Sharepoint environment over to NetApp. We are looking at thin provisiong the LUNs (space reserved None, fractional reserve 0) along with using SMSQL and SMSP to manage the LUNs and snapshots this is all over FC. Does anyone see any downsides to this or experience with running SQL in thin luns wit snapshots? Thanks.
2011-01-17 06:28 PM
Downside is if you ever run out of space when thin provisioning.
Bad things happen if you run out of space !
But yes, you can and ( I say ) you should thin provision.
It'd be a very good thing to have a thorough understanding of thin
provisioning in a NetApp SAN environ before doing so. You may
wish to take a look at:
I hope this response has been helpful to you.
At your service,
(P.S. I appreciate points for helpful or correct answers.)
2011-01-17 06:43 PM
TR3483 is one of my favorite TRs. It explains space reservation better than any other doc and when people have questions on space reserve, snap reserve, thin provisioning, lun space usage, etc., I always ask they read this paper and usually no additional explanation is needed.