Microsoft SQL Server Connection Details
Provide the information of the Microsoft SQL Server that this connection connects to.
Note:
- Maximum Open Connections must be less than the limit on the number of connections imposed by your database and infrastructure.
- Higher Maximum Open Connections and Maximum Idle Connections values can lead to better performance. However, having a large idle connection pool (with connections that are not reused) can lead to reduced performance.
- To mitigate the risk mentioned in the preceding point, set a relatively short Maximum Connection Lifetime. However, it must not be so short that leads to connections being ended and re-created unnecessarily often.
Copyright © 2021. TIBCO Software Inc. All Rights Reserved.