DYNPERF_AX_CONTEXTINFO has significant impact on CPU related tasks

[patrickjolliffe]

We've spent some time troubleshooting an issue, root cause appears to be the like_i_sql_unicode_string filter on DYNPERF_AX_CONTEXTINFO .
More details here:
https://dba.stackexchange.com/questions/230636/sql-server-cpu-issues/230747

[Alexander-Weurding]

Aaah, can you also send me the result of this query https://www.sqlskills.com/blogs/paul/wait-statistics-or-please-tell-me-where-it-hurts/ Best regards Alexander

…

On Thu, Feb 28, 2019 at 10:26 AM pjolliffe ***@***.***> wrote: We've spent some time troubleshooting an issue, root cause appears to be the like_i_sql_unicode_string filter on DYNPERF_AX_CONTEXTINFO . More details here: https://dba.stackexchange.com/questions/230636/sql-server-cpu-issues/230747 — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub <#8>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AFrlpHRCgimEpUyB3U2nYLE2zAvxRKCHks5vR6DhgaJpZM4bWXV-> .

-- Groeten Alexander

[Alexander-Weurding]

You can just contact me directly, Alexander@perfxit.com and don't forget to check our website www.perfxit.com We are always there to help you with the Microsoft Dynamics AX Performance problems ;) On Thu, Feb 28, 2019 at 10:29 AM Alexander Weurding <alexander@weurding.nl> wrote:

…

Aaah, can you also send me the result of this query https://www.sqlskills.com/blogs/paul/wait-statistics-or-please-tell-me-where-it-hurts/ Best regards Alexander On Thu, Feb 28, 2019 at 10:26 AM pjolliffe ***@***.***> wrote: > We've spent some time troubleshooting an issue, root cause appears to be > the like_i_sql_unicode_string filter on DYNPERF_AX_CONTEXTINFO . > More details here: > > https://dba.stackexchange.com/questions/230636/sql-server-cpu-issues/230747 > > — > You are receiving this because you are subscribed to this thread. > Reply to this email directly, view it on GitHub > <#8>, or mute the > thread > <https://github.com/notifications/unsubscribe-auth/AFrlpHRCgimEpUyB3U2nYLE2zAvxRKCHks5vR6DhgaJpZM4bWXV-> > . > -- Groeten Alexander

-- Groeten Alexander

[patrickjolliffe]

Attach as requested. Note we have already disabled all DYNPERF related extended events.
waitstats.zip
You should be able to easily reproduce the problem with testcase I provided on stackexchange