Performance of Silicon Photomultipliers for the Dual-Mirror Medium-Sized Telescopes of the Cherenkov Telescope Array