Can we turn-off/disable Diagnostic settings from SQL database without deleting it

Question

Can we turn-off/disable Diagnostic settings from SQL database without deleting it

SivaB 96

SQL DB Azure log analytics workspace consumption is high due to which cost increased unexpectedly.

We wanted to stop the analytics temporarily, could that possible to disable it from Diagnostic settings on SQL DB.

GeethaThatipatri-MSFT 29,552 Reputation points Microsoft Employee Moderator

2022-10-05T15:14:30.847+00:00

Hi, @SivaB Thanks for posting your question in the Microsoft Q&A forum.
If I understand correctly you want to disable diagnostic settings in Azure SQL DB
Did you try checking on edit settings removing the log analysis as a destination and saving it that will disable the settings

Please let me know if you are looking for additional information.

Regards
Geetha
SivaB 96 Reputation points

2022-10-06T11:30:44.743+00:00

Hi @GeethaThatipatri-MSFT , thanks for reply.
I tried with that option as well, when we tried with this SAVE option is graded out. May be we need to choose anyone destination as mandatory.

We have situation that log analytics workspace usage become high suddenly due to huge no of logs are stream on it. For now we identified the issue and logs not generating.

One query that, can we delete these logs anyway these logs not require anymore?
Also do we have any way to notify on sudden cost hikes for Azure resources. Cost alerts we set for subscription level but we would like to set for resources. will that possible.

Accepted answer

0 additional answers

Your answer

GeethaThatipatri-MSFT 29,552 Reputation points Microsoft Employee Moderator

2022-10-05T15:14:30.847+00:00

Hi, @SivaB Thanks for posting your question in the Microsoft Q&A forum.
If I understand correctly you want to disable diagnostic settings in Azure SQL DB
Did you try checking on edit settings removing the log analysis as a destination and saving it that will disable the settings

Please let me know if you are looking for additional information.

Regards
Geetha
SivaB 96 Reputation points

2022-10-06T11:30:44.743+00:00

Hi @GeethaThatipatri-MSFT , thanks for reply.
I tried with that option as well, when we tried with this SAVE option is graded out. May be we need to choose anyone destination as mandatory.

We have situation that log analytics workspace usage become high suddenly due to huge no of logs are stream on it. For now we identified the issue and logs not generating.

One query that, can we delete these logs anyway these logs not require anymore?
Also do we have any way to notify on sudden cost hikes for Azure resources. Cost alerts we set for subscription level but we would like to set for resources. will that possible.

Answer 1

GeethaThatipatri-MSFT 29,552 Microsoft Employee Moderator

Hi, @SivaB
The Diagnostic Settings are like a faucet to control the flow of logs into Log Analytics. Deleting the Diagnostic Settings stops the flow, but does not delete the actual logs. To resume the flow you will need to make the Diagnostic Settings again.

If you want to remove the log data from Log Analytics, I recommend you first look at the Retention Date to control how long the data stays before erasing itself. If that is not enough, you can also look into Data Purge to definitively erase the raw data. You can purge the data if it is not needed anymore. But once purged you cannot recover that data. The information available here Workspace Purge - Purge - REST API (Azure Log Analytics) | Microsoft Learn Also LA data is only retained until the retention date, After the retention date the data will be removed, in case you do not want to purge it

For future scenarios, you can also review the daily cap to keep the cost at bay Set daily cap on Log Analytics workspace - Azure Monitor | Microsoft Learn
Azure Monitor Logs pricing details - Azure Monitor | Microsoft Learn

Regards
Geetha

GeethaThatipatri-MSFT 29,552 Reputation points Microsoft Employee Moderator

2022-10-07T20:41:24.817+00:00

Hi, @SivaB We haven't heard back from you. Just wanted to check if you find the above reply useful. If yes, do click on the 'Mark as answer' link in the above reply. This will help other community members facing similar queries to refer to this solution.

Regards
Geetha
GeethaThatipatri-MSFT 29,552 Reputation points Microsoft Employee Moderator

2022-10-25T13:32:48.87+00:00

@SivaB Thank you for visiting the Microsoft QA forums! Have a great day!

Regards
Geetha

Share via

Can we turn-off/disable Diagnostic settings from SQL database without deleting it

0 additional answers

Your answer