Monitoring SQL Server

Options
Magalhaes
Magalhaes Member Posts: 1
edited September 2023 in Remote Monitoring

hi

i am novice in atera plataform

so my question is,how monitoring a sql server?

service is running,and how much memory is consuming and create a alert

thanks

Tagged:

Comments

  • nina
    nina Administrator Posts: 428 admin
    Options

    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-Monitoring

    We also now have AI generated OIDs, to learn more: https://support.atera.com/hc/en-us/articles/9728694929052-AI-generated-OID-recommendations

  • mbudke
    mbudke Member Posts: 87 ✭✭✭
    Options

    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.