You’re offline. This is a read only version of the page.
75,730
What causes records to be written to the TEMPDB..DEX_SESSION and TEMPDB..DEX_LOCK tables? I am trying to diagnose why one of clients keeps getting struck batches and other activity related messages. When I do the check there are left over session IDs in these tables. Now I just did the usual check and there are two users in the ACTIVITY table but no records in either of these tables.Does the user need to have a transaction screen or report open to create session IDs?
Thank you, Andrea. For this instance that is exactly what happened. They are on the west coast and I am on the east coast. I had checked around 7am EDT this morning. Only one user was in GP and the only table with a record was DYNAMICS..ACTIVITY.
Hi Richard,
As soon as a user logs into GP, I would expect to see a record for that in the TEMPDB..DEX_SESSION table. I would expect that record to remain in place while the user is logged into GP.
The TEMPDB..DEX_LOCK table gets used for a plethora of different processes, basically anything that requires a record to be locked (that could entail entry/saving/posting/etc.).
The fact that you are finding records in the ACTIVITY table, but not in the TEMPDB tables (especially the TEMPDB_DEX_SESSION) indicates that the user is likely loosing connection with SQL prior to when he/she logs out of GP. This can happen when users leave GP open overnight (or for a long period of time) and when there is some type of ‘power save’ option in place (hibernate/sleep) that will cause SQL to auto close inactive connections (this includes the TEMPDB tables).
I’ve attached the Microsoft Dynamics GP White Paper here for you, and #5 on Page 19 talks about Power Save Options in conjunction with the TEMPDB tables.
MDGP_5F00_WhitePaper_5F00_Performance.docx
I hope this helps!
Thank you for using Microsoft Dynamics Communities,
Andrea Melroe | Sr. Technical Advisor | Microsoft Dynamics GP
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (