Progress
DataServer for
Microsoft SQL Server
Guide


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 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... 

SYNTAX
CONNECT data-source-name -ld logical-name -dt MSS
-Dsrv arg1,val1,arg2,val2,arg3,val3... 

In this syntax:

Here is an example of how to use the CONNECT statement with the –Dsrv parameter:

CONNECT mssql_db -ld mydb -Ux -Py
   -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.


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095