PI SQL Subsystem configuration

No advance configuration is necessary to start the PI SQL Subsystem (pisqlss). It is started and stopped exactly the same way as other subsystems. On Windows, pisqlss can be run as a service.

Some tuning of pisqlss performance is possible. Settings can be changed using an initialization file, pisqlss command-line parameters, and through settings on a client product, such as the PI ODBC Driver.

Note: The use of an initialization file may change in a later release to an alternate method. At that time, any site-specific settings found in the initialization file are migrated.

See your client product documentation for instructions on changing SQL processing settings from the client application.