Management Rule - SQl Server running on windows virtual machine

[sachinkdy]

Hi Everyone

We have a Azure VM and on that Sql server is running which we have installed using extention , we'd like to monitor SSISDrive-local service .

As soon as if it gets stop we should have a alert profile trigger, i am creating entity selector to trace teh rquired service and tried many ways however so far didn't find any solution

e.g.

type("PROCESS_GROUP_INSTANCE"),entityName.contains("sqlservr.exe")

type("PROCESS_GROUP_INSTANCE"),entityName.contains("SSISMapDrive")

type("PROCESS_GROUP"),entityName.contains("SSISMapDrive")

Could you please direct me to create rule  to capture running sql server job on virtual machine host.

Thanks

[Yosi_Neuman · Accepted solution]

Hi @sachinkdy 

IMO, You can set availability monitoring on process group setting or to set OS services monitoring for the OS service that runs sqlservr.exe

HTH

Yos