NetPerfMon DB replication for DR or data warehouse
I would like to replicate specific tables and views from the NPM database to another SQL server to enable data warehousing and reporting. ha anyone done this successfully?
in the old versions when the database structure was very simple, it would have been simple to setup, however, in the new forma with views for the likes of "ResponseTime" and "interface utilisation" etc, there are now views, with dependant views, and then dependant on a dynamic set of tables that contain he raw data.
so the table-names for interface utilisation will change through time as data is summarised as there is a table for each day of data. once that day of data becomes obsolete, it is deleted". I assume the "Views2 are dynamically updated also to reflect the table name changes
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community.
More than 150,000 members are here to solve problems, share technology and best practices, and directly
contribute to our product development process.
Learn more today by joining now.