ONTAP Discussions

Dedup SQL?

stanleyj42
2,544 Views

Are there any concerns when it comes to deduping sql data? 

3 REPLIES 3

radek_kubka
2,544 Views

Yes - normally it doesn't give you any savings (or very little).

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.

Regards,

Radek

stanleyj42
2,544 Views

Thanks.  Sorry if this sound like a noob question but compression is something i have to turn on seperate?

I basically use the system manager to configure my volume settings and i dont recall seeing a setting for compression. 

radek_kubka
2,544 Views

Yes, you set it separately & it's available on newer versions of ONTAP only.

I am not sure whether you can enable compression via GUI, or you have to use CLI.

You can find plenty of details in this TR:

http://media.netapp.com/documents/tr-3958.pdf

Public