SQL Server on-demand assessment step by step guide.

Question

I would like to set up an SQL Server on-demand assessment in the Microsoft ServiceHub on Azure, using the Azure Monitor Agent, Log Analytics Workspace, and scheduled jobs on the Data Collector machine for Azure Arc-connected SQL Servers. However, when creating the Data Collection Rules, I can only see Windows-related counters and not SQL Server-related ones. Am I missing something? Could someone provide a step-by-step guide? Your response would be greatly appreciated.

Answer 1

Hello Ramesh Babu •

Welcome to the Microsoft Q&A Platform! Thank you for asking your question here.

I understand that you are looking for assistance to setup SQL server on-demand

1. We have a guideline here: https://learn.microsoft.com/en-us/services-hub/microsoft-engage-center/health/getting-started-sql
2. PDF - https://learn.microsoft.com/en-us/services-hub/unified/health/assessment_prereq_docs/ama/setupassessment.pdf
3. FAQ page that has a collection of questions and answers: https://learn.microsoft.com/en-us/services-hub/unified/getting-started/on-demand-assessments-faqs

Anyway, we are always available via MS support portal, if still needed assistance please open a Support Request to us, and we will be more than happy to help.

If it was helpful, please ACCEPT the Answer and click "UpVOTE" on this post to let us know.

Thank You.

Lisboa