search

PFEDynamics / DynamicsPerf

DynamicsPerf is a performance analysis tool for Microsoft Dynamics AX
Microsoft Public License
75 stars 20 forks source link

DYNPERF_AX_CONTEXTINFO has significant impact on CPU related tasks #8

Open patrickjolliffe opened 5 years ago

patrickjolliffe commented 5 years ago

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 commented 5 years ago

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 notifications@github.com 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 https://github.com/PFEDynamics/DynamicsPerf/issues/8, or mute the thread https://github.com/notifications/unsubscribe-auth/AFrlpHRCgimEpUyB3U2nYLE2zAvxRKCHks5vR6DhgaJpZM4bWXV- .

-- Groeten Alexander

Alexander-Weurding commented 5 years ago

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 notifications@github.com 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 https://github.com/PFEDynamics/DynamicsPerf/issues/8, or mute the thread https://github.com/notifications/unsubscribe-auth/AFrlpHRCgimEpUyB3U2nYLE2zAvxRKCHks5vR6DhgaJpZM4bWXV- .

-- Groeten Alexander

-- Groeten Alexander

patrickjolliffe commented 5 years ago

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