FWIW, I retired as Federal Agent after 30 years. During my 30 years, I carried the same Sig P226. If I was going out on enforcement actions, I always had two weapons my P226 and either a shotgun/AR-15 (high threat) or my S&W 649 (low threat).
In retirement, I do not carry in low threat...