Dedup SQL?

[stanleyj42]

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

[radek_kubka]

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]

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]

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