SQL Server Proxies

Brass Contributor

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?

2 Replies

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

 

A database proxy is used manage front end connections before hitting SQL Server. This may include query caching, connection pooling. Proxies in the market include ScaleArc and ProxySQL. FYI, caching on the SQL Server improves database scalability, but it does not reduce round trip latency.