Response time of Stats2.aspx

Tomas Gomez

Posted on 27/05/2021 10:04:34

Hi,

When viewing a page on a browser, the Stats2.aspx task has a response time that hugely exceeds the other tasks. In our case, this response time can be up to 5-10 seconds, see attached image.

We cleaned the database with these instructions, but still there is this lag.
DELETE FROM StatV2Object WHERE STATV2OBJECTTIMESTAMP <= '01-02-2021 00:00:00'
DELETE FROM Statv2Session WHERE STATV2SESSIONTIMESTAMP <= '01-02-2021 00:00:00'

Is the any other way to reduce or eliminate the response time of this tasks?

Regards,
Tomas

Replies

Shiwanka Chathuranga

Posted on 28/05/2021 13:10:57

which version of DW?

Nicolai Pedersen

Posted on 28/05/2021 13:51:12

This post has been marked as an answer

Check your statv2* tables for database indexes. It could be that they are missing or needs to be defragmented.

Votes for this answer: 1

Tomas Gomez

Posted on 31/05/2021 09:32:13

Hi,

Our solution is DW 9.9.6

About the database indexes, the solution is located at DW so we don't have access to the database management. We will ask support to check it., thanks for the advise.

Regards,
Tomas

Tomas Gomez

Posted on 31/05/2021 12:28:32

Hi again,

If somebody is facing same issue and besides Nicolai solution, another alternative is to deactivate those stats in Settings > Web and HTTP > Tracking > Enable statistics

Regards,
Tomas

You must be logged in to post in the forum

Developer forum

Response time of Stats2.aspx

Replies