You’re offline. This is a read only version of the page.
2,410
Over the last 5 days we've had postings lock up GP 4 times. It cascades to where several other users receive very poor performance in GP. It has happened to two users so far.
When I check SQL Activity Monitor I see that there is a lock on the master database from the locked up user's SQL login, and it's blocking the other user's processes. Once I kill that process in SQL the batch is fine and so are the other users.
Sales batches get posted several times a day and only a handful have had this happen.
Any suggestions for tracking down the cause?
*This post is locked for comments
Yes, the GP processes were blocked by the process from the connection to the Master database.
It's on version 11.00.2164, we rebooted the Sunday before, and did again this weekend.
The locks were on the master database? Is it always the same user(s)? Has anything change in your environment? When was the last time this server was rebooted?
Thank you, I did that and it was the users's session to the master database. When I ran a trace on the session it didn't return anything. I then killed the process and the blocks were removed.
Your first port of call is to run in SSMS.
select * from sys.dm_exec_requests
where blocking_session_id <> 0 -- Session_id is the session that is locked and block_sssion_id is the session doing the blocking
This will return the sessions that are being blocked, and the sessions that are blocking them.
Once you have these:
select * from sys.sysprocesses
where spid = (select blocking_session_id from sys.dm_exec_requests
where blocking_session_id <> 0)
Hopefully this will track you down to the user and then find out what that user is doing.
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,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (