# Management Rule - SQl Server running on windows virtual machine

**URL:** <https://community.dynatrace.com/t/management-rule-sql-server-running-on-windows-virtual-machine/47172>\
**Category:** Open Q&A\
**Tags:** databases, process-groups, hosts-classic, processes\
**Created:** [August 16, 2024, 6:57am UTC](https://community.dynatrace.com/t/management-rule-sql-server-running-on-windows-virtual-machine/47172 "2024-08-16T06:57:36Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![sachinkdy](https://avatars.discourse-cdn.com/v4/letter/s/e36b37/32.png) [@sachinkdy](https://community.dynatrace.com/u/sachinkdy)\
**Post date:** [August 16, 2024, 6:57am UTC](https://community.dynatrace.com/t/management-rule-sql-server-running-on-windows-virtual-machine/47172/1 "2024-08-16T06:57:36Z")

</div>

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&nbsp; to capture running sql server job on virtual machine host.

Thanks

---

<div class="post-metadata">

**Author:** ![Yosi\_Neuman](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/yosi_neuman/32/9845_2.png) [@Yosi\_Neuman](https://community.dynatrace.com/u/Yosi_Neuman)\
**Post date:** [August 18, 2024, 8:45am UTC](https://community.dynatrace.com/t/management-rule-sql-server-running-on-windows-virtual-machine/47172/2 "2024-08-18T08:45:16Z")

</div>

Hi&nbsp;[@sachinkdy](https://community.dynatrace.com/user/77601)

IMO, You can set [availability monitoring](https://docs.dynatrace.com/docs/shortlink/process-group-alerting) on process group setting or to set&nbsp;[OS services monitoring](https://docs.dynatrace.com/docs/shortlink/os-services)&nbsp;for the OS service that runs&nbsp;sqlservr.exe

HTH

Yos