SQL Server Proxies

Senior Member

Hello, does anyone know of any proxies for SQL Server that manages front side connections? Features would include connection pooling, query caching or read/write splitting?

1 Reply

Hello @Roland Lee ,

 

For me it's not very clear, what you are looking for. What exactly do you mean with "proxy" and "splitting"?

 

Connection pooling is a mechanism on client side, that can't be controlled from SQL Server, see

https://docs.microsoft.com/en-us/sql/connect/ado-net/sql-server-connection-pooling?view=sql-server-v...

 

SQL Server do have a caching, but it's called "Buffer pool", see

https://docs.microsoft.com/en-us/sql/relational-databases/memory-management-architecture-guide?view=...

 

Olaf