CitrixDude
Active Member
Calling all SQL Gurus!!!!
We just upgraded from XE to 8.10 and we are having excessive blocking occurring in SQL. It’s in two sencarios…
1. When users are in P4210 and they hit the "Place Order" button the screen flickers and you are left with a gray box. At this point the client is locked up. If I go into Current Activity in Enterprise Manager I see PIDs that are blocking one another. If I look at the process detail they are on sp_cursors. As soon as I kill the lock the client unfreezes and the transaction rolls back. When I turn debug on I can’t duplicate the issue!!!!!
2. OMW – when a user tries to add a version to a project the blocking is happening in here too.
I opened a case with GSS and they have been sitting on the issue for a week. Any have any thoughts?
Dave
8.10 8.95C1 U1, Win2K3 SP1, SQL2K SP3a Cluster, SAN, Citrix XP
We just upgraded from XE to 8.10 and we are having excessive blocking occurring in SQL. It’s in two sencarios…
1. When users are in P4210 and they hit the "Place Order" button the screen flickers and you are left with a gray box. At this point the client is locked up. If I go into Current Activity in Enterprise Manager I see PIDs that are blocking one another. If I look at the process detail they are on sp_cursors. As soon as I kill the lock the client unfreezes and the transaction rolls back. When I turn debug on I can’t duplicate the issue!!!!!
2. OMW – when a user tries to add a version to a project the blocking is happening in here too.
I opened a case with GSS and they have been sitting on the issue for a week. Any have any thoughts?
Dave
8.10 8.95C1 U1, Win2K3 SP1, SQL2K SP3a Cluster, SAN, Citrix XP