Splunk Search

tunning search from accelerated datamodel #By clause

net1993
Path Finder

Hello
What options there are to tune search from already accelerated data model with 3+tb data?
the slowliness comes from using by clause.
search:
| tstats summariesonly=true count FROM datamodel=mydatamodel WHERE earliest=-7d@d BY field1, field2

So far I have checked usage for cpu, memory on sh and idx but nothing unusual. (No high usage for nothing.)

Datamodel status is 100% done

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

Upcoming Webinar: Unmasking Insider Threats with Slunk Enterprise Security’s UEBA

Join us on Wed, Dec 10. at 10AM PST / 1PM EST for a live webinar and demo with Splunk experts! Discover how ...

.conf25 technical session recap of Observability for Gen AI: Monitoring LLM ...

If you’re unfamiliar, .conf is Splunk’s premier event where the Splunk community, customers, partners, and ...

A Season of Skills: New Splunk Courses to Light Up Your Learning Journey

There’s something special about this time of year—maybe it’s the glow of the holidays, maybe it’s the ...