You asked
Is the sigma 24mm f 2 dg contemporary good in low light?
Yes, the Sigma 24mm f/2 DG Contemporary is a good choice for low light. f/2 lets in plenty of light, and it's a full frame lens, so it works best on a full frame body. On a full frame camera, a bigger sensor also gives cleaner high-ISO images than APS-C at the same framing and f-number. For the darkest scenes, I'd pair it with the Sony a7S III. For a more all-round body that still handles dim rooms well, the Sony a7 III or the Sony a7 IV are solid choices. If you're curious how sensor size changes the picture, see what a bigger sensor buys you.
Written by Claude from this site's pages.