Create a central web interface that can access multiple Base monitors
Given the sizes of some SQL environments we found that it is necessary to have multiple base monitor servers. However currently it is cumbersome to have to navigate to multiple URL's or switch the base monitor that's tied to a web server. Having a central console that is easily and always connected to multiple base monitors would alleviate this problem. Also this could allow you to monitor from various networks and domains.
eric twilegar commented
I'd prefer installing an agent on each sql server that pipes data back to a central basemonitor/web access stack. The amount of ports that have to be open between the base monitor and your sql server is disturbing.
I would like this also. My work network mandates distinct VLANs / Domains for each group of servers, heavilly firewalled and with no trust on the domains.
so using Windows Authentication is impossible, as is fixing the WMI ports on monitored servers. having 2 or more "central management" is not exactly "central" anymore. having multiple servers capturing data on distinct networks and reporting to one single database would be great.
I was also part of the beta for SQL Monitor Hosted, and as an example this could work for that product also: having multiple relays could make our life easier when we need to monitor servers on distinct domains/vlans.
Eric Humphrey commented
I'd like to add that sometimes you need to use different base monitors to monitor different subnets or vlans of servers, but all report back into the same repository. The whole goal is one pane of glass for all servers, not a segmented view.
This would be quite helpful. I know that our environment is an edge case but we're having trouble trying to figure out how we can monitor 1200+ databases across several instances without setting up multiple base monitors and web servers. Maybe another title for this could be a "Scale out" base monitor solution?
Priya Sinha commented
Thanks a lot for clarifying.
I would like to view all the base monitors at the same time, from one location.
Priya Sinha commented
Thanks a lot nhartman for this suggestion.
Would you like to view all the base monitor at the same time? Or is the problem only associated with switching between web servers?