Getting Data In

Index alert excessive growth

Emiskowi
New Member

We are having problem with some of our indexes growing rapidly. I am trying to figure out a search/alert that have a deviation by the hour compared to previous days at the same time. I have the following search below that gives me the usage by the hour. Any help would be greatly appreciated.

index=_internal group="per_index_thruput" earliest = -1h@h latest=@h
| eval mb=kb/1024
| timechart span=1h sum(mb) as HourlyTotal
| addtotals fieldname=HourlyTotal
| streamstats sum(HourlyTotal) AS AccumulatedTOTAL
| bucket _time span=1d

0 Karma

valiquet
Contributor

You can use standard deviation
| stats stdevp(HourlyTotal) as standdev by series | head 1 | where Hourly> HourlyTotal*2

0 Karma
Get Updates on the Splunk Community!

Application management with Targeted Application Install for Victoria Experience

  Experience a new era of flexibility in managing your Splunk Cloud Platform apps! With Targeted Application ...

Index This | What goes up and never comes down?

January 2026 Edition  Hayyy Splunk Education Enthusiasts and the Eternally Curious!   We’re back with this ...

Splunkers, Pack Your Bags: Why Cisco Live EMEA is Your Next Big Destination

The Power of Two: Splunk + Cisco at "Ludicrous Scale"   You know Splunk. You know Cisco. But have you seen ...