Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

ALL SQL Service Monitoring

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.

Find more posts tagged with

sql services

sql

Comments

Seashore

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.

Solaiy

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..!

jm_sysadmin

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.

Quick Links

All Categories
Recent Posts
Activity
Unanswered
Groups
Help
Best Of

Cisco ASR Devices
Cisco ASR Devices.pollerCisco ASR Devices
Basic SWQL Syntax
SWQL is built on the framework of SQL and as such supports most of the standard clauses as part of a query. A very simple example query is: SELECT Caption, IPAddress, Vendor, ResponseTime FROM Orion.Nodes Dissecting this query is relatively straightforward: show some fields (Caption, IP address, Vendor, and Response Time)…
Cisco ASA SSL Tunnels
Active SSL Tunnels-ASA.UnDPThis poller *should* display the number of Active SSL VPN (Anyconnect) Tunnels currently connected to your box. However, I tried it with my 5520 running 8.0.4 and for some reason I get a OID Not Supported. Here's my post in the forum: *EDIT* This is confirmed working with at least Interm release…
HP ProCurve Switches Hardening check
HP ProCurve Switches Hardening check.xmlGeneral hardening for HP switches