Thursday, September 27, 2012

AX 2012 Performance

Tune data access settings

Client Performance Options

Is AX 2012 slower than AX 2009 ?

Collect AX 2012 event traces with Windows Performance Monitor

AX2012 List Pages - Performance Improvement

Tools for monitoring performance [AX 2012]

Plan guides (plan freezing) in SQL Server 2005/2008

Included columns in Dynamics AX 2012


Performance Resource Page for Microsoft Dynamics AX

Performance Monitoring

1- Monitoring performance by using the Query Store
2- Analyse SQL performance issues using SQL Query Store for D365FO
3- Retail Channel performance investigations

White Paper :

Introduction to Programming for Performance in Microsoft Dynamics 2012


Reorganize and Rebuild Indexes

Find the Index fragmentation on Sql Server 2005 / 2008

Database Maintenance Strategies for Dynamics AX

SQL Server Index Defragmentation (Updated)

Auto-Update STATISTICS :

SQL Server Trace Flag 2371 for Dynamics AX

Changes to automatic update statistics in SQL Server – traceflag 2371

Plan Database Storage :

Storage Top 10 Best Practices

Physical Database Storage Design

Performance Analyzer for Microsoft Dynamics :

Performance Analyzer Download

Performance Analyzer for Microsoft Dynamics

Determining Disk Latency with Performance Analyzer for Microsoft Dynamics

Performance Analyzer Reports

Capture Database Blocking with Performance Analyzer for Microsoft Dynamics

Blog Performance

Improving performance in the DynamicsPerf benchmark sample queries

DynamicsPerf Deep Dive – Baselines

Disk Benchmark :

ATTO Disk Benchmark

IOPS measurements

Calculate IOPS in a storage array

Interface decisions: sas, fc, or iscsi?

Wmarow Iops Calculator

Raid Calc

How to Measure Disk IOPS Using PowerShell

Configuration :

Top Tips for Maximizing the Performance Scalability of Dynamics AX 2009 systems on SQL Server 2008

Minor Changes in Database Configuration Checklist for Dynamics AX

AX 2012 - Server Configuration Performance Options Review

Configure SQL Server and storage settings [AX 2012]

SQL 2014 features: Partitioned indexes and memory-optimized tables

Performance Issues :

Do not assume, Benchmark your X++ code

Top 10 issues discovered from Dynamics AX Health Check

Top 10 issues discovered from Dynamics AX Code Review

SQL Server Customer Advisory Team

Collect Your SQL Server Auditing and Troubleshooting Information Automatically

Reporting Performance :

Microsoft Dynamics AX 2012 Reporting - tips how to improve performance

SQL Server Trace :

Technical Post – Microsoft SQL Server Trace Flag 4136

SQL Server Trace Flags for Dynamics AX

How to check for active trace flags on Microsoft SQL Server

Overcoming parameter sniffing issue in Microsoft Dynamics AX 2012-R2 – CU6

Dynamics AX and SQL Server Trace Flags, Quick and Dirty

SQL Server Deadlock :

SQL Server Deadlocks

Handling Deadlocks in SQL Server

Wednesday, September 26, 2012

AX 2012: Forms on opening hide behind in the back

In Dynamics AX 2012, when you open the forms, you might see some of them open behind the other forms. User may get the impression that the form was never opened. This happens if the form opened slowly......

Thursday, September 20, 2012

AX 2012 - Installing Feature pack on CU3


The link below contain useful informations on upgrade from AX 2012 CU2 to AX 2012 Feature Pack CU3.

Installing Feature pack on AX 2012 CU3

Enjoy !


Wednesday, September 19, 2012

AX 2012 - Identifying a user session in SQL Server


In previous versions of Microsoft Dynamics AX, the Online users form contained a column that provided a session process ID (SPID) for each client session. This column was useful for debugging blocked sessions. Specifically, the SPID column was used to find a user session that corresponded to a specific SPID. In Microsoft Dynamics AX 2012, the SPID column is no longer available in the Online users form.
In Microsoft Dynamics AX 2012, information about the user session can be included in the connection context for Microsoft SQL Server. because the inclusion of this information has a small effect on performance, the functionality is not turned on by default.
So, if you want to add again SPID column in the Online users form, you have to :
  1. Click Start, click Run, type regedit in the Open box, and then click OK.
  2. Locate the following registry key:
    HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\services\Dynamics Server\6.0\01\Original (installed configuration)
    The Original (installed configuration) key is the key name for the current server configuration, if the configuration has not been changed from the default. If your system uses a configuration other than the configuration that was originally installed, locate the configuration that is currently active.
  3. Right-click the key, point to New, and then point to String value. Name the new value connectioncontext, and set the value to 1.
  4. Close the registry editor.
  5. Start the Services snap-in, and then restart the Application Object Server (AOS) service.

Find session information

  1. Open Microsoft SQL Server Management Studio.
  2. Run the following query to view all sessions that are related to Microsoft Dynamics AX:
    select cast(context_info as varchar(128)) as ci,* from sys.dm_exec_sessions where program_name like '%Dynamics%'
    The first two items in the ci (connection information) column are the Microsoft Dynamics AX user ID and the session ID.
  3. In the Online users form, you can now identify each session.

Troubleshooting database performance [AX 2012]

 Finding User Sessions from SPID in Dynamics AX 2012


Monday, September 3, 2012

Object Server xx: Internal Error occurred executing stored procedure when creating session for the AOS

Hi Guys

If during the AOS Service starter have the error "Object Server xx:  Internal Error occurred executing stored procedure when creating session for the AOS" means that the Store Procedure CREATESERVERSESSIONS and CREATEUSERSESSIONS are missing in the Database.

At this point you have two solutions :

1- Create the Store manually
2- Install again the AOS service

I prefer the second solution !

Enjoy !