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

Install SQL Boost on your computer or workstation. The installation steps are the same for both server and client.

To install SQL Boost:

  1. Review the product requirements.
  2. Log in to the target computer using an account that has administrator permissions.
  3. Download SQL Boost.
  4. Run the SQLBoost.msi file. The system displays the SQL Boost wizard.
  5. Complete the installation wizard. The package installs the following files on the system:
    • IderaBoost.exe (on 32-bit) or IderaBoost64.exe (on 64-bit)
    • SQLBoost.sys (on 32-bit) or SQLBoost64.sys (on 64-bit)
    • SQLBoostClient.dll (on 32-bit) or SQLBoostClient64.dll (on 64-bit)
    • SQLBoostPerformance.h
    • SQLBoostPerformance.ini
    • SQLBoostPrfInfo.dll (on 32-bit) or SQLBoostPrfInfo64.dll (on 64-bit)
    • Idera license agreements
  6. Once the wizard is complete, you must restart your SQL Server and client applications.

 

To manually deploy SQL Boost:

  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 Boost Service:
    • on 32-bit: ideraboostwatch -i
      or on 64-bit: ideraboostwatch64 -i
    • on 32-bit: ideraboostwatch -s
      or on 64-bit: ideraboostwatch64 -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 msiexec -? to access the Microsoft installer command line documentation.

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

  • No labels