2 Replies Latest reply on Dec 24, 2014 11:48 AM by choly

    NTA Flow Storage Database

    brentbo

      Hey Y'All,

       

      I'm planning a medium-sized NPM and NTA installation. In lab testing, we see that NTA offers a new offers a new fast-bit database when installing on a 64 bit machine. This might be a great idea, but....

      1. This seems to be a non-relational database. As network engineer, this is fine with me, but I'm not sure how our SQL DBAs will feel about this. For all its drawbacks, Microsoft SQL Server is mature, well-documented and has elaborate management tools. How do we manage the NTA Flow Storage Database, and where is it's documentation?

      2. I've previously encountered MS SQL Server performance issues induced by NTA, so I'm alert to the potential performance benefits of this new database. However, what we're planning is not a huge deployment. Is selecting MS SQL Server even an option when deploying on a 64 bit machine? (It didn't seem like an option during our prototype install, but maybe I'm missing something.)

      3. Are there any plans to offer a Flow Storage Database only deployment? That is, all SolarWinds applications utilizing this new database, with no MS SQL Server? That would be an interesting possibility!

      Thanks, Everybody, Brent

        • Re: NTA Flow Storage Database
          Lawrence Garvin
          1. This seems to be a non-relational database. As network engineer, this is fine with me, but I'm not sure how our SQL DBAs will feel about this.

          I'd like to throw some practical thought into this discussion. I've heard from a couple different places about perceived "complications" because SQL Server is not being used. A simple fact, however, is that ALL applications have some form of data storage, and quite a few of them do not use relational databases for data storage. Even applications that do use SQL Server, also have forms of data storage that do not include SQL Server.


          IMHO, SQL Server DBAs should only be concerned with applications that require a SQL Server for data storage,

          and any who are truly aware of the impact NTA has on their database servers will be ecstatic that NTA data storage is going away


          An interesting exercise is to enumerate all of the applications in use in the organization, and the data storage being used by them.

          For those that don't use SQL Server, ask the DBAs if they care about those applications. :-)


          1 of 1 people found this helpful
          • Re: NTA Flow Storage Database
            choly

            Brent,

             

            let me try to answer your questions:

            1. You are right, Flow Storage DB is lightweight single purpose database, maintained mostly automatically, so its management is mostly about giving it enough resources (especially well sized fast disk drive). There are multiple performance counters that could be used for FSDB monitoring either directly or using template for SAM server. It is SolarWinds who provides support for FSDB.

            2. No. Using SQL for storing flows in being considered as obsolete technology, and in long-term NTA won't support 32 bit deployments at all (Orion NetFlow Traffic Analyzer v4.0.2 Release Notes)

            3. Most probably not. Most of SolarWinds products relies on SQL operations which FSDB doesn't provide (or at least not effectively), so while FSDB is just great for fast storing tons of flows in line, SQL is kept for relations, often updated/deleted data, programability, etc.