connection pooling and SQL Server analysis Services

Available for: Microsoft SQL Server? Analysis Services

Summary: Learn how to develop a scalable client and WEB application that works with Microsoft SQL Server Analysis Services by using the connection pool objects that are included with Microsoft XML for analysis Provider 。

Brief introduction

Resource management is an important issue to consider when developing scalable clients and web-based applications. When constructing client applications that can serve many concurrent users, the guideline for resource management is to allocate resources as late as possible and to deallocate resources as early as possible. The availability of resources, such as memory, process threads, and network or database connections, is directly related to the performance of the client application and to the satisfaction of the user. As a result, resource management has become increasingly important as client applications continue to expand.

With further control over resource management, connection pooling can reduce the impact of scalability. Connection pooling enables client applications to establish a connection between a connection pool and a given resource without having to re-establish the connection every time it is used. After a connection is established in the connection pool, the client application can reuse the connection without having to perform a complete connection process.

Because client applications do not need to repeatedly establish and close connections, using pool-buffered connections can significantly improve connectivity performance. The time required for this process is especially important for client applications that use a resource that is a long time lag, such as the Internet or a network connection. When a client application no longer requires a connection, the connection is returned to the connection pool.

In addition to improving performance, using connection pooling can also manage resources more efficiently without adding additional resource management costs to client applications. Connection pooling Manager can allocate and deallocate connections as needed to maintain connection pooling, and connections in the connection pool can be reused by multiple applications.

To support the scalability needs of WEB client applications using Microsoft SQL Server Analysis Services, the connection pooling feature has been implemented in Microsoft XML for Analysis Provider. XML for Analysis Provider automatically uses connection pooling, and it can also be used with other client applications that do not need to use XML connections provided by the provider itself. This article is intended to introduce objects that allow you to take full advantage of connection pooling in an analysis Services client application.