Collect SQL logs on your DM server for one business day.
So, what is the optimal value for SQL Connection Cache Size? It should be tested for your current environment. To achieve the optimum value for the SQL connection cache, you have to strike a balance between minimizing the resources used by idle SQL connections and maximizing the frequency with which users are able to use an open connection." However, these additional connections are dropped when processing completes, and the number of connections return to the value specified in the SQL-Connection Cache Size parameter. If the number of SQL connections required increases above the specified value (to a maximum of 50), then the DM server instantiates more connection objects. This value does not represent the actual number of SQL connections. "The SQL-Connection Cache Size parameter specifies the minimum number of connection objects within the DM server. Here is a passage from eDOCS DM 5.3.1 Administration Guide (and unlike my opinion about other sources of information given above, I tend to trust this one): Connections from the pool are shared among concurrent users of DM Server. Once a query is processed, the connection is returned back to the pool. That's why pools of connections are used: once established, a connection is kept in the pool and acquired when it's needed to query the database. It's not a secret that establishing the connection with a database (or any connection in general) is a time expensive operation. In the nutshell, SQL Connection Cache Size is the size of the database connection pool. My other source of information was a local consultant firm, which specializes on Hummingbird / OpenText solutions - they also recommended increasing the value to 50-100 at least.Īfter a few months of supporting OpenText DM one of the lessons I've learned is: Don't take as granted what 'experienced' guys say check it out. I don't remember where I found this document, but I believe it's from OpenText eDOCS DM Champion Toolkit. One of the sources is "OpenText eDOCS DM Implementation Best Practice Recommendations.pdf". However, I found quite a bit of speculation about increasing it to 150 and higher values. The default value of this parameter is 5. You can set it in DM Server Manager on Libraries / Library Properties page. The SQL Connection Cache Size value is one of the DM Server configuration values.