You asked

Is the canon ef 500mm f 4l is ii usm good for sports?

Here is what the site says about that.

From Canon EF 500mm f/4L IS II USM: Canon EF 500mm f/4L IS II USM: A prime lens by Canon for Full frame cameras, 500mm f/4. Specs - Maker: Canon - Focal length: 500mm (prime) - Maximum aperture: f/4 - Made for: Full frame sensors - Mounts: Canon EF - Stabilised: yes - Autofocus: yes What it frames like - On full frame (Canon EF): as marked, 500mm. - On APS-C (Canon) (Canon EF): like 800mm on full frame; f/4 gives about the depth of ...

From Wildlife and sport: Wildlife and sport: Wildlife and sport are the hardest things to photograph, and the most gear-dependent. The subject is far away, it moves fast, and it won't do it again.

Quoted from this site's pages.

From these pages