topic Re: Dedup SQL? in ONTAP Discussions https://community.netapp.com/t5/ONTAP-Discussions/Dedup-SQL/m-p/19599#M4607 <HTML><HEAD></HEAD><BODY><P>Yes, you set it separately &amp; it's available on newer versions of ONTAP only.</P><P></P><P>I am not sure whether you can enable compression via GUI, or you have to use CLI.</P><P></P><P>You can find plenty of details in this TR:</P><P><A href="http://media.netapp.com/documents/tr-3958.pdf" title="http://media.netapp.com/documents/tr-3958.pdf" target="_blank">http://media.netapp.com/documents/tr-3958.pdf</A></P></BODY></HTML> Fri, 26 Oct 2012 16:48:02 GMT radek_kubka 2012-10-26T16:48:02Z Dedup SQL? https://community.netapp.com/t5/ONTAP-Discussions/Dedup-SQL/m-p/19583#M4604 <HTML><HEAD></HEAD><BODY><P>Are there any concerns when it comes to deduping sql data?&nbsp; </P></BODY></HTML> Thu, 05 Jun 2025 06:16:32 GMT https://community.netapp.com/t5/ONTAP-Discussions/Dedup-SQL/m-p/19583#M4604 stanleyj42 2025-06-05T06:16:32Z Re: Dedup SQL? https://community.netapp.com/t5/ONTAP-Discussions/Dedup-SQL/m-p/19590#M4605 <HTML><HEAD></HEAD><BODY><P>Yes - normally it doesn't give you any savings (or very little).</P><P></P><P>You may be better off with compression, but be careful as this is in-line, so CPU overhead is every time you write any data, not just during scheduled periods as for dedupe.</P><P></P><P>Regards,</P><P>Radek</P></BODY></HTML> Fri, 26 Oct 2012 16:21:20 GMT https://community.netapp.com/t5/ONTAP-Discussions/Dedup-SQL/m-p/19590#M4605 radek_kubka 2012-10-26T16:21:20Z Re: Dedup SQL? https://community.netapp.com/t5/ONTAP-Discussions/Dedup-SQL/m-p/19595#M4606 <HTML><HEAD></HEAD><BODY><P>Thanks.&nbsp; Sorry if this sound like a noob question but compression is something i have to turn on seperate?</P><P>I basically use the system manager to configure my volume settings and i dont recall seeing a setting for compression.&nbsp; </P></BODY></HTML> Fri, 26 Oct 2012 16:40:58 GMT https://community.netapp.com/t5/ONTAP-Discussions/Dedup-SQL/m-p/19595#M4606 stanleyj42 2012-10-26T16:40:58Z Re: Dedup SQL? https://community.netapp.com/t5/ONTAP-Discussions/Dedup-SQL/m-p/19599#M4607 <HTML><HEAD></HEAD><BODY><P>Yes, you set it separately &amp; it's available on newer versions of ONTAP only.</P><P></P><P>I am not sure whether you can enable compression via GUI, or you have to use CLI.</P><P></P><P>You can find plenty of details in this TR:</P><P><A href="http://media.netapp.com/documents/tr-3958.pdf" title="http://media.netapp.com/documents/tr-3958.pdf" target="_blank">http://media.netapp.com/documents/tr-3958.pdf</A></P></BODY></HTML> Fri, 26 Oct 2012 16:48:02 GMT https://community.netapp.com/t5/ONTAP-Discussions/Dedup-SQL/m-p/19599#M4607 radek_kubka 2012-10-26T16:48:02Z