Great for analytics workloads!
Use Cases and Deployment Scope
We use SQL Server for our data warehouse. It's sitting on an Azure VM. Our analysts pull large data sets into SSMS, R, and Tableau all day long. Most of the runtime for these queries is waiting on the network. NitroAccelerator cuts those wait times by 50-90%! This has sped us up dramatically. Waiting for queries was a regular time sink, and now it's something we never have to think about. Most of our analysts don't even know that NitroAccelerator is running in the background.
Pros
- Speed up network-choked queries
- Massive compression for data transfer
Cons
- I would love to move to serverless DBaaS - Azure SQL Database or AWS RDS for SQL Server. However, the product needs to be installed on the server.
Most Important Features
- Great network compression (50-90%)
- Transparent and just works: no end-users know this is running
- Low overhead - the CPU hit for compression is negligible
Return on Investment
- Queries are 50%+ faster than before
