Dedup SQL?

stanleyj42 · ‎2012-10-26

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

radek_kubka · ‎2012-10-26

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 · ‎2012-10-26

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 · ‎2012-10-26

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