How to check AX 2012 performance issue
Hi Technical, Today, in this post we will share how you can check AX performance issues. There are a bunch of methods you need to follow to check performance of AX, we have shared in a way like most critical to lowest critical so that you can get what you are finding for at the earliest... Please follow the steps... Method 1: At very first, we will check if there is any blocking in the query which is effecting AX performance. a) If you are a DB administrator, run below Query on DB. SET NOCOUNT ON GO SELECT SPID, BLOCKED, REPLACE (REPLACE (T.TEXT, CHAR(10), ' '), CHAR (13), ' ' ) AS BATCH INTO #T FROM sys.sysprocesses R CROSS APPLY sys.dm_exec_sql_text(R.SQL_HANDLE) T GO WITH BLOCKERS (SPID, BLOCKED, LEVEL, BATCH) AS ( SELECT SPID, BLOCKED, CAST (REPLICATE ('0', 4-LEN (CAST (SPID AS VARCHAR))) + CAST (SPID AS VARCHAR) AS VARCHAR (1000)) AS LEVEL, BATCH FROM #T R WHERE (BLOCKED = 0 OR BLOCKED = SPID) AND EXISTS (SELECT * ...