-
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
-
You need to find out what did user run that caused blocking.
-
Block activity
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
-
Looks like some app called sql statement. You need get details from app vendor or with trace in profiler.
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
|
|