"MSSql DB On Windows" Pattern not launching

[Priyanka Ghosh]

Hello,

For a windows server, I found the pattern - "MSSql DB On Windows" is not even triggering/launching whereas other necessary patterns are launching as expected (PFA the screenshot). What could be the possible reasons/conditions?

Any insights on this would be really helpful.

-Thanks.

[Niklas Peterson]

Hi,

Is your Process classifier Microsoft SQL Server active?

It should be the process classifier that triggers the pattern when it finds a matching process on the server.

Regards,
Niklas

[Priyanka Ghosh]

Hello,

Yeah, it's on. 

The issue here is the pattern is being triggered for almost all the windows servers (PFA the screenshot) except handful of them. So just wanted to know is there any specific condition wherein this pattern (MSSql DB On Windows) will not be launched?

Thanks.

[Priyanka Ghosh]

Thanks, the issue has been resolved. It was confirmed by the team that there are no actively running SQL databases on those few exceptional servers.

[Niklas Peterson]

Great! The condition for the pattern to be triggered is that there is a running process with a command that contains "sqlservr" running on the server.

Regards,
Niklas