Monitoring Azure SQL

General
,
1

Hi, is it possible to monitor an Azure SQL instance? I presume that the Azure SQL needs to be on a VM in Azure where we can put an agent in order to monitor it and therefore create some rules against the database?
Is there anything in future versions that could support this (currently we are on 2.2.0p18).

2

Hi,

I think this is possible with the new mssql check in checkmk 2.3

3

Is there a link which describes this? How can it monitor if it canā€™t get the agent onto the instance?

Any further info I do see this. Does this mean a SQL managed instance in Azure can be monitored if there is no VM.

image
image1070Ɨ435 56.3 KB

4

Although this would rely on us getting our Subscriptions working which I have a support ticket open for which is an essential part of our requirements.

5

I think the data is being fetched via SQL commands remotely and no checkmk agent in necessary on the the db server.

6

This is interesting and could be very useful for us. Would it rely on getting the Azure subscriptions and resource groups? Because Iā€™m not confident about getting this resolved (due to Microsoft Rate Limits).
Or can this be setup separately?

7

With the new MSSQL agent plugin in 2.3 , it is possible to monitor MSSQL databases locallly as well as remotely. For remote, it can also be a standard Database remote cloud based headless service with a VM attached to it.

8

So we have SQL Managed instances in Azure where no VM is used. This is what I need to know if it can be monitored or not as Iā€™d like to apply some of the SQL rules to the databases to create services for them in checkmk.
Iā€™m not sure if this is possible if there is no ā€˜hostā€™ or VM in checkmk that represents these?
Or with 2.3 if this is possible to create a service from monitoring this SQL instance?

We run the enterprise version, so will this be available in this or only the cloud version?

9

I have upgraded to version 2.3.
Can anyone point me in the direction of the documentation to remotely monitor the Azure SQL instances?

10

Is there documentation on how to configure this?

11

Is there documentation on how to configure this? We want to be able to monitor table error logs in a SQL instance in Azure.

12

Is it possible to also monitor Azure Cosmos DB in the same way?

13

Its possible now Werk #17540: Microsoft SQL Server plugin supports now Azure SQL Server monitoring

2 Likes
14

How though, is there any documentation with this?

15

Any documentation around this one yet?

1 Like
16

The monitoring should be done by a device with Checkmk Agent + SQL Plugin. In Agent Bakery you can define the parameters:
image

You could deploy the agent on Checkmk Server and use it to query your remote instance, at least theoretically.

17

Yes in ā€˜theoryā€™, does it work though? Thereā€™s no documentation around this.
What would the hostname be, the Azure SQL database IP address?

1 Like
18

Yes, but ideally you will provide the DNS in use for that connection.

19

Ideally, you just need ā€œhostnameā€ , ā€œusernameā€ and ā€œpasswordā€ . Thatā€™s it. You will be connecting the remote Azure SQL service. There is nothing else attached to it. For example, below is more than enough:

/usr/lib/check_mk_agent/plugins# cat /etc/check_mk/mk-sql.yml
---
mssql:
  main:
    authentication:
      username: username 
      password: password 
      type: sql_server
    connection:
      hostname: myazuredatabaseserver.database.windows.net
      port: 1433
      trust_server_certificate: true

Before that, try to do a basic telnet/nc to check whether the port is reachable or not.

1 Like
20

Is there any Azure SQL Database documentation yet?