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

Version 1.15 includes scripts for Microsoft Dynamics AX.

For discussion related to the use and features of DynamicsPerf, please visit our blog: http://blogs.msdn.com/axinthefield





Last edited Jun 11 2012 at 10:21 PM  by MarkPrazak, version 5
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

skaue wrote  May 30 2012 at 1:54 PM  
Where can I download the previous version (v1). It looks like the latest version doesn't support SQL 2005.

RicardoTalbot wrote  Sep 10 2012 at 5:44 PM  
I need Performance Analyzer 1.0 to troubleshoot performance on a system with a SQL Server 2005 back end.

The only version I could find so far is 1.15, which no longer works with SQL Server 2005.

Would anyone have a link to the binaries of 1.0?

Thanks in advance,

Ricardo Talbot
IRISCO

DynamicStuPot wrote  Nov 15 2012 at 8:58 PM  
Hi

While running the first script (1-Create_Core_Objects.sql) to create the database on SQL 2012 I get the following errors,

Msg 207, Level 16, State 1, Procedure SP_CAPTURESTATS_CORE, Line 1427
Invalid column name 'bpool_committed'.
Msg 207, Level 16, State 1, Procedure SP_CAPTURESTATS_CORE, Line 1428
Invalid column name 'bpool_commit_target'.
Msg 207, Level 16, State 1, Procedure SP_CAPTURESTATS_CORE, Line 1429
Invalid column name 'bpool_visible'.
Msg 207, Level 16, State 1, Procedure SP_CAPTURESTATS_CORE, Line 1431
Invalid column name 'single_pages_kb'.
Msg 207, Level 16, State 1, Procedure SP_CAPTURESTATS_CORE, Line 1431
Invalid column name 'multi_pages_kb'.
The module 'SP_CAPTURESTATS' depends on the missing object 'DynamicsPerf.dbo.SP_CAPTURESTATS_CORE'. The module will still be created; however, it cannot run successfully until the object exists.
The module 'SP_CAPTURESTATS' depends on the missing object 'DynamicsPerf.dbo.SP_CAPTURESTATS_AX'. The module will still be created; however, it cannot run successfully until the object exists.
Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install.
Configuration option 'blocked process threshold (s)' changed from 5 to 5. Run the RECONFIGURE statement to install

DynamicStuPot wrote  Nov 15 2012 at 9:35 PM  
Is this tool Designed to work with AX 2012 CU3?

Errors when importing XPO

Warning Message (21:33:45) Illegal value: FieldNum for property ExtendedDataType.
Warning Message (21:33:45) Minor error during import of Table AotIndexFields
Warning Message (21:33:45) Illegal value: TabId for property ExtendedDataType.
Warning Message (21:33:45) Minor error during import of Table AotTableProperties
Warning Message (21:33:45) Illegal value: FieldNum for property ExtendedDataType.
Warning Message (21:33:45) Minor error during import of Table AotIndexFields
Warning Message (21:33:45) Illegal value: TabId for property ExtendedDataType.
Warning Message (21:33:45) Minor error during import of Table AotTableProperties

Darren1111 wrote  Nov 26 2012 at 11:23 AM  
Looking to use Performance Analyzer for Dynamics (DynamicsPerf) with AX2012 and can't find any information on if it is compatible or not. The only server configuration setting that is referenced in the deployment document I am using says the AOS must be started with the "Allow client tracing on Application Object Server instance" checkbox enabled and that is not one of the available options in AX 2012 server configuration utility.

Can you please confirm if this tool will still work with AX 2012 and if so, what are the appropriate settings on the server/client after installing the DynamicsPerf database?

glenturnbull wrote  Dec 5 2012 at 2:39 PM  
Darren111, everything still works on AX 2012 except the xpo file, there will be a new version of DynamicsPerf for AX2012 out in around 1 month or you should be able to obtain a new xpo via Microsoft support. There is no need to have anything set on the aos for client tracing in AX 2012, it's enabled out of the box.

Giacomo wrote  Feb 26 2013 at 12:22 PM  
Hi, I'm having trouble setting up the reporting package. Both in VS2008 and VS2010 it complains about the version of the .rptproj file (project type is not supported by this version of the application).

Giacomo wrote  Feb 26 2013 at 3:38 PM  
Solved by installing BIDS as shared feature and Reporting Services as an instance feature on the local client.

rodhansen wrote  Mar 12 2013 at 12:49 AM  
We have corrected an issue where you may only have 2 records in the QUERY_STATS_CURR_VW. This was caused by an XML processing error. Send an email to Rod.Hansen@microsoft.com requesting the 1.16 query_plans fix and I'll send you the updated stored procedure. The download site will have a new file dated after Mar. 11, 2013 shortly with the fix in it.

glenturnbull wrote  Mar 14 2013 at 1:12 PM  
There was an error when importing the new XPO into AX2012:
"Error in line 15: expected BEGINNODE but found FILETYPE"

It can be resolved by following the advice contained here:
http://community.dynamics.com/ax/f/33/p/73381/134073.aspx

PeterG wrote  Jul 14 2013 at 12:55 PM  
Hi,

I had some trouble running the AOSANALYSIS.VBS with a SQL Server 2008R2 (german version)

The error was: AOSANALYSIS.VBS(139, 9) Microsoft OLE DB Provider for SQL Server: The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.

The prmEvt1 value is formatted as: 2013-07-13 21:29:57
When I run the INSERT command manually in SSMS, I get the same error message.

So i've changed the last line of function cUTC2Lt to: cUTC2Lt = strDate & "T" & strTime
After that the import worked fine.

davidm wrote  Feb 26 at 12:14 PM  
Hi,
I have downloaded performance analyzer version 1.16 for Microsoft Dynamics. I am following the "Performance Analyzer for Dynamics Deployment and USer Guide" PDF and want to Configure and Schedule AOT Metadata capture. I am unable to locate PrivateProject_AOTExport_Batch.xpo as referred to Configure and Schedule AOT Metadata Capture / Step 4 in the download contents. Is this available to download ? If not, are there updated instructions for this step ? Thanks for any advice you can provide.

davidm wrote  Feb 26 at 1:50 PM  
Hi, checked in release 1.15. The xpo name changed between releases to AOTExport.xpo in 1.16, so sorted.

DilipMehta wrote  Apr 3 at 5:27 PM  
Hi,
While running AOSANALYSIS.VBS , i get error <null>: 0x80041002
I think, the error comes on following statement in the vbs script. It went thro' first AOS1, and uploaded events in DynamicsPerf. But when it loop for 2nd AOS, it resulted in error.

Set objWMIService = GetObject("winmgmts:{impersonationLevel=impersonate}!\\" & strAOS & "\root\cimv2")

Our client environment is AX 2009, SQL server 2009, DynamicsPerf1.16 for SQL2008, Windows Server 2008 R2.

Any suggestions?

Regards
Dilip

Updating...
Page view tracker