Groups > microsoft.public.sqlserver.programming > #31307

Re: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

Newsgroups	microsoft.public.sqlserver.programming
Date	2016-10-20 22:14 -0700
References	(9 earlier) <Xns9E7683C0CFEA2Yazorman@127.0.0.1> <c0e3fb2b-b3ed-4098-bb79-ff240b4edfd4@r29g2000yqj.googlegroups.com> <Xns9E76A723CDF39Yazorman@127.0.0.1> <9c8c939d-8f9a-401f-a496-2a246a6b5b43@fm22g2000vbb.googlegroups.com> <f63d6166-4db7-402d-8b3e-71596c98a5a1@w2g2000vbp.googlegroups.com>
Message-ID	<a5bfcd6d-5b93-4e3e-8ba7-422fd14493d7@googlegroups.com> (permalink)
Subject	Re: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
From	007kpchowdary@gmail.com

Show all headers | View raw

On Monday, January 24, 2011 at 8:43:12 AM UTC-6, fniles wrote:
> Also, around the same time our network person was on that SQL Server
> machine and was on Windows explorer, and he said Windows Explorer was
> not responding at that time also.
> 
> 
> On Jan 24, 6:38 am, fniles <fiefie.ni...@gmail.com> wrote:
> > I have more information about the problem, because it happened again
> > last night, during a non busy time.
> >
> > We have 3 databases on that SQL Server machine, and multiple different
> > applications (on 3 different machines) connect to those 3 databases.
> > Those applications around the same time got the "Timeout expired"
> > error either when reading a query (different queries on different
> > applications) or opening the database.
> >
> > Meanwhile, another application that connect to a database on a
> > different SQL Server machine didn't get the error.
> >
> > It seems like there is a problem with that SQL Server machine may be ?
> > Like there is a network problem connecting to that SQL Server
> > machine ?
> >
> > On Jan 23, 9:25 am, Erland Sommarskog <esq...@sommarskog.se> wrote:
> >
> >
> >
> > > fniles (fiefie.ni...@gmail.com) writes:
> > > > Although it is a single application, it is using multiple threads,
> > > > each thread for every client that connects to it.
> > > > So, in this case you no longer think it is SQL Server run out of
> > > > worker threads ?
> >
> > > No. My prime guess is that this could be the reason.
> >
> > > But as I said, it's difficult to make a diagnosis of the situation on a
> > > distance. And to be honest, I have not experienced that particular situation
> > > myself, so I mainly rely on what I eavesdropped from discussions elsewhere.
> >
> > > --
> > > Erland Sommarskog, SQL Server MVP, esq...@sommarskog.se
> >
> > > Links for SQL Server Books Online:
> > > SQL 2008:http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
> > > SQL 2005:http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx- Hide quoted text -
> >
> > - Show quoted text -


http://www.sqlpassion.at/archive/2011/10/25/troubleshooting-threadpool-waits/

Back to microsoft.public.sqlserver.programming | Previous | Next | Find similar

Thread

Re: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. 007kpchowdary@gmail.com - 2016-10-20 22:14 -0700

csiph-web