RE: Web page not responding
From: trinitypete (trinitypete_at_online.nospam)
Date: 12/03/04
- Next message: Kevin Spencer: "Re: Help with design"
- Previous message: Amstaff: "Re: Passing Form Data"
- In reply to: Brian Brown: "RE: Web page not responding"
- Next in thread: WJ: "Re: Web page not responding"
- Reply: WJ: "Re: Web page not responding"
- Reply: Brian Brown: "RE: Web page not responding"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 3 Dec 2004 11:53:02 -0800
Hi Brian,
Thanks for the reply, although I dont think it is locking, as it can happen
with only one active user on the system. Plus the behaviour is apparent with
any update to any table. ie. by selecting different updates on different
pages each effecting different tables. SQL current activity -->processes
did't show any blocking.
Although I will try and ascertain what SQL is doing at the time of the
timeout. My initial thought was a a .NET connection leak (ie. haddent been
disposed of properly)but looking under current processes I can only see that
there has been 2 processes started for the impersonated user we use for the
SQL access from .NET.
Regards, Pete.
"Brian Brown" wrote:
> Pete,
>
> Have you tried looking at SQL server's current activity at the time of the
> timeout to see exactly what is going on in the database? It sounds to me
> like a record locking problem during the update. I would suggest looking at
> this information (you can use Query Analyzer and sp_who2 to see the current
> processes) to see if the table is being accessed by another query either
> reading or if multiple processes are trying to update that table at the same
> time. From that information you can then look into treating the record
> locking problem (if that is what is wrong) by enabling dirty reads from the
> readers or specifying a table hint on the updating query (e.g. UPDLOCK). You
> can find more information about record locking/blocking problems in SQL
> Server at http://support.microsoft.com/default.aspx?scid=kb;EN-US;224453
>
> I hope that this helps!
>
- Next message: Kevin Spencer: "Re: Help with design"
- Previous message: Amstaff: "Re: Passing Form Data"
- In reply to: Brian Brown: "RE: Web page not responding"
- Next in thread: WJ: "Re: Web page not responding"
- Reply: WJ: "Re: Web page not responding"
- Reply: Brian Brown: "RE: Web page not responding"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
