I am trying to formulate an alert to trip if CPU/Memory exceeds 95th percentile line for 5 min...anyone have a clue on the sql statement or if what I am looking for is even possible?
What if it were for something like response time instead of CPU/Memory? For example, we wanted an alert if response time suddenly increased at a site. Setting up an alert trigger when it exceeds 95th percentile would have been a nice option. Instead, I created a dozen different "bucket" alerts and added sites that fit the appropriate bucket (alert when response time > 40ms, 50ms, 100ms, 200ms, etc).
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 195,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.