如何有效的版本存储过程?

i am part of database development team wotking for big eshop. We are using MS SQL 2016 and ASP.NET. SQL Server is used by clients from 10+ IIS servers using connection pooling (we have aprox 7-10k batch/sec) in production environment and we are using 18 DEV/TESTING IIS servers (but only one DEV database because multi TB size). We develop a new functionality that forces us to make changes to existing stored procedures quite often. i am part of database development team wotking