Azure-docs: Server Diagnostic Logging

[BharathMannem]

Does this diagnosis the Databases on IAAS Servers? If so how to enable the diagnostic logging for them, as diagnostic logging is required for the above solution

---

Document Details

⚠ Do not edit this section. It is required for docs.microsoft.com ➟ GitHub issue linking.

• ID: 77f273ec-aed5-1f65-0b6d-87240765d3e0
• Version Independent ID: d195959f-5742-7d94-f4f5-e70c0f0581e7
• Content: Azure SQL Analytics solution in Log Analytics
• Content Source: articles/log-analytics/log-analytics-azure-sql.md
• Service: log-analytics
• GitHub Login: @MGoedtel
• Microsoft Alias: magoedte

[vasivara-MSFT]

@BharathMannem Thanks for the feedback. We are actively investigating and will get back to you soon.

[vasivara-MSFT]

@BharathMannem No, this diagonsis cannot be applied for IaaS database servers. This is just for PaaS offering.
@MGoedtel can you please confirm the above statement?

[BharathMannem]

But the Dashboard shows Servers in heading.

[MGoedtel]

@BharathMannem - While that one screenshot of the dashboard may be misleading because the one visualization is labeled "Servers", this solution is for monitoring Azure SQL PaaS as @vasivara-MSFT indicated in his earlier response. For monitoring SQL on IaaS VMs, there is no corresponding solution. You could configure Log Analytics to collect metrics (events and perf data from SQL and OS) and create custom dashboards to visualize the telemetry or if you already use System Center Operations Manager, you can leverage the SQL management pack and monitor those VMs no differently than on-premises SQL Servers.

[vasivara-MSFT]

@BharathMannem We will now proceed to close this thread. If there are further questions regarding this matter, please reopen it and we will gladly continue the discussion.

[BharathMannem]

Thank you @vasivara-MSFT and @MGoedtel.