Re: SQL Server / ADO.Net : Timeout expired

From: Sam (Sam_at_discussions.microsoft.com)
Date: 06/22/04 

Date: Tue, 22 Jun 2004 08:56:02 -0700

How Do i check this thru enterprise mgr?

"Marina" wrote:

> I don't know how to query for them - though you should be able to find that
> on the web. I usually just use enterprise manager to look at all the
> processes, and this shows which if any are deadlocked.
>
> "Sam" <Sam@discussions.microsoft.com> wrote in message
> news:4E176D5A-BD73-4E87-BB87-7731DAE2E6DE@microsoft.com...
> > Marina,
> > How do I Check for the database-deadlock?
> > Thanx for the reply,
> > Sam
> >
> > "Marina" wrote:
> >
> > > This message can occur due to a database deadlock - are you sure there
> > > aren't any when this is happening?
> > >
> > > "Sam" <Sam@discussions.microsoft.com> wrote in message
> > > news:6A7FDF0F-27E4-48A5-AE33-F03361B87311@microsoft.com...
> > > > Hello,
> > > > I have an Asp.Net Application,which is basically a banking
> application, so
> > > there are millions of records to process. But the funny thing is that I
> am
> > > getting the following error message when I run in my development
> enviornment
> > > (which is most of the time) and in the production enviornment
> (sometimes).
> > > The Error message is mentioned below.This error even occurs when the
> number
> > > of records to retrieve are even is in terms of 100s.
> > > >
> > > > "Timeout expired. The timeout period elapsed prior to completion of
> the
> > > operation or the server is not responding."
> > > >
> > > > This is happening when I try to retrieve data from SQL Server 2000 or
> > > even write to the DB.
> > > >
> > > > I have tried almost everything from setting the,
> > > > 1) CommandObject.CommandTimeout=0,
> > > > 2) Pooling=false in connection string,
> > > > 3) increase IIS timeout,
> > > > 4) Throw the application out of the window!! (well not yet ,
> atleast!!!
> > > :> )
> > > >
> > > > Has anyone faced such a problem before. If so, could someone tell me
> how
> > > to overcome this. Would appreciate a reply A.S.A.P as the client is
> getting
> > > PISSED OFF bcos of this stupid problem!!!
> > > >
> > > > Thanx,
> > > > Sam
> > > >
> > >
> > >
> > >
>
>
>