Click on "Settings and Control" to start, stop, or configure SQL Traffic Accelerator . From the Control page, you can select which SQL instances to enable SQL Traffic Accelerator on by clicking the "Configure Instances" button. By default, SQL Traffic Accelerator will be enabled on all instances.
The "Encrypt protocol" option uses a high-speed 128-bit encryption algorithm to encrypt the data returned from the server. This option only needs to be turned on for the server-side installation.
The "Demo mode only" option can be used before installing SQL Traffic Accelerator on a client to see the compression rate that could be achieved through SQL Traffic Accelerator. Note that SQL Traffic Accelerator will not actually be used when this option is selected; it will simply display the statistics.is designed to work seamlessly in the client-server model. Any application that is using MDAC or the SQL Native Client to connect to a SQL Server, such as SharePoint or SQL Management Studio, can use SQL Traffic Accelerator to compress and optimize the traffic. SQL Traffic Accelerator also supports server-to-server connections, such as Linked Servers, SSIS, Replication, or Analysis Services.
All clients and servers are not required to have SQL Traffic Accelerator installed, but only connections that have SQL Traffic Accelerator on both ends will see a performance improvement.
After initially installing SQL Traffic Accelerator, there are a few tasks you might want to do to further customize and streamline your deployment including:
- Access the SQL Traffic Accelerator Control Console
- Manage license
- Start or stop SQL Traffic Accelerator
- Encrypt returned SQL Server instance data