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:
- Review the product requirements.
- Log in to the target computer using an account that has administrator permissions.
- Download SQL Boost.
- Run the SQLBoost.msi file. The system displays the SQL Boost wizard.
- 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
- Once the wizard is complete, you must restart your SQL Server and client applications.
To manually deploy SQL Boost:
- Copy the previously-mentioned files to the target server and clients.
- 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
- on 32-bit:
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