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.

SMP hangs server

4 posts in Windows NT Last posting was on 1997-09-30 14:13:14.0Z
Matt Van Rensburg Posted on 1997-09-03 14:38:44.0Z
Message-ID: <340D7674.581C@usa.net>
Date: Wed, 03 Sep 1997 15:38:44 +0100
From: Matt Van Rensburg <mattvan@usa.net>
Reply-To: mattvan@usa.net
Organization: Exabyte
X-Mailer: Mozilla 3.0 (WinNT; I)
MIME-Version: 1.0
Subject: SMP hangs server
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 27
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5558
Article PK: 1081633

Hi All

We recently successfully upgraded to System11. After we were happy that
the server was stable and the clients were running without any problems
we decided to look at ways to improve the performance of the server.

The first thing we did was to gather info on the current server usage
(sp_sysmon). We saw that the server cpu usage was very high and decided
to add another engine to spread the load.
Everything looked great and looking at sp_sysmon showed that the load
was being spread across both engines, but since we did this, our server
has hung twice and we have had to reboot the server. I was unable to
shutdown the server by logging in with isql to shutdown or the NT sql
services manager to shutdown sybase. The NT sql services manager told me
it was unable to stop the server.

We are running sybase11.0.1 on NT4.0 svcpack3.
The server is a compaq proliant 4500 5/100 with 256mb memory and 2 x
P100mhz engines.

Has anybody experienced this problem or have any ideas what could be
wrong.

Thanks
Matt Van Rensburg


Achmad Taufik Firdaus Posted on 1997-09-30 05:30:56.0Z
From: "Achmad Taufik Firdaus" <taufik@tpi.ccmail.compuserve.com>
Subject: Re: SMP hangs server
References: <340D7674.581C@usa.net>
Message-ID: <01bccd6a$e40520a0$9f0000c0@atf.tugu.co.id>
X-Newsreader: Microsoft Internet News 4.70.1161
Newsgroups: sybase.public.sqlserver.nt
Date: Tue, 30 Sep 1997 01:30:56 -0400
Lines: 45
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5497
Article PK: 1081577

