If you would like to discuss the setup process or if the results within your NitroAccelerator console show less than 90% compression, please reach out to us for a quick tuning call.
SQL Servers Versions 2008 and Later
Clients/ Workstations Windows Versions 6.0 and Later
LINUX It is possible to reduce latency by using a Linux system as an endpoint with Nitro installed to a Windows system as a proxy. Reach out to us for details.
All clients and servers are not required to have NitroAccelerator installed. Only connections that have NitroAccelerator on both ends will see a performance improvement. Your 14 day free trial countdown will not begin until installation.
Run the NitroAccelerator install file on the SQL Servers, Application Servers, and Clients of your choosing.
You can also install directly from the command line:
msiexec /i NitroTurbo.msi /qn
Your inbound and outbound connections will display within the NitroAccelerator Console: Tools > Connections
To accelerate SQL Server Replication, restart your SQL agent.
To accelerate SQL Server Replication, restart your SQL agent.
To accelerate Client/Server applications, relaunch your applications.
Clients experience up to 20x speed improvements in SMB File Transfers and improved SMB Application Performance.
This feature is on by default and can be disabled within compression settings: Tools > Compression Settings > Named Pipe Acceleration
To accelerate SMB traffic, existing client connections need to be recreated. A server reboot is the easiest way to reestablish all accelerated client connections.
Applications that use .NET Remoting may benefit greatly from NitroAccelerator but requires identifying the ports used for your specific implementation.
Additional ports must be added to both the server and client console to accelerate: Tools > Configure Additional Protocols
If the protocol that you are trying to accelerate is not mentioned above, but is running on Windows (Oracle, DB2, or other databases), the configure additional protocol dialogue is available.
Ports must be added to both the server and client console: Tools > Configure Additional Protocols
For additional information, contact support.
The NitroAccelerator Console shows compression statistics for Nitro-enabled connections.
The two graphs show the outbound and inbound traffic where the blue lines are the actual compressed traffic and the red lines are what the traffic would be if it were uncompressed.
While you may experience immediate improvements in throughput and reductions in connection latency, we recommend tuning the software to fit your specific environment and requirements.
Compression levels allow for modifying compression algorithms and can be configured to tune performance for your environment, existing latency, and data types.
If you are seeing compression above 80% and you are still not seeing an improvement in throughput, see the following section on enabling ZLDC.
If you are seeing compression levels below 90%, we recommend experimenting on the server with different compression settings: Tools > Compression Settings.
This algorithm is more memory intensive than the others and should only be selected when compression ratio is the primary concern, such as in very low or costly bandwidth situations
This new technology removes all latency from the TCP protocol while doubling throughput.
Activate ZLDC Acceleration: Tools > Zero Latency Data Channel
Set an open UDP port. (Default: 6161)
All firewalls between the client and SQL Server need to be open for UDP traffic on the configured ZLDC port for both inbound and outbound traffic.
Enable ZLDC on all nodes.
If you are hitting the cache size on the High Water Mark, contact support to discuss configuring the Packet Cache Size.
Depending on the number of connections and the compressibility of the data, you may need to make tuning adjustments within Tools > ZLDC.
The VPN server must be configured to allow both sides of the VPN to initiate communication.
If the VPN client is a router (i.e., the clients don't connect to the VPN because the router has the connection to the VPN server), there needs to be a route between the 2 subnets.
The HyperCache is a client-side caching technology that can further improve performance in certain environments. It works by monitoring each query to determine how stable the results are. When a given query is determined to have stable results, the client will be given results from the cache instead of waiting for the server’s response. The query is still sent on to the server so the cache can be refreshed, and if the results of a query ever change, the query entry is invalidated until the result set is again shown to be stable. Only result sets of 64k or less will be cached, so HyperCache will have the biggest impact in environments with smaller repetitive queries. The Cache Size setting in the console determines the total number of queries that can be cached, so this can be adjusted as needed for your environment.
For small repetitive queries and chatty Applications, we recommend activating this feature on your clients: Tools > HyperCache Settings
Some applications require that certain queries be executed regardless of the result set and should not be cached. Contact support if you do not experience improvements in application load times and user experience.
NitroAccelerator’s optional one-click Encryption secures network traffic between endpoints: Tools > Encryption Settings
You have the option to select from our default encryption key or to set your own.
Named Pipe acceleration might be required to accelerate all SQL Server traffic and is required to accelerate SMB traffic.
The Named Pipe Acceleration feature is enabled by default and can be disabled within the compression settings: Tools > Compression Settings
Multiple Active Result Sets (MARS) is a protocol used by SQL Server to reduce the number of connections required, but can cause performance bottlenecks.
MARS Acceleration is disabled by default. However, connections that use MARS are indicated within the connection dialogue of the console: Tools > Connections
If you see MARS connections indicated within the connection dialogue, we recommend enabling this feature: Tools > Compression Settings
While the statistics on the NitroAccelerator console are helpful in determining that it is installed and running properly, you will want to track other Network Performance measurements and Key Performance Indicators to gauge and prove the full benefits of running NitroAccelerator within and across your environment.
During your trial, we recommend activating NitroAccelerator on as many machines as possible over a trial period long enough to measure real-world quantitative results over time.
For quick testing and advanced tuning, we run a simple
SELECT statement from within SQL Server Management Studio both with and without NitroAccelerator enabled.
By running queries that are similar to what is found in your application, you can get an idea of possible impact.
To maintain data integrity, connections must be fully closed and re-established to enable NitroAccelerators SMB acceleration.
The fastest way to A/B test SMB acceleration is to run a baseline file transfer via Microsoft File Sharing before installing and activating NitroAccelerator.
While running the baseline test transfer, note the transfer time.
Next, Install and activate NitroAccelerator and reboot your server or the client you are testing from.
Open Microsoft File Sharing and check Tools > Connections to ensure that your connections are accelerated.
Remove the copied from the destination and then run the same file transfer again with Acceleration enabled to log and compare results.
Query Execution Time
Transactions Per Second (TPS)
Page load time
Application start time & performance
File Transfer time
High-priority IT Support Ticket counts
Bandwidth usage and cloud fees
We strive to ensure that our customers receive exponential value from our acceleration software.
We provide perpetual licenses with the first year of support and maintenance included. After the first year, we offer continued support and updates for 20% of the original payment amount.
For a quick quote, send your Server and Client count to: [email protected].
If you would like to discuss your goals, budget, and receive access to our specials and discount packages, schedule a quick call.
Invoices are sent via email. We accept Card, ACH, and Check. Online payments are processed by a certified PCI Service Provider Level 1 (the most stringent level of certification) payment gateway. Reach out to us Email: [email protected] Phone: 1-512-501-5254 Schedule a meeting: https://calendly.com/josh-nitrosphere/30min