How to enable the diagnostics logs for SQL Database in Azure

If you want to monitor your Azure SQL instances through the OMS then you should enable this first. To do that, first go into the SQL Databases and select the correct DB that you want to enable the diagnostics.

Then click Diagnostics settings under Monitoring. As you can see, If the Diagnostics not enabled, then you can click on “Turn on Diagnostics”

Give a name and select the service that you want to use to get the logs. Here I’m using send to log analytics. Then select the logs that you want to grab and send to your Log analytics.

Now you will be able to get the data into OMS.

How to enable Enable Diagnostics Extension - Microsoft Azure

Azure Diagnostics is the capability within Azure that enables the collection of diagnostic data on a deployed application. You can use the diagnostics extension to collect diagnostic data like application logs or performance counters from an Azure virtual machine.

This is  supported for Windows and Linux environments.

To enable this you should go into the Virtual Machine instance that you want to enable the “diagnostics extension” then click on Diagnostic settings 

If this was not enabled, then you will get the above mentioned window and by clicking on “enable Guest level Monitoring” you will be able to enable this.

Under performance counter Tab you can select the counters that you want to monitor.

Once you select Custom, then you can do the customization to the counters and add new counters as well.

Under Logs, you can enable the Event logs that you want to get the alerts. If you want to customize them, then you can go with the custom Tab.

Can select the Storage account can be select under the Agent tab and if you want to remove the Diagnostics Agent, that is also you can do here.

Hope this will help you to the Log analytics through OMS. Next post will be more into the OMS fine-tuning.

[Solved] Cannot manage active directory certificate services … error

If you get an error message when you try to start the Active directory certificate service,

Cannot manage active directory certificate services. The system cannot find the file specified: 0x800700002 (WIN32: 2 ERROR_FILE_NOT_FOUND).

You can follow the below steps to overcome  this issue,

Basically what you need to do is to run the Post Deployment Configuration again and complete the installation of the Certification authority.

I have copy paste  the steps to do that and hope My help will not need to configure this as it was already there in the configuration file.

Once this is successful, you can restart the PC and next time you will be able to open your Certification Authority.