Action completed successfully, but it took longer than the given threshold

jhanvincent14

does anyone knows what are the possible things that causes this ?

robbonick

Hi,

This is controlled by settings on the NAV Service Tier. Essentially you can configure a threshold for all of the SQL Queries, and if they exceed that threshold, they are logged in the event logs on the server.

https://docs.microsoft.com/en-us/dynamics-nav/monitoring-long-running-sql-queries-event-log

RockWithNAV

Yes actually if you you will go to NAV Service Tier, there'e something called Compression Threshold, You can play with this ans then Crosscheck

jhanvincent14

robbonick wrote: »

Hi,

This is controlled by settings on the NAV Service Tier. Essentially you can configure a threshold for all of the SQL Queries, and if they exceed that threshold, they are logged in the event logs on the server.

https://docs.microsoft.com/en-us/dynamics-nav/monitoring-long-running-sql-queries-event-log

Is there any documentation for this? like how to ? thanks @robbonick

jhanvincent14

RockWithNAV wrote: »

Yes actually if you you will go to NAV Service Tier, there'e something called Compression Threshold, You can play with this ans then Crosscheck

@RockWithNAV hello, my Conpression Threshold is 64, do I need to make it higher or lower ?