I had the same problem with different NOS version (WinNT 3.51 w/ SP#5)
and Sybase System 11.0.1

I think I know the problem:
When using ISQL for data query and then I'm press Cancel/Abort button while
the process still run then Sybase Server wil hung or when the client/user
reset (Ctrl+Alt+Del) the computer while the application that connect to
Sybase Server still running.
For the time being my solution is: whenever the client wants to cancel the
query the client has to contact the DBA tol kill the process.

Does anybody has another solution???!!!!

Taufik

Matt Van Rensburg <mattvan@usa.net> wrote in article
<340D7674.581C@usa.net>...
> Hi All
>
> We recently successfully upgraded to System11. After we were happy that
> the server was stable and the clients were running without any problems
> we decided to look at ways to improve the performance of the server.
>
> The first thing we did was to gather info on the current server usage
> (sp_sysmon). We saw that the server cpu usage was very high and decided
> to add another engine to spread the load.
> Everything looked great and looking at sp_sysmon showed that the load
> was being spread across both engines, but since we did this, our server
> has hung twice and we have had to reboot the server. I was unable to
> shutdown the server by logging in with isql to shutdown or the NT sql
> services manager to shutdown sybase. The NT sql services manager told me
> it was unable to stop the server.
>
> We are running sybase11.0.1 on NT4.0 svcpack3.
> The server is a compaq proliant 4500 5/100 with 256mb memory and 2 x
> P100mhz engines.
>
> Has anybody experienced this problem or have any ideas what could be
> wrong.
>
> Thanks
> Matt Van Rensburg
>


Sri Rejeki Posted on 1997-09-30 06:08:29.0Z
From: "Sri Rejeki" <sri@tpi.ccmail.compuserve.com>
Subject: Re: SMP hangs server
References: <340D7674.581C@usa.net>
Message-ID: <01bccd67$3b0462c0$c90000c0@sra.tugu.co.id>
X-Newsreader: Microsoft Internet News 4.70.1155
Newsgroups: sybase.public.sqlserver.nt
Date: Tue, 30 Sep 1997 02:08:29 -0400
Lines: 61
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5496
Article PK: 1081578

Hi Matt

We have experience the same problem as you do after we successfully
upgraded to System 11.0.1. except that the System 11 is running on NT3.51
svcpack5 and the server is Compaq proliant 4500 using 4 processors, memory
196 MB, 133Mhz. After around 2 weeks after the upgrade we found the
problem. That is if the client using isql/wisql on windows 95 then cancel
the query/abort the query the Sybase System 11.0.1 it hungs that includes
if the users using the application that connect to the Sybase System
11.0.1 and it still on process and he just shutdown the computer (client)
it hungs too. But if you kill the process or the query first using sybase
command in isql then the System 11 will be alright. So when I contact the
Sybase vendor they say that I have to upgrade to the system 11.0.3 (because
maybe there is a bug). So now for the time being I warn all the users don't
cancel the query but contact the DBA to kill the process. We have one
running the System 11.0.1 on Compaq 1500 but on single processor so it's
not an SMP server and it runs well. Well, Matt I hope this helps you. And
if you got more information on how to resolve this problem please kind
enough to inform me too.

Sri Rejeki A.

Matt Van Rensburg <mattvan@usa.net> wrote in article
<340D7674.581C@usa.net>...
> Hi All
>
> We recently successfully upgraded to System11. After we were happy that
> the server was stable and the clients were running without any problems
> we decided to look at ways to improve the performance of the server.
>
> The first thing we did was to gather info on the current server usage
> (sp_sysmon). We saw that the server cpu usage was very high and decided
> to add another engine to spread the load.
> Everything looked great and looking at sp_sysmon showed that the load
> was being spread across both engines, but since we did this, our server
> has hung twice and we have had to reboot the server. I was unable to
> shutdown the server by logging in with isql to shutdown or the NT sql
> services manager to shutdown sybase. The NT sql services manager told me
> it was unable to stop the server.
>
> We are running sybase11.0.1 on NT4.0 svcpack3.
> The server is a compaq proliant 4500 5/100 with 256mb memory and 2 x
> P100mhz engines.
>
> Has anybody experienced this problem or have any ideas what could be
> wrong.
>
> Thanks
> Matt Van Rensburg
>


David Lance Wolf Posted on 1997-09-30 14:13:14.0Z
Message-ID: <343108FA.89A8F02D@sybase.com>
Date: Tue, 30 Sep 1997 07:13:14 -0700
From: David Lance Wolf <dwolf@sybase.com>
Organization: Sybase Professional Services
X-Mailer: Mozilla 4.02 [en] (Win95; I)
MIME-Version: 1.0
Subject: Re: SMP hangs server
References: <340D7674.581C@usa.net> <01bccd67$3b0462c0$c90000c0@sra.tugu.co.id>
Content-Type: multipart/mixed; boundary="------------E3ACC87836047F1F6FB2333B"
Newsgroups: sybase.public.sqlserver.nt
Lines: 96
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5495
Article PK: 1081575

I would be sure to upgrade to 11.0.3 becuase I believe you are
experienceing a bug. Ont thing to try as well is to modify the sql.ini
file to allow SQL Server to use Out of Band 'Alert' signals. Hitting
Cntrl-C is just such an alert signal. You need to add the word 'Urgent'
to the end of the line in sql.ini. Ad it to both the query and master
entries.

query Server NLWWNSCK,some.machine.com,5000,URGENT

Dave Wolf
Sybase Professional Services

Sri Rejeki wrote:
>
> Hi Matt
>
> We have experience the same problem as you do after we successfully
> upgraded to System 11.0.1. except that the System 11 is running on NT3.51
> svcpack5 and the server is Compaq proliant 4500 using 4 processors, memory
> 196 MB, 133Mhz. After around 2 weeks after the upgrade we found the
> problem. That is if the client using isql/wisql on windows 95 then cancel
> the query/abort the query the Sybase System 11.0.1 it hungs that includes
> if the users using the application that connect to the Sybase System
> 11.0.1 and it still on process and he just shutdown the computer (client)
> it hungs too. But if you kill the process or the query first using sybase
> command in isql then the System 11 will be alright. So when I contact the
> Sybase vendor they say that I have to upgrade to the system 11.0.3 (because
> maybe there is a bug). So now for the time being I warn all the users don't
> cancel the query but contact the DBA to kill the process. We have one
> running the System 11.0.1 on Compaq 1500 but on single processor so it's
> not an SMP server and it runs well. Well, Matt I hope this helps you. And
> if you got more information on how to resolve this problem please kind
> enough to inform me too.
>
> Sri Rejeki A.
> Matt Van Rensburg <mattvan@usa.net> wrote in article
> <340D7674.581C@usa.net>...
> > Hi All
> >
> > We recently successfully upgraded to System11. After we were happy that
> > the server was stable and the clients were running without any problems
> > we decided to look at ways to improve the performance of the server.
> >
> > The first thing we did was to gather info on the current server usage
> > (sp_sysmon). We saw that the server cpu usage was very high and decided
> > to add another engine to spread the load.
> > Everything looked great and looking at sp_sysmon showed that the load
> > was being spread across both engines, but since we did this, our server
> > has hung twice and we have had to reboot the server. I was unable to
> > shutdown the server by logging in with isql to shutdown or the NT sql
> > services manager to shutdown sybase. The NT sql services manager told me
> > it was unable to stop the server.
> >
> > We are running sybase11.0.1 on NT4.0 svcpack3.
> > The server is a compaq proliant 4500 5/100 with 256mb memory and 2 x
> > P100mhz engines.
> >
> > Has anybody experienced this problem or have any ideas what could be
> > wrong.
> >
> > Thanks
> > Matt Van Rensburg
> >


Download VCard vcard.vcf