Archives
Here is a useful query to check user section that cause blocking / locking. SELECT d1.session_id, d3.[text], d1.login_time, d1.login_name, d2.wait_time, d2.blocking_session_id, d2.cpu_time, d1.memory_usage, d2.total_elapsed_time, d2.reads,d2.writes, d2.logical_reads, d2.sql_handle FROM sys.dm_exec_sessions d1 JOIN sys.dm_exec_requests d2 ON d1.session_id=d2.session_id CROSS APPLY sys.dm_exec_sql_text(d2.sql_handle) d3
The “Query” function in Syteline allows you to use multiple selection criteria to query transaction. The example below show you how to query manual transactions for inventory account in a given date range. Open the “GL posted transaction query” form. Click “Additional Criteria” tab. In the first pull down list, select “Account”. In second pull […]