topic Re: Calculate max TPS over period of time (2 months) everyday in Monitoring Splunk

Calculate max TPS over period of time (2 months) everyday

dantu — Tue, 29 Sep 2020 23:02:10 GMT

HI,

I want to get the max TPS over period of time per day (last 2 months). Any idea what would be the ideal way to do this?

I tried a query but i am not sure to get it per day

index=xyz host=xyz*web* NOT _ui AND NOT medias AND NOT "/backoffice" AND "HTTP/1.1\" 200" | timechart span=1s count AS TPS | eventstats max(TPS) as peakTPS | eval peakTime=if(peakTPS==TPS,_time,null()) | stats avg(TPS) as avgTPS first(peakTPS) as peakTPS

Re: Calculate max TPS over period of time (2 months) everyday

ssadanala1 — Tue, 29 Sep 2020 23:02:13 GMT

index=xyz host=xyz*web* NOT _ui AND NOT medias AND NOT "/backoffice" AND "HTTP/1.1\" 200"|bin _time span=1d | stats max(TPS) as c by _time .

Gives you maximum vlaues of TPS per day

or you can use

index=xyz host=xyz*web* NOT _ui AND NOT medias AND NOT "/backoffice" AND "HTTP/1.1\" 200"| timechart span=1d max(current_size) as c

Re: Calculate max TPS over period of time (2 months) everyday

dantu — Thu, 31 Jan 2019 21:28:09 GMT

but this wont give me the TPS right? span here is 1d?