web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Performance Analyzer f...
Microsoft Dynamics AX (Archived)

Performance Analyzer for Dynamics (DynamicsPerf)

(0) ShareShare
ReportReport
Posted on by Community Member

Dear all,

 I am just wondering if this deploy can works properly in Always On SQL2k14? Any experience about that  would be greatly appreciated!

https://dynamicsperf.codeplex.com/documentation

I've tried to dig for info in the same CodePlex.com site but no success.

Thanks in advance,

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Vilmos Kintera Profile Picture
    Vilmos Kintera 46,149 on at

    You could install the DynamicsPerf DB on the Primary instance and do not make it participate in the AG cluster. Reading index usage statistics and such on the Secondary replica does not make much sense. I do not think DynamicsPerf jobs are prepared to only pull information for writing it in the DB on the non-readonly instance.

    If you have a failover, you have other headaches to worry about I am sure, than whatever DynamicsPerf could collect for you.

    Alternatively you could install DynamicsPerf to collect details on all AG instances separately, have the jobs in a disabled state, and whenever you fail over the Primary, stop the jobs on the old instance and start it in the new. Most likely you could take automated action for that as well for stopping/starting the jobs using T-SQL, like when starting the SQL instance then a stored procedure is executed which has been created by AX to grant TempDB permissions for the AOS account, on the master system DB.

  • Community Member Profile Picture
    Community Member on at

    thanks a lot, it seems reasonable/achievable the second option.

  • Community Member Profile Picture
    Community Member on at

    Hi Vilmos, what about to deploy a single DynamicPerf database in a isolated Virtual Machine and from that server, collect data for all my Always On with AX by using linked servers??

    does it make sense? I dunno

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
CP04-islander Profile Picture

CP04-islander 26

#2
imran ul haq Profile Picture

imran ul haq 8

#3
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 4 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans