How to Monitor Microsoft SQL Azure Database Server Using eG Enterprise?

The broad steps for monitoring the Microsoft SQL Azure database server using eG Enterprise are as follows:

  • Managing the Microsoft SQL Azure database server
  • Configuring the tests

These steps have been discussed in the forthcoming sections.

Managing the Microsoft SQL Azure Database Server

The Microsoft SQL Azure database server cannot be automatically discovered by eG Enterprise. This implies that you will have to manually add the server into the eG Enterprise system to manage it. Follow the steps below to achieve the same:

  1. Follow the Components -> Add/Modify menu sequence in the Infrastructure tile of the Admin menu.
  2. Next, select Microsoft SQL Azure from the Component type drop-down and then click the Add New Component button.
  3. When Figure 1 appears, provide the Host IP/Name of the Microsoft SQL Azure database server that you want to manage.

    Figure 1 : Managing a Microsoft SQL Azure database server in an agentless manner

  4. Then, provide a Nick name for the server.
  5. The Port number will be set as 1433 by default. If the Microsoft SQL Azure database server is listening on a different port in your environment, then override this default setting.
  6. In case you are monitoring a Microsoft SQL Azure database server in an agent-based manner, just pick an external agent from the External agents list box and click the Add button to add the component for monitoring.
  7. On the other hand, if you are monitoring a Microsoft SQL Azure database server in an agentless manner (see Figure 1), then do the following:

    • Select the Agentless check box.
    • Pick the OS on which the Microsoft SQL Azure database server is running.
    • Set the Mode to Other.
    • Select the Remote agent that will be monitoring the Microsoft SQL Azure server. Note that the Remote agent you choose should run on a Windows host.
    • Choose an external agent for the server by picking an option from the External agents list box.
    • Finally, click the Add button to add the Microsoft SQL Azure database server for monitoring.

  8. Once the Microsoft SQL Azure component is added successfully, you will be again redirected to the Components at a Glance page (see Figure 2). Using the options provided in the Component at a Glance page, you can modify, unmanage or delete the newly added component. In addition, you can also configure the tests, set thresholds and maintenance policies, and change the IP address.

    Figure 2 : Components at a Glance page

  9. To collect the performance metrics, you may need to manually configure the tests that are mapped to the Microsoft SQL Azure component. To configure the tests that need manual configuration, click on the icon in Figure 2. This will lead you to the Specific Test Configuration page where the unconfigured tests for the Microsoft SQL Azure component will be listed in the Unconfigured Tests list box.

    Figure 3 : Unconfigured tests for the Microsoft SQL Azure component

  10. Now, click on the test name to configure it. To know how to configure the tests, refer to the Monitoring the Microsoft SQL Azure Database Server Using eG Enterprise. To view the performance metrics, switch to the Monitor tab.