I wanted to create a custom alerting for Oracle database servers. Currently it's being monitored manually on the server itself via a cronjob using a query such as below:
blocking_session is not NULL
How do I create this alert in SolarWinds for me to alert me when there's a blocking happens in the DB?
When you create a SQL or Oracle query in orion, the result has to be once single value, and that value has to be an integer.
In your case, I suggest the query is changed so that it counts how many blocking sessions there is. Then you have a critical-threshold on the component in SAM, maybe when nr of blocking is more than 0 for x polls in a row.
Then, when monitoring is up, you can have an alert created.
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 150,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.