Try OpenEdge Now
skip to main content
DataServer for Microsoft SQL Server
Troubleshooting : Tuning your environment with the -Dsrv startup parameter
 

Tuning your environment with the -Dsrv startup parameter

The DataServer (-Dsrv) startup parameter allows you to use special DataServer options to tune your environment. You pass these options as arguments to -Dsrv when connecting to a MS SQL Server database.
There are two versions of the syntax, as follows:

Syntax

CONNECT data-source-name -ld logical-name -dt MSS
-Dsrv arg1,val1 -Dsrv arg2,val2 -Dsrv arg3,val3...
CONNECT data-source-name -ld logical-name -dt MSS
-Dsrv arg1,val1,arg2,val2,arg3,val3...
In this syntax:
*The schema holder is already connected.
*The data-source-name argument is the name of the data source and the logical-name argument is its logical name, which is defined when you create your schema image.
*You pass the options as the argn,valn pairs.
Here is an example of how to use the CONNECT statement with the -Dsrv parameter:
CONNECT mssql_db -ld mydb -U x -P y
-Dsrv qt_debug,EXTENDED
-Dsrv PRGRS_IDBUF,100
-Dsrv PRGRS_MINBUF,10000
-Dsrv MAX_R,10000.
Note that MAX_R is an abbreviation of MAX_ROWS. You can abbreviate option names as long as they identify parameters uniquely.
Both the syntax statements and the example show the use of the -Dsrv startup parameter in CONNECT statements. You can also specify -Dsrv options in a parameter file, on a program item command line, or in the Connection Parameters field in the Database Connect dialog box.