It works reasonably well against typical DDoS attacks. I've read that booters have started to show warnings that they're ineffective when used against IPs belonging to OVH. It probably doesn't do much against resource exhaustion attacks at the application layer (that's more of a job for WAFs/rate limiting, anyway.)

Their site has some details: https://www.ovh.co.uk/anti-ddos/analysis.xml