Search Wiki:
Performance Analyzer Version 1.0 for Microsoft Dynamics is a set of scripts to collect and analyze performance information from the database and application tiers of Microsoft Dynamics products.

Version 1.0 includes scripts for Microsoft Dynamics AX.


Last edited Jul 28 2010 at 7:51 PM  by MarkPrazak, version 2
Comments
Manojgramani wrote  Jan 21 2011 at 1:37 PM  
Can you help me in how to asses the data which is got from the performance tool queries.

AdrianN wrote  Jun 6 2011 at 3:10 PM  
I am wondering why wasn't this functionality built on top of Data Collector?!

Supposing that I'm having already the Data Collector configured with an SQL Server AX Database. Which are you recommendations? Should I use the two solutions in parallel, tracking eventually similar data, should I use only Data Collector or the Performance Analyzer?

Could you eventually highlight the differences/commonalities between the two solutions?

VillageBully wrote  Jul 6 2011 at 7:19 AM  
The is a bug/ typo in the 1.01 release, please see more on http://bit.ly/pIMGbV

Oh, forgot love this tool :)

larildsen wrote  Jul 6 2011 at 7:22 AM  
The stored procedure SP_CAPTURESTATS has a bug, that will make the job DYNPERF_Capture_stats to fail with this message:
Incorrect syntax near ','. [SQLSTATE 42000] (Error 102) Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. [SQLSTATE 42000] (Error 319). The step failed.

If you change the line :
,EVENTRENAMEKEY,
To:
,EVENTRENAMEKEY,NULL

It will succeed

Updating...
Page view tracker