MxDB for SQL Server Instance Aliasing Matrix DataBase Solution Pack for SQL Server™ 3.4.
Copyright © 2004-2006 PolyServe, Inc. Use, reproduction and distribution of this document and the software it describes are subject to the terms of the software license agreement distributed with the product (“License Agreement”). Any use, reproduction, or distribution of this document or the described software not explicitly permitted pursuant to the License Agreement is strictly prohibited unless prior written permission from PolyServe has been received.
Contents MxDB for SQL Server Instance Aliasing Installation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Copy the sns.template.conf File . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Update the Registry . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Note for Sites with 1000+ Connections . . . . . . . . . . . . . . . . . . . . . . . . . Restart the Instance Aliasing Service . . . . . . . . . . . . . .
MxDB for SQL Server Instance Aliasing The Instance Aliasing feature can be used to map your existing legacy SQL connections to the Virtual SQL Instance connection used with MxDB for SQL Server. SQL clients can then continue to use the legacy connection string to access the SQL database in its new location. Installation To install the Instance Aliasing feature, double-click on the InstanceAliasing_1.0.0_.msi file.
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.
MxDB for SQL Server Instance Aliasing 3 1000 sessions. This means that even if there are no sessions in the system, the service will take 1000*16K, or 16Mb. Under stress, the system will grow the Session cache size by the Session cache growth increment. When a session is freed (for example, the user disconnected) and there are enough sessions in the main cache, the session will be placed on the garbage cache, which will be collected in the next synch cycle. • Session cache threshold.
MxDB for SQL Server Instance Aliasing 4 Administrative Tools > Services.) On the snap-in, start the SNS PolyServe service. Map Legacy IPs to Virtual IPs The sns.conf file maps the legacy IP addresses to the new virtual IP addresses. You will need to add entries for your legacy IP addresses to the file. The entries must have this format: ;;; is the IP address assigned to the Virtual SQL Server.
