Is there a guide on recommended database maintenence for NPM? I am new to SQL server and wondering if there is some tweaks or other things I can do to help improve performance. NPM takes several seconds to complete a login, pulling up a node details page takes 10-15 seconds, pulling up a custom chart takes a similar amount of time.
I think the box should be big enough to handle the load... dual quad core Xeons at 2.5GHz, and 8GB of RAM to monitor around 175 nodes and 400 interfaces. I had a similar load on my old cacti box and graphs loaded in split seconds (granted pulling from an round robing database and not a SQL database).
I am somewhat shocked by the poor response times of the web interface to be honest.
