Page History

You do not have to install SQL Traffic Accelerator on all clients, but only clients that have SQL Traffic Accelerator installed experience a performance improvement. Note that clients with SQL Traffic Accelerator can connect to non-SQL Traffic Accelerator servers.

Install SQL Traffic Accelerator on your computer or workstation. The installation steps are The install is the same for both server and client. Simply run .

To install SQL Traffic Accelerator:

1. Review the product requirements.
2. Log in to the target computer using an account that has administrator permissions.
3. Download SQL Traffic Administrator.
4. Run the SQLTrafficAccelerator.msi file

...

1. . The system displays the SQL Traffic Accelerator wizard.
2. Complete the installation wizard. The package installs the following files

...

1. on the system:

...

1. • IderaTrafficManager.exe (on 32-bit) or IderaTrafficManager64.exe (on 64-bit)
   • IderaTrafficWatch.exe (on 32-bit) or IderaTrafficWatch64.exe (on 64-bit)
   • SQLTraffic.sys (on 32-bit) or SQLTraffic64.sys (on 64-bit)
   • SQLTrafficClient.dll (on 32-bit) or SQLTrafficClient64.dll (on 64-bit)
   • SQLTrafficPerformance.h
   • SQLTrafficPerformance.ini
   • SQLTrafficPrfInfo.dll (on 32-bit) or SQLTrafficPrfInfo64.dll (on 64-bit)
   • Idera license agreements
2. Once the wizard is complete, you must restart your SQL Server and client applications.

To manually deploy SQL Traffic Accelerator, these files can be copied :

1. Copy the previously-mentioned files to the target server and clients.
2. Use the following commands to manually register and then start the SQL Traffic Accelerator

...

• nitrowatch -i
• nitrowatch -s

1. Service:

• • on 32-bit: ideratrafficwatch -i
    or on 64-bit: ideratrafficwatch64 -i
  • on 32-bit: ideratrafficwatch -s
    or on 64-bit: ideratrafficwatch64 -s

Silent install

Alternatively, you can use the Microsoft Installer in silent or quiet mode to simplify deployment. For more information about performing a silent installation, run Alternatively, the Microsoft Installer can be used in silent (aka, quiet) mode to simplify deployment. Run msiexec -? to access the microsoft Microsoft installer command line documentation. Note that not all clients must have SQL Traffic Accelerator installed, but only clients that have SQL Traffic Accelerator will see a performance improvement. Also, clients that have SQL Traffic Accelerator installed will still be able to connect to non-SQL Traffic Accelerator servers.

Terminal services install

When installing under terminal services it is important to ensure that you:

• Connect under administration mode
• Connect to the Console (session 0). To do this use the following command line:
  mstsc -v:servername /F –console

Need more help? Search the Idera Customer Support Portal