This one is highly recommended for tracking down a blocking situation.
http://www.sommarskog.se/sqlutil/aba_lockinfo.html
--
Regards,
Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect
:
| Hello Steve,
|
| Thank you for your post!
|
| It appears that this issue is related to your custom database and it is a
| development-related request that would be best addressed in the developer
| newsgroups. The developer newsgroups are located at:
|
|
http://msdn.microsoft.com/newsgroups/default.asp.
|
| For further assistance on this issue, you may want to contact our Develop
| Support Services by telephone so that a dedicated Support Professional can
| assist you further with your request. To obtain the phone numbers for
| specific technology request please take a look at the web site listed
below:
|
|
http://support.microsoft.com/default.aspx?scid=fh;EN-US;PHONENUMBERS.
|
| Your understanding on this will be greatly appreciated.
|
| Having said that, I'd like to provide some general suggestions to
| troubleshoot this type of issues.
|
| 1. You may want to create 2 new tables/forms with same relationship to
test
| if the issue occurs.
|
| 2. Check if the issue occurs with a new forntend/backend database that
| importing the tables from original ones.
|
| 3. Use SQL profiler to capture the query running when the issue occurs. At
| the same time, run "sp_lock" and following script to get details of
| information of process/lock information on the server when the issue
| occurs.
|
|
| WHILE 1=1
| BEGIN
| Select * from master.dbo.sysprocesses
| WAITFOR DELAY '00:00:05'
| END
| GO
|
| You may want to check which kind of lock/blocking occurs on which objects
| (table/index key/page/row).
|
| 4. Check the code related to update action on the form to see if there is
| any related issue.
|
| 5. Check index/primary key/foreign key on tables to make sure they are
| correct.
|
| I have included the following articles for your reference:
|
| 822101 The waittype and lastwaittype columns in the sysprocesses table in
| SQL
|
http://support.microsoft.com/?id=822101
|
| Q224587 INF: Troubleshooting Application Performance with SQL Server
|
http://support.microsoft.com/support/kb/articles/q224/5/87.asp
|
| Resolving blocking problems that are caused by lock escalation in SQL
Server
|
http://support.microsoft.com/?id=323630
|
| TechNet Support WebCast
erformance troubleshooting and analysis in
| Microsoft SQL Server 2000
|
http://support.microsoft.com/?id=838622
|
| Please let us know if you have further concerns on the issue. Have a great
| day!
|
| Best Regards,
|
| Peter Yang
| MCSE2000/2003, MCSA, MCDBA
| Microsoft Online Partner Support
|
| When responding to posts, please "Reply to Group" via your newsreader so
| that others may learn and benefit from your issue.
|
| =====================================================
|
| Business-Critical Phone Support (BCPS) provides you with technical phone
| support at no charge during critical LAN outages or "business down"
| situations. This benefit is available 24 hours a day, 7 days a week to all
| Microsoft technology partners in the United States and Canada.
|
| This and other support options are available here:
|
| BCPS:
|
https://partner.microsoft.com/US/technicalsupport/supportoverview/40010469
|
| Others:
https://partner.microsoft.com/US/technicalsupport/supportoverview/
|
| If you are outside the United States, please visit our International
| Support page:
|
http://support.microsoft.com/default.aspx?scid=/international.aspx.
|
| =====================================================
|
| This posting is provided "AS IS" with no warranties, and confers no
rights.
