topic Re: Best Practice for SQL LUNs in ONTAP Discussions

Best Practice for SQL LUNs

jcampaz516 — Thu, 05 Jun 2025 07:24:22 GMT

Hi guys. Are there any best practice for SQL LUNs (e.g. fractional reserve, snap-reserve, etc.)? Basically, I am going to have 2 LUNs (one for Dbs & the other for Logs) in 1 Volume. I won't keep any snapshots other than rolling snapshots that will be replicated over to DR. Any input would be greatly appreciated.

Re: Best Practice for SQL LUNs

radek_kubka — Thu, 27 Aug 2009 08:14:18 GMT

Hi,

Try reading this doc - not particularly long one!

http://www.netapp.com/us/library/technical-reports/tr-3768.html

Ideally logs and DBs should be kept in separate volumes for backup/recovery granularity.

Fractional reserve is a very tricky topic, but the latest recommendation is to keep it at low level (few percent), so SMSQL can delete snapshots when volume is running out of space (on top of that, volume should be set to auto-grow, but that is fairly universal tip these days).

Regards,
Radek

Re: Best Practice for SQL LUNs

amiller_1 — Sat, 29 Aug 2009 03:34:50 GMT

Excellent link -- definitely worth reading.

Will SnapManager for SQL be involved? If so, the sizing is definitely a bit more complex (well covered in the documentation and worth it for the extra features).