1.0.3 MxDB for SQL Server Instance Aliasing

MxDB for SQL Server Instance Aliasing 2

Update the Registry

When you install the Instance Aliasing feature, the following key is

added to the registry:

[Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\POLYSERVE\MatrixServer\SNS]

"Configuration Path"="c:\\Program Files\Polyserve\

MatrixServer\conf\sns.conf"

"Synch Interval"="10"

"Acceptor Thread Count"="2"

"Router Thread Count"="0"

"SQL Browser"="0"

"Session cache growth increment"="500"

"Session cache size"="1000"

"Session cache threshold"="0"

You will need to update the value for “Configuration Path” to specify the

new location of the sns.conf file.

You may also want to modify the other values in the key:

• Synch Interval. The poll interval, in seconds, for checking for

configuration changes.

• Acceptor Thread Count. The number of threads that serve the

incoming connection.

• Router Thread Count. The number of threads that serve the routing

process itself (“0” is the default and means that the number of

allocated threads is equivalent to twice the number of CPUs).

• SQL Browser. This value is used internally.

• Session cache growth increment. When the Instance Aliasing service

runs out of sessions, the service allocates “Session cache growth

increment” more sessions. The default is 500.

• Session cache size. This is the preallocated cache size. A session is an

active connection between the legacy IP and the virtual IP. A session

consumes two buffers (8K each) as well as two sockets. Instead of

allocating memory when needed, the Instance Aliasing service

preallocates the amount of ʺSession cache sizeʺ sessions. The default is