Splunk Search

Optimizing metrics based searches?

auzelevski
Explorer

Hello,

I have the following query in one of the panels in my dashboard.

 

 

 

| mstats p95(prometheus.container_memory_working_set_bytes) as p95_memory_bytes span=1m where pod=sf-mcdata--hydration-worker* AND stack=$stackLower$ by stack
| stats min(p95_memory_bytes) as min_p95_memory_bytes by _time
| timechart span=1m count as Availability
| eval Span=1
              | stats sum(Availability) as totalAvailability, sum(Span) as totalSpans
              | eval AvailabilityPercent = 100*(totalAvailability/ totalSpans)
              | fields AvailabilityPercent

 

 

 

There are some stacks that return too many events for this metric and this causes a timeout and then the search fails.

Is there a way to optimize this query to work with a lot of events?

Labels (1)
0 Karma
Get Updates on the Splunk Community!

Optimize Cloud Monitoring

  TECH TALKS Optimize Cloud Monitoring Tuesday, August 13, 2024  |  11:00AM–12:00PM PST   Register to ...

What's New in Splunk Cloud Platform 9.2.2403?

Hi Splunky people! We are excited to share the newest updates in Splunk Cloud Platform 9.2.2403! Analysts can ...

Stay Connected: Your Guide to July and August Tech Talks, Office Hours, and Webinars!

Dive into our sizzling summer lineup for July and August Community Office Hours and Tech Talks. Scroll down to ...