Dear All,
Any idea on how can we monitor all SQL related services on a respective machine..? Can we use keywords with service monitor or do we need to use SQL query to monitor the same..?
Thanks in advance.
To use the in SAM built in "Windows service monitor" you need to specify each service name.
Another option is to create a powershell script that gives you info about all SQL services, but then you will not get all the extra information about the service, like resource usage.
Hello @Seashore,
Great to see your immediate response. Thanks much for it..!
Specifying each service name is not going to work in our case. We have too many servers & too many instances under it.
I think, we need to create a power shell script. SQL service name & it's current status is more than enough at this moment.
Let me know any leads regarding PS script.
Thanks again..!
You can absolutely script it. But if you don't want to service match names, and don't need the start/stop abilities of the service (which powershell won't have either unless you script an alert action anyway) you can just monitor the process for SQL server.
