Sample Header Ad - 728x90

Does Analysis Services provide connection pooling

0 votes
1 answer
74 views
We know that when creating a SQL connection, for example:
-cs
using (SqlConnection sqlConn = new SqlConnection(conString));
we are actually not always creating a new connection to the server, but rather we are taking an already open connection from the connection pool . --- However, when we open a connection to the Analysis Services, do we also use some kind of connection pooling?
-cs
using (AdomdConnection adomdConn = new AdomdConnection(conString));
Does this always lead to a new connection or does it take one from the pool if possible? I am not able to infer this from the official documentation , but I have found mostly older unofficial articles that clearly state there is no connection pooling for AdomdConnection : - SQL Server 2005 Analysis Services’s ADOMD.NET Connection Pooling, or Lack Thereof - ADOMD.NET Connection Pooling
Asked by PajLe (133 rep)
Apr 25, 2024, 08:36 PM
Last activity: Dec 31, 2024, 04:30 PM