Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

What does send sleep mean in Sybase central(processes)

6 posts in Windows NT Last posting was on 2000-01-15 15:22:24.0Z
shankar kamath Posted on 2000-01-08 17:50:11.0Z
Message-ID: <387778D2.E3F662DB@worldnet.att.net>
Date: Sat, 08 Jan 2000 11:50:11 -0600
From: shankar kamath <shankarkamathv@worldnet.att.net>
X-Mailer: Mozilla 4.5 [en] (Win98; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: What does send sleep mean in Sybase central(processes)
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 8
NNTP-Posting-Host: 64.detroit-04.mi.dial-access.att.net 12.67.147.64
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2728
Article PK: 1090164

Hi all,

I am using Delphi4.0 with sybase(11.5). In my application, users search
for records very offten( generally a simple select statement with where
caluse) and very frequently user's machine freeze. Sybase central
processes shows status as
'send sleep'. command :SELECT

Appreciate your helps


Eric McGrane Posted on 2000-01-10 15:01:00.0Z
Message-ID: <3879F42C.55B4AE2F@sybase.com>
Date: Mon, 10 Jan 2000 10:01:00 -0500
From: Eric McGrane <mcgrane@sybase.com>
Organization: Sybase, Inc.
X-Mailer: Mozilla 4.7 [en]C-CCK-MCD (WinNT; I)
X-Accept-Language: en
MIME-Version: 1.0
To: shankar kamath <shankarkamathv@worldnet.att.net>
Subject: Re: What does send sleep mean in Sybase central(processes)
References: <387778D2.E3F662DB@worldnet.att.net>
Content-Type: multipart/mixed; boundary="------------2DBDB777DF33027D09859AEB"
Newsgroups: sybase.public.sqlserver.nt
Lines: 38
NNTP-Posting-Host: mcgrane-nt.sybase.com 157.133.126.171
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2724
Article PK: 1090162

Shankar,

send/recv sleep indicate that a client has been put into the sleep queue and
is either waiting for a tds packet from the server, send sleep, or the
server is waiting for a packet from the client, recv sleep.

So, if you see many clients in send sleep, this indicates that they are
sleeping waiting for the server to send them a packet.

E

shankar kamath wrote:

> Hi all,
>
> I am using Delphi4.0 with sybase(11.5). In my application, users search
> for records very offten( generally a simple select statement with where
> caluse) and very frequently user's machine freeze. Sybase central
> processes shows status as
> 'send sleep'. command :SELECT
>
> Appreciate your helps


Download VCard mcgrane.vcf


shankar kamath Posted on 2000-01-11 00:23:09.0Z
Message-ID: <387A77ED.E7BB271@worldnet.att.net>
Date: Mon, 10 Jan 2000 18:23:09 -0600
From: shankar kamath <shankarkamathv@worldnet.att.net>
X-Mailer: Mozilla 4.5 [en] (Win98; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: What does send sleep mean in Sybase central(processes)
References: <387778D2.E3F662DB@worldnet.att.net> <3879F42C.55B4AE2F@sybase.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 25
NNTP-Posting-Host: 31.detroit-04.mi.dial-access.att.net 12.67.147.31
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2719
Article PK: 1090178

Hi Eric
How can we resolve this send sleep condition ? If I view from windows NT
event viewer, it
says "120191 : Can not send. host process disconnected"
Please help


Shankar

Eric McGrane wrote:

> Shankar,
>
> send/recv sleep indicate that a client has been put into the sleep queue and
> is either waiting for a tds packet from the server, send sleep, or the
> server is waiting for a packet from the client, recv sleep.
>
> So, if you see many clients in send sleep, this indicates that they are
> sleeping waiting for the server to send them a packet.
>
> E
>
> shankar kamath wrote:
>
> > Hi all,
> >
> > I am using Delphi4.0 with sybase(11.5). In my application, users search
> > for records very offten( generally a simple select statement with where
> > caluse) and very frequently user's machine freeze. Sybase central
> > processes shows status as
> > 'send sleep'. command :SELECT
> >
> > Appreciate your helps


Eric McGrane Posted on 2000-01-11 14:06:13.0Z
Message-ID: <387B38D5.6DFF4DD2@sybase.com>
Date: Tue, 11 Jan 2000 09:06:13 -0500
From: Eric McGrane <mcgrane@sybase.com>
Organization: Sybase, Inc.
X-Mailer: Mozilla 4.7 [en]C-CCK-MCD (WinNT; I)
X-Accept-Language: en
MIME-Version: 1.0
To: shankar kamath <shankarkamathv@worldnet.att.net>
Subject: Re: What does send sleep mean in Sybase central(processes)
References: <387778D2.E3F662DB@worldnet.att.net> <3879F42C.55B4AE2F@sybase.com> <387A77ED.E7BB271@worldnet.att.net>
Content-Type: multipart/mixed; boundary="------------E669DCD608E63980ECF94B1E"
Newsgroups: sybase.public.sqlserver.nt
Lines: 68
NNTP-Posting-Host: mcgrane-nt.sybase.com 157.133.126.171
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2712
Article PK: 1090177

Shankar,

The fact that you are seeing messages in the log like can not send host process
disconnected means that the clients "at the other end of the line" are no longer
there. I am guessing that your clients are pc clients and they are getting
impatient and rebooting. The result is that ASE has no idea the client has gone
away until it actually tries to communicate with the client, when it does you get
the 'host process disconnected message'.

I would first educate the users to not be so impatient and explain the
ramifications of rebooting. If they are experiencing performance problems those
problems need to be reported to the dba and investigated to understood. Only then
will this be resolved.

I am sorry I can't give you the real answer you are looking for. I can only point
you in the right direction at this time.

E

shankar kamath wrote:

> Hi Eric
> How can we resolve this send sleep condition ? If I view from windows NT
> event viewer, it
> says "120191 : Can not send. host process disconnected"
> Please help
>
> Shankar
>
> Eric McGrane wrote:
>
> > Shankar,
> >
> > send/recv sleep indicate that a client has been put into the sleep queue and
> > is either waiting for a tds packet from the server, send sleep, or the
> > server is waiting for a packet from the client, recv sleep.
> >
> > So, if you see many clients in send sleep, this indicates that they are
> > sleeping waiting for the server to send them a packet.
> >
> > E
> >
> > shankar kamath wrote:
> >
> > > Hi all,
> > >
> > > I am using Delphi4.0 with sybase(11.5). In my application, users search
> > > for records very offten( generally a simple select statement with where
> > > caluse) and very frequently user's machine freeze. Sybase central
> > > processes shows status as
> > > 'send sleep'. command :SELECT
> > >
> > > Appreciate your helps


Download VCard mcgrane.vcf


Dee Roghelia Posted on 2000-01-11 14:35:12.0Z
From: "Dee Roghelia" <droghelia@ciber.com>
References: <387778D2.E3F662DB@worldnet.att.net> <3879F42C.55B4AE2F@sybase.com> <387A77ED.E7BB271@worldnet.att.net> <387B38D5.6DFF4DD2@sybase.com>
Subject: Re: What does send sleep mean in Sybase central(processes)
Date: Tue, 11 Jan 2000 09:35:12 -0500
Lines: 101
Organization: Ciber
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
Message-ID: <11zTmGEX$GA.177@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: 38.208.177.36
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2710
Article PK: 1090172

My client has had a very similar situation that has been occurring since
September on ASE 11.5 on NT SP4. A stored procedure that is frequently run,
locks while the user processes sit in a "send sleep" state; in our case, the
data is never returned (we have let it go for over 1 hour on a stored
procedure that should return results in 5 seconds). And no matter how much
we have tried to train the users not to reboot, they do anyway. This seems
to make the server even more bogged down because it is trying to clean up
these processes once it determines that they have been disconnected. The
problem is also intermittent. It seems to get worse as more users log on to
the system.

We resorted to calling Sybase Professional Services in November. Once at my
client's site, a couple of things the Consultant tried was first to increase
the amount of memory for the OS. Then we added an entry to the NT registry
for the Keep Alive setting, which will help detect client disconnects
(Document ID 611 on Sybase's site). The default for this type of checking
on most platforms is 2 hours. We also upgraded ASE to 11.5.1 and then
applied SWR 8608, which includes a fix for Bug 187326: "Unexpected client
disconnect (eg due to network error or client dying) can leave 'orphan'
process on ASE." These fixes did help reduce the problem but the Sybase
Consultant suggested we apply NT SP5, which deals with tcp/ip issues that
may be causing our problem. We are currently waiting for this request to be
approved by my client.

I hope this helps. Good Luck! This type of situation can be very
frustrating for you and your users!!!

Dee Roghelia

Eric McGrane <mcgrane@sybase.com> wrote in message
news:387B38D5.6DFF4DD2@sybase.com...
> Shankar,
>
> The fact that you are seeing messages in the log like can not send host
process
> disconnected means that the clients "at the other end of the line" are no
longer
> there. I am guessing that your clients are pc clients and they are
getting
> impatient and rebooting. The result is that ASE has no idea the client
has gone
> away until it actually tries to communicate with the client, when it does
you get
> the 'host process disconnected message'.
>
> I would first educate the users to not be so impatient and explain the
> ramifications of rebooting. If they are experiencing performance problems
those
> problems need to be reported to the dba and investigated to understood.
Only then
> will this be resolved.
>
> I am sorry I can't give you the real answer you are looking for. I can
only point
> you in the right direction at this time.
>
> E
>
> shankar kamath wrote:
>
> > Hi Eric
> > How can we resolve this send sleep condition ? If I view from
windows NT
> > event viewer, it
> > says "120191 : Can not send. host process disconnected"
> > Please help
> >
> > Shankar
> >
> > Eric McGrane wrote:
> >
> > > Shankar,
> > >
> > > send/recv sleep indicate that a client has been put into the sleep
queue and
> > > is either waiting for a tds packet from the server, send sleep, or the
> > > server is waiting for a packet from the client, recv sleep.
> > >
> > > So, if you see many clients in send sleep, this indicates that they
are
> > > sleeping waiting for the server to send them a packet.
> > >
> > > E
> > >
> > > shankar kamath wrote:
> > >
> > > > Hi all,
> > > >
> > > > I am using Delphi4.0 with sybase(11.5). In my application, users
search
> > > > for records very offten( generally a simple select statement with
where
> > > > caluse) and very frequently user's machine freeze. Sybase central
> > > > processes shows status as
> > > > 'send sleep'. command :SELECT
> > > >
> > > > Appreciate your helps
>


Gary Estridge Posted on 2000-01-15 15:22:24.0Z
From: "Gary Estridge" <aaaa@aaaa.com>
References: <387778D2.E3F662DB@worldnet.att.net> <3879F42C.55B4AE2F@sybase.com> <387A77ED.E7BB271@worldnet.att.net> <387B38D5.6DFF4DD2@sybase.com> <11zTmGEX$GA.177@forums.sybase.com>
Subject: Re: What does send sleep mean in Sybase central(processes)
Date: Sat, 15 Jan 2000 10:22:24 -0500
Lines: 129
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6600
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
Message-ID: <aL6Zt02X$GA.303@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: 188.orlando-01-02rs.fl.dial-access.att.net 12.77.192.188
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2678
Article PK: 1090119

Hello Dee. The reason we increased the memory for the OS was there was
frequent page faulting that was occurring on the NT server, it really didn't
have anything to do with the disconnects that were occurring. We gave the
OS more memory to work with which stopped all the page faulting that was
going on. Page faulting can seriously degrade server performance. All of
the other items you mentioned are the things he should check out.

Gary Estridge
Sr. Consultant
Sybase Professional Services

"Dee Roghelia" <droghelia@ciber.com> wrote in message
news:11zTmGEX$GA.177@forums.sybase.com...
> My client has had a very similar situation that has been occurring since
> September on ASE 11.5 on NT SP4. A stored procedure that is frequently
run,
> locks while the user processes sit in a "send sleep" state; in our case,
the
> data is never returned (we have let it go for over 1 hour on a stored
> procedure that should return results in 5 seconds). And no matter how
much
> we have tried to train the users not to reboot, they do anyway. This
seems
> to make the server even more bogged down because it is trying to clean up
> these processes once it determines that they have been disconnected. The
> problem is also intermittent. It seems to get worse as more users log on
to
> the system.
>
> We resorted to calling Sybase Professional Services in November. Once at
my
> client's site, a couple of things the Consultant tried was first to
increase
> the amount of memory for the OS. Then we added an entry to the NT
registry
> for the Keep Alive setting, which will help detect client disconnects
> (Document ID 611 on Sybase's site). The default for this type of checking
> on most platforms is 2 hours. We also upgraded ASE to 11.5.1 and then
> applied SWR 8608, which includes a fix for Bug 187326: "Unexpected client
> disconnect (eg due to network error or client dying) can leave 'orphan'
> process on ASE." These fixes did help reduce the problem but the Sybase
> Consultant suggested we apply NT SP5, which deals with tcp/ip issues that
> may be causing our problem. We are currently waiting for this request to
be
> approved by my client.
>
> I hope this helps. Good Luck! This type of situation can be very
> frustrating for you and your users!!!
>
> Dee Roghelia
>
>
> Eric McGrane <mcgrane@sybase.com> wrote in message
> news:387B38D5.6DFF4DD2@sybase.com...
> > Shankar,
> >
> > The fact that you are seeing messages in the log like can not send host
> process
> > disconnected means that the clients "at the other end of the line" are
no
> longer
> > there. I am guessing that your clients are pc clients and they are
> getting
> > impatient and rebooting. The result is that ASE has no idea the client
> has gone
> > away until it actually tries to communicate with the client, when it
does
> you get
> > the 'host process disconnected message'.
> >
> > I would first educate the users to not be so impatient and explain the
> > ramifications of rebooting. If they are experiencing performance
problems
> those
> > problems need to be reported to the dba and investigated to understood.
> Only then
> > will this be resolved.
> >
> > I am sorry I can't give you the real answer you are looking for. I can
> only point
> > you in the right direction at this time.
> >
> > E
> >
> > shankar kamath wrote:
> >
> > > Hi Eric
> > > How can we resolve this send sleep condition ? If I view from
> windows NT
> > > event viewer, it
> > > says "120191 : Can not send. host process disconnected"
> > > Please help
> > >
> > > Shankar
> > >
> > > Eric McGrane wrote:
> > >
> > > > Shankar,
> > > >
> > > > send/recv sleep indicate that a client has been put into the sleep
> queue and
> > > > is either waiting for a tds packet from the server, send sleep, or
the
> > > > server is waiting for a packet from the client, recv sleep.
> > > >
> > > > So, if you see many clients in send sleep, this indicates that they
> are
> > > > sleeping waiting for the server to send them a packet.
> > > >
> > > > E
> > > >
> > > > shankar kamath wrote:
> > > >
> > > > > Hi all,
> > > > >
> > > > > I am using Delphi4.0 with sybase(11.5). In my application, users
> search
> > > > > for records very offten( generally a simple select statement with
> where
> > > > > caluse) and very frequently user's machine freeze. Sybase
central
> > > > > processes shows status as
> > > > > 'send sleep'. command :SELECT
> > > > >
> > > > > Appreciate your helps
> >
>
>