search

PFEDynamics / DynamicsPerf

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

DynamicsPerf SQL Queries are not returning data even though the data is captured in Dynamics Perf Tables #4

Open aravindhakumarreddy opened 6 years ago

aravindhakumarreddy commented 6 years ago

We ran in to a situation where we can see the data is getting captured in DynamicsPerf tables but while execute the queries like " -- EXPENSIVE_QUERIES_BY_TIME_PERIOD

-- EXPENSIVE_QUERIES_HISTORICAL "

It is keep on executing for hours and hours but no results are shown.

Any thoughts on this issue would be very helpful.

Alexander-Weurding commented 6 years ago

Sounds bad. Just drop us an email, here at PerfXit International we will help for free to troubleshoot your problem with DynamicsPerf. Because we also love this tool, and are happy with the people behind it.

Alexander Weurding PerfXit, A Microsoft Dynamics AX Performance and troubleshooting company.

On Thu, Jul 26, 2018 at 9:19 AM, aravindhakumarreddy < notifications@github.com> wrote:

We ran in to a situation where we can see the data is getting captured in DynamicsPerf tables but while execute the queries like " -- EXPENSIVE_QUERIES_BY_TIME_PERIOD

-- EXPENSIVE_QUERIES_HISTORICAL "

It is keep on executing for hours and hours but no results are shown.

Any thoughts on this issue would be very helpful.

— 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/4, or mute the thread https://github.com/notifications/unsubscribe-auth/AFrlpCCz3ccda8eQxcQnpkvHhc4JFzEPks5uKW1mgaJpZM4VhTPW .

-- Groeten Alexander

aravindhakumarreddy commented 6 years ago

Hi Alexander,

Thanks for your reply.

Can you give me the exact email id so that we can drop an email.

Regards, Aravind Reddy.

From: Alexander Weurding - PerfXit AX Performance and Risks notifications@github.com Sent: Friday, July 27, 2018 1:07 PM To: PFEDynamics/DynamicsPerf DynamicsPerf@noreply.github.com Cc: Reddy, Aravindha Kumar AravindhaKumar.Reddy@crowe.com; Author author@noreply.github.com Subject: Re: [PFEDynamics/DynamicsPerf] DynamicsPerf SQL Queries are not returning data even though the data is captured in Dynamics Perf Tables (#4)

Sounds bad. Just drop us an email, here at PerfXit International we will help for free to troubleshoot your problem with DynamicsPerf. Because we also love this tool, and are happy with the people behind it.

Alexander Weurding PerfXit, A Microsoft Dynamics AX Performance and troubleshooting company.

On Thu, Jul 26, 2018 at 9:19 AM, aravindhakumarreddy < notifications@github.commailto:notifications@github.com> wrote:

We ran in to a situation where we can see the data is getting captured in DynamicsPerf tables but while execute the queries like " -- EXPENSIVE_QUERIES_BY_TIME_PERIOD

-- EXPENSIVE_QUERIES_HISTORICAL "

It is keep on executing for hours and hours but no results are shown.

Any thoughts on this issue would be very helpful.

— 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/4, or mute the thread https://github.com/notifications/unsubscribe-auth/AFrlpCCz3ccda8eQxcQnpkvHhc4JFzEPks5uKW1mgaJpZM4VhTPW .

-- Groeten Alexander

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHubhttps://github.com/PFEDynamics/DynamicsPerf/issues/4#issuecomment-408338253, or mute the threadhttps://github.com/notifications/unsubscribe-auth/AnR1NcdV7Q_WfP9PN7W-EjvSV2TZRW7bks5uKsM4gaJpZM4VhTPW.

This email message is from Crowe LLP or one of its subsidiaries and may contain privileged or confidential information or other information exempt from disclosure under applicable law. If you are not the intended recipient, please notify the sender by reply email immediately and delete this message without reading further or forwarding to others. This email is not intended to be a contract or other legally binding obligation, and any tax advice expressed in this email should not be construed as a formal tax opinion unless expressly stated. Visit www.crowe.com/disclosure for more information about Crowe LLP and its subsidiaries.

Alexander-Weurding commented 6 years ago

Hey Aravind,

No problem! Just drop me a line @ Info@PerfXit.com

Best regards Alexander

On Mon, Jul 30, 2018 at 3:58 PM, aravindhakumarreddy < notifications@github.com> wrote:

Hi Alexander,

Thanks for your reply.

Can you give me the exact email id so that we can drop an email.

Regards, Aravind Reddy.

From: Alexander Weurding - PerfXit AX Performance and Risks < notifications@github.com> Sent: Friday, July 27, 2018 1:07 PM To: PFEDynamics/DynamicsPerf DynamicsPerf@noreply.github.com Cc: Reddy, Aravindha Kumar AravindhaKumar.Reddy@crowe.com; Author < author@noreply.github.com> Subject: Re: [PFEDynamics/DynamicsPerf] DynamicsPerf SQL Queries are not returning data even though the data is captured in Dynamics Perf Tables (#4)

Sounds bad. Just drop us an email, here at PerfXit International we will help for free to troubleshoot your problem with DynamicsPerf. Because we also love this tool, and are happy with the people behind it.

Alexander Weurding PerfXit, A Microsoft Dynamics AX Performance and troubleshooting company.

On Thu, Jul 26, 2018 at 9:19 AM, aravindhakumarreddy < notifications@github.commailto:notifications@github.com> wrote:

We ran in to a situation where we can see the data is getting captured in DynamicsPerf tables but while execute the queries like " -- EXPENSIVE_QUERIES_BY_TIME_PERIOD

-- EXPENSIVE_QUERIES_HISTORICAL "

It is keep on executing for hours and hours but no results are shown.

Any thoughts on this issue would be very helpful.

— 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/4, or mute the thread https://github.com/notifications/unsubscribe-auth/ AFrlpCCz3ccda8eQxcQnpkvHhc4JFzEPks5uKW1mgaJpZM4VhTPW .

-- Groeten Alexander

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHubhttps://github.com/ PFEDynamics/DynamicsPerf/issues/4#issuecomment-408338253, or mute the threadhttps://github.com/notifications/unsubscribe- auth/AnR1NcdV7Q_WfP9PN7W-EjvSV2TZRW7bks5uKsM4gaJpZM4VhTPW.

This email message is from Crowe LLP or one of its subsidiaries and may contain privileged or confidential information or other information exempt from disclosure under applicable law. If you are not the intended recipient, please notify the sender by reply email immediately and delete this message without reading further or forwarding to others. This email is not intended to be a contract or other legally binding obligation, and any tax advice expressed in this email should not be construed as a formal tax opinion unless expressly stated. Visit www.crowe.com/disclosure for more information about Crowe LLP and its subsidiaries.

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/PFEDynamics/DynamicsPerf/issues/4#issuecomment-408872858, or mute the thread https://github.com/notifications/unsubscribe-auth/AFrlpOSrFO8-6bXU4KS_uTuJ9buPRV32ks5uLxEHgaJpZM4VhTPW .

-- Groeten Alexander

jaestevan commented 5 years ago

Hi,

Please double check you have properly executed the AOTExport class within AX. This class populates some tables in DynamicsPerf database that are then joined with stats tables on the provided analysis views.

If these tables (like AX_TABLE_DETAIL) are empty, the joined query will return no records.

Hope this helps,

JA.