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.
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?
NitroAccelerator only accelerates transmission protocols, and so will not impact non-transmission backup speeds.
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.