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!

Investigate Security and Threat Detection with VirusTotal and Splunk Integration

As security threats and their complexities surge, security analysts deal with increased challenges and ...

Observability Highlights | January 2023 Newsletter

 January 2023New Product Releases Splunk Network Explorer for Infrastructure MonitoringSplunk unveils Network ...

Security Highlights | January 2023 Newsletter

January 2023 Splunk Security Essentials (SSE) 3.7.0 ReleaseThe free Splunk Security Essentials (SSE) 3.7.0 app ...