Hi,
I would like to know what benefits brings to migrate the bd to NTA SQL in version 4.4
Thanks.
holper, here's a few items in an FAQ we're preparing for the release of NTA with an SQL flow database backend:
What’s new in NTA 4.4?
NTA 4.4 uses an MS SQL columnstore database for flow storage. This technology offers significant performance improvements in a small resource profile than our earlier versions of the product. Consolidating our databases on a single platform reduces the expense and complexity to stand up and manage a Solarwinds deployment, and offers security, performance, continuity, and resiliency that is maintained and constantly developed by Microsoft, and allows us to focus exclusively on the development of new product features.
NTA 4.4 also includes a new feature to monitor and report on malicious traffic destined for TCP or UDP port 0.
Finally, NTA 4.4 delivers support for TLS 1.2 communication channels.
Why are we changing to MSSQL for the NTA Flow Storage database?
NTA was an early adopter of columnstore technology to enhance the performance of our flow storage database. As Microsoft’s columnstore solutions have matured, we’ve chosen to adopt the MS SQL 2016 and later versions as the supported flow storage technology. That offers our customers the ability to standardize and consolidate on MS SQL across the Orion platform, and to manage their monitoring data using a common set of tools with common expertise. We’ve made deployment and support simpler, more robust, and more performant.
Consolidating on Microsoft’s SQL technology means we can focus our development efforts on new flow analysis features, rather than maintaining a dedicated database solution. Microsoft will continue to enhance and develop their SQL server to bring additional performance and robustness features to all of our customers.
What are some of the benefits of using MS SQL for NTA Flow Data?
NTA with an MS SQL flow storage database is faster than previous versions. Microsoft SQL with columnstore indexing offers accelerated query performance, and a faster troubleshooting workflow with resource performance enhancements. MS MSQL also offers increased efficiency of your hardware footprint with a significant reduction in CPU and IOPS.
There's also a discussion in the NetFlow Traffic Analyzer Release Candidate forum on this topic.
joer
