Forum Discussion
SQL Server Proxies
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?
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
SQL Server do have a caching, but it's called "Buffer pool", see
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.
