Options

Multiple Base Monitors dumping into one Repository?

betternamebettername Posts: 2
edited October 30, 2013 3:20PM in SQL Monitor Previous Versions
Hi,

Just wondering the the above was possible?

Basically, I've got some boxes monitored on our network, but we also have some boxes hosted "out there somewhere" - there is a constant VPN between us and the host, and SQL traffic flows freely, but the monitoring stuff (WMI etc) DOESN'T (could be firewall issues, could be untrusted domains). Splitting the monitoring duties (ie: repository/base/web at each site) works fine, but means there are two sites to browse, which is a bore.


So, to summarise, can I have:

Local Domain:
Base monitor monitoring SQL boxes down here
Repository
Web - for local & hosted data

Hosted Domain:
Base monitor monitoring SQL hosted SQL Boxes, but dumping data to repository in Local Domain.

Cheers...
J
· Share on Twitter

Comments

  • Options
    chriskellychriskelly Posts: 378
    Unfortunately, it isn't currently possible to have two Base Monitor services inserting data into a single data repository. It sounds like you are already using the best workaround of having two separate installs. While this is not ideal, it is technically the easier and more reliable way of doing it.
    · Share on Twitter
  • Options
    TheLonelyDBATheLonelyDBA Posts: 21
    Hello. I'm a new user to RedGate tools, and the first one I'll test is the SQL Monitor.

    Currently we have 2 domains on my work network, so I was searching the forums for similar setups in order to know what to do.

    Do the support team has any news regarding this kind of environment? Is this supported on SQL Monitor 3.5 by now?

    I have not yet installed the services, but will do it soon and this information will be important.

    regards,
    Tips and thoughts on MS SQL, Oracle and MongoDB:
    http://thelonelydba.wordpress.com
    · Share on Twitter
Sign In or Register to comment.