topic Re: Why is the accelerated Data Model performing slow? in Reporting

Why is the accelerated Data Model performing slow?

vaibhavagg2006 — Mon, 29 Jan 2018 05:58:35 GMT

I have an accelerated data model which is performing very slow. It takes more than 2 minutes to return just count of events and more than 4 minutes to do any statistical functions. For example below query takes 121 seconds to run:-

|tstats count from datamodel=mydatamodel where (nodename=mydatamodel.logs) (mydatamodel.tag=prod) groupby "mydatamodel.transactionID"

This returned around 4 Million rows after scanning 12 M events. Is there anything I can do to improve the performance. We have a search head cluster with good configuration and around 13 indexers.

Re: Why is the accelerated Data Model performing slow?

esix_splunk — Mon, 29 Jan 2018 08:08:49 GMT

What are the terms of the acceleration? Is it actually accelerated? You can check on the status of the data model in your Management Console, or in the Data Model Audit Dashboard of CIM (if you're using it..)

It's worth noting that your accelerated data exists on the indexers, and not on the SHC. If your indexers are facing anytype of I/o, Memory, or CPU contention, then this can effect performance of your data model.

Additionally, the structure of your data model can also adversely effect performance. Whats the time span youre searching over? If you adjust the timespan down, how does it effect the search performance?

Re: Why is the accelerated Data Model performing slow?

vaibhavagg2006 — Mon, 29 Jan 2018 08:54:31 GMT

Yes, the data model is accelerated for last 30 days.
Indexers are ok in terms of resources, this slowness is consistent and query takes same time to run across the day.
I am searching for "Yesterday". The event count I mentioned(12 M) is for 1 day. The logs are in key value formatl

Re: Why is the accelerated Data Model performing slow?

esix_splunk — Mon, 29 Jan 2018 09:10:14 GMT

Did you confirm that the data is actually accelerated via MC or DM Audit Dashboard? This is a key thing to confirm. If your data model acceleration is not completing or working properly, then your tstats search just search against the raw data, which would give you a search time similar to normal search performance.

Whats the base search of your data models look like?

Can you check search log and see where the most process time is spent?

Re: Why is the accelerated Data Model performing slow?

vaibhavagg2006 — Mon, 29 Jan 2018 11:48:44 GMT

Yes, I checked the acceleration is fine.
It is taking maximum time in "command.tstats" and then "dispatch.stream.remote". Under "command.tstats" most of the time is taken by "command.tstats.query_tsidx"
Just curious what is invocations in the job inspector. It says 623 for "Command.tstats" and around 25 for each indexer.

Re: Why is the accelerated Data Model performing slow?

esix_splunk — Mon, 29 Jan 2018 12:53:33 GMT

Is that streaming command equally spread across your indexers, or do you have one or two indexers that are taking longer then others?

Dispatch stream taking a lot of time could reflect indexer performance issues, especially around I/o. How are your normal searches running? What if you run tstats against the index instead of the DM.

Circling back to the data model, what kind of events are fitting into the DM? And what’s the base search look like?

Re: Why is the accelerated Data Model performing slow?

vaibhavagg2006 — Tue, 29 Sep 2020 17:58:12 GMT

Yes the streaming command is equally spread. All the indexers and almost taking equal time.

My base search looks like something below ::
"index=idx1 (sourcetype=abc transactionID=) OR (sourcetype=xyz ("some search string") ) OR (sourcetype=blah (*search string))"

Also i tried to run normal index search vs tstats against accelerated data model for same set of data.
The response time is 168 seconds vs 138 seconds.
Event count:-19,821,855

Not able to run tstats against the index as I dont have indexed fields on which I am trying to group by

Re: Why is the accelerated Data Model performing slow?

micahkemp — Wed, 07 Feb 2018 14:30:08 GMT

If the datamodel is accelerated, you can use summariesonly=t to only search the accelerated data:

|tstats summariesonly=t count from datamodel=mydatamodel where (nodename=mydatamodel.logs) (mydatamodel.tag=prod) groupby "mydatamodel.transactionID"

This should result in a faster search.

Re: Why is the accelerated Data Model performing slow?

robertlynch2020 — Fri, 02 Nov 2018 14:42:53 GMT

Did you get an answer to your question above as i am also have performance issues with | tstats