Hello Daniel,
I am with the Product team at Prisma. I don’t know of any solution like to pgBouncer for SQL Server.
Are you currently using Prisma with SQL Server? I’d love to learn more about your use case. If you are willing to, I’d love to have a short call and hear about it.
Here is a link you can use to book some time with me:
https://calendly.com/alberto-prisma/45-min-zoom-call