Hi,
Issue -- AX 2012 is very slow and hanging.
Check SQL Server Activity Monitor
Step 1: Go to AX DB SQL Server --> Activity Monitor
--> Processes àFilter for head block
by 1 value and look for session id.
Step 2: Run below query
in master db to find AX Sessions.
|
||
select cast(context_info as varchar(128)) as ci,* from
|
||
sys.dm_exec_sessions where program_name like '%Dynamics%'
Solution
1: Check AX Session id and find user and kill
session or confirm with user to
resolve the issue
Just write KILL Session id i.e KILL 193 in query window to kill session.
https://blog.sqlauthority.com/2010/10/06/sql-server-quickest-way-to-identify-blocking-query-and-resolution-dirty-solution/
Solution
2:
OR Restart the Batch server AOS i.e. AOS in only if Context
Info column is empty.
Solution 3: Go to AX DB SQL Server --> Activity Monitor --> Processes àFilter for head block
by 1 value and look for session id
and Right and Kill Process.
Solution 4: We
can tie sys.dm_exec_sessions to sys.dm_tran_session_transactions to get a
list of the transactions tied to the session and find out the cause by tracing
transactions.
Solution 5:
Find Blocing Session id and Kill it.
SELECT db_name(er.database_id),
er.session_id,
es.original_login_name,
es.client_interface_name,
er.start_time,
er.status,
er.wait_type,
er.wait_resource,
SUBSTRING(st.text, (er.statement_start_offset/2)+1,
((CASE er.statement_end_offset
WHEN -1 THEN DATALENGTH(st.text)
ELSE er.statement_end_offset
END - er.statement_start_offset)/2) + 1) AS statement_text,
er.*
FROM SYS.dm_exec_requests er
join sys.dm_exec_sessions es on (er.session_id = es.session_id)
CROSS APPLY sys.dm_exec_sql_text(er.sql_handle) AS st
where er.session_id in
(SELECT distinct(blocking_session_id) FROM SYS.dm_exec_requests WHERE blocking_session_id > 0)
and blocking_session_id = 0
Performance Troubleshooting |
Comments
Post a Comment