Frequently Asked Questions
How does licensing work?
We provide a perpetual license with the first year of support and maintenance included. After the first year, it's 20% of invoice to continue support and maintenance updates.
Does NitroAccelerator work with protocol encryption enabled within SQL Server?
Unfortunately, NitroAccelerator does not work with SQL Server protocol encryption enabled. Encrypted data does not compress well, so NitroAccelerator will just bypass and not compress any encrypted packets it encounters. Because of this you will not see any benefit with NitroAccelerator until the protocol encryption is turned off. However, NitroAccelerator includes its own option for protocol encryption, which is done after the data is already compressed. This maintains the performance benefit while still securing your connection.
Do you support application servers running Linux?
NitroAccelerator is a Windows only solution, but we do accelerate and secure non-linux clients accessing the SQL Server. It is also possible to use a Windows system with us installed to proxy to the server. Reach out to us for details.
Is NitroAccelerator cluster aware?
Yes. To run NitroAccelerator on a cluster, simply install the product on each node. On failover, your clients will continue to benefit from a compressed connection.
What is the CPU overhead when using NitroAccelerator?
This will depend on the compressibility of your data, but we typically see overhead in the range of 1-3%.
Will NitroAccelerator run on a virtual server?
Yes, NitroAccelerator can be run on a virtual machine.
Will NitroAccelerator speed up my backups?
No, NitroAccelerator only compresses the TDS protocol, and so will not impact backup speed.
Windows 2008 and later
Vista and later
2000 through 2019
If I have NitroAccelerator installed on a client or server, will I still be able to connect to a client/server that does not have NitroAccelerator installed?
Yes. NitroAccelerator does not affect any connections with non-NitroAccelerator clients or servers. However, you will only get the compression benefit on connections that have NitroAccelerator installed on both ends.
What is HyperCache?
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.
Why does the Diagnostics dialog show a warning for my clients using MARS?
Multiple Active Result Sets (MARS) is a separate protocol on top of the Tabular Data Stream that is extremely chatty and tends to perform very poorly over slow networks. To maximize performance, we recommend that our customers not use MARS, but instead use a different connection for each query. NitroAccelerator will provide a much greater performance benefit on connections that do not have MARS enabled.