Waits on Cursor:pin S wait on X
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Waits on Cursor:pin S wait on X

  1. #1
    Join Date
    Apr 2001
    Location
    Congleton
    Posts
    258

    Waits on Cursor:pin S wait on X

    We have an application server (message broker), that reads from a message table, and then processes each message. We tried to start another application server to do exactly the same, but we get very high waits on 'Cursorin S wait on X'. Both servers are obviously trying to access the same sql and locking each other out. Does anyone know another solution or workaround to avoid this contention?
    Thanks.
    Regards,
    Sheryl

  2. #2
    Join Date
    May 2002
    Posts
    2,645

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width