Is there a way to speed it up? I cant believe how slow it is to bring up the pages, considering the server is a dual CPU Dual core platform running 3.0Ghz.
You u need to describe your environment. For instance....what is the make up of your SQL server? # of elements? Anything else to describe ur set up.BB
I have about 2000 nodes, the SQL server is by itself on a 2000 platform, but I go over a T1 to get to it until I complete the installation, then they will be on the same network. Is the fact the SQL server is remote the problem?
Response time between the NPM and SQL servers plays a huge role. While there are those who have had varying degrees of success with a distributed architecture over higher speed links with ~30ms response times (T3, OC3, OC12, etc.), it's generally not reccommended.
The other thing you can do is purchase the additional web server, and install it on your database server.
Even with our database server and primary poller on the same local network, we found this helped our web response times greatly (4000+ nodes).
Sav.