Monitoring SQL Server
![Magalhaes](https://us.v-cdn.net/6037292/uploads/defaultavatar/nIB7TCBOBXJDO.jpg)
Comments
-
This can be done via SNMP in Atera. The follow Knowledge Base article will provide you with the steps needed to monitor SQL:
https://support.atera.com/hc/en-us/articles/215284968-Monitor-SNMP-Devices
FWIW the memory consumption is low (~100MB of RAM), maybe lower.
To create the alert, you will need to add OIDs. To find the OID, you will need to get this from the manufacturer or from the web: https://support.atera.com/hc/en-us/articles/217172348-Add-OIDs-for-SNMP-Device-MonitoringWe also now have AI generated OIDs, to learn more: https://support.atera.com/hc/en-us/articles/9728694929052-AI-generated-OID-recommendations
0 -
Hi @Magalhaes ,
are you talking about a windows SQL server?
In case it is windows then you can install the normal atera agent. Per default it monitors the CPU, memory and HDD usage on the server. You can set thresholds when you want to create an alarm.Additional to that you can monitor for windows eventlogs or automatically run powershellscripts in which you create a alarm based on the return value of the script.
It would also be possible to monitor a service via the threshold configuration.
1 -
0
Topics
- All Topics
- 39 Getting started
- 23 Read before posting
- 8 Meet and greet
- 207 General
- 57 News and announcements
- Swag
- 1 Roadmap updates
- 63 Resources
- 8 Knowledge Base
- 11 Webinars
- 1 Shared Script Library
- 1 Blog
- 14 Pro Tips
- 26 Got an idea?
- 1 ActionAI
- 1 Copilot
- 116 Remote Monitoring and Management
- 76 Remote Monitoring
- 23 Patch Management
- 83 Professional Services Automation
- 50 Helpdesk
- 15 Billing
- 17 Reporting
- 32 Integrations & add-ons
- 18 Integrations
- 10 Add-ons
- 88 Scripting and automations
- 53 Scripts
- 25 Automations