The Sig Sauer P226 is used by dozens of agencies and militaries throughout the world, particularly the Navy SEALs. Originally, the P226 was picked after being chosen as a runner up when the first choice, the Beretta 92, malfunctioned during testing and a service member was hit in the face by a failed slide. Despite not having a good experience with the 9mm ball ammunition, the Navy bought more P226 in the late 1990s but designated them the Mk 24. When the SEALs again requested a new .45 handgun the HK45C was brought in, but most service members carried the P226 when a .45 wasn’t required. In 2015, the P226 was completely replaced with the Glock 19 due to the affordability and practicality.
Source: https://nationalinterest.org/blog/buzz/navy-seals-chose-amazing-sig-sauer-p226-94631