Management Rule - SQl Server running on windows virtual machine

sachinkdy — Thu, 22 Aug 2024 05:58:01 GMT

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

Re: Management Rule - SQl Server running on windows virtual machine

Yosi_Neuman — Sun, 18 Aug 2024 08:45:16 GMT

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

topic Management Rule - SQl Server running on windows virtual machine in Open Q&A

Management Rule - SQl Server running on windows virtual machine

Re: Management Rule - SQl Server running on windows virtual machine