Server options
- Last UpdatedFeb 07, 2023
- 1 minute read
- PI System
- PI OLEDB Enterprise 2019
- Developer
Use the server options to determine how the linked server handles connections, passes queries and triggers timeouts. OSIsoft recommends that you use these options:
|
Parameter |
Description |
|---|---|
|
Collation Compatible |
It is strongly recommended that this parameter be set. When set, Microsoft SQL Server assumes that all characters in the Linked Server are compatible with the local SQL Server, and is allowed to send comparisons on text columns to the OLEDB Provider directly. If the option is not set, SQL Server will evaluate text comparisons itself, which has a significant performance impact. |
|
Connection Timeout and Query Timeout |
Use these settings optionally. The connection timeout option represents the connection timeout, while the query timeout represents the execution timeout. Both options are in seconds. |