Results 1 to 4 of 4

Thread: Database Block

  1. 04-10-2008, 07:35 AM #1
    Aohene
    Aohene is offline Registered User
    Join Date
    Oct 2003
    Posts
    24

    Database Block

    Hello,

    I have been experiencing a lot of blocking activity in my database. My trace results show that the following extended stored procedures sp_prepexec and sp_cursorfetch are executed by both the user causing the block and the user tha is blocked. Any ideas as to how to rectify this situation will be appreciated.

    Regards,

    Albert
    Reply With Quote Reply With Quote
  2. 04-10-2008, 09:56 AM #2
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    You need to find out what did user run that caused blocking.
    Reply With Quote Reply With Quote
  3. 04-11-2008, 03:34 AM #3
    Aohene
    Aohene is offline Registered User
    Join Date
    Oct 2003
    Posts
    24

    Block activity

    Quote Originally Posted by rmiao
    You need to find out what did user run that caused blocking.

    Thanks,

    What I see are the extended stored procedures I listed in my first thread.

    Regards,

    Albert
    Reply With Quote Reply With Quote
  4. 04-11-2008, 09:27 AM #4
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Looks like some app called sql statement. You need get details from app vendor or with trace in profiler.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules