Now that support for SQL 2000 has been dropped, any discussion on enhancing Orion NPM to leverage transaction levels?
We talk about a lot of options. But we always ask about use cases, not technology: What problem are you trying to solve?
Nothing specific, I just see alot of opportunity on the database side to improve performance and throughput. I.E in the case of NTA with SQL 2005 you can leverage row versioning using snapshot isolation instead of creating all the tables. Removing the actions that lock the application in order to create or modify the table storing temporary Netflow data will reduce overall database conention. Given the database already has some filegroup you can extend this with partitioning to help create seperate I/O channels for different devices.
