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.

Priority of Sybase process

4 posts in Windows NT Last posting was on 1999-05-06 10:51:17.0Z
Mariana Arcadia Posted on 1998-05-06 20:57:02.0Z
Message-ID: <3550CE9E.5C105BA0@impsat1.com.ar>
Date: Wed, 06 May 1998 17:57:02 -0300
From: Mariana Arcadia <arcadia@impsat1.com.ar>
Reply-To: arcadia@impsat1.com.ar
X-Mailer: Mozilla 4.01 [en] (WinNT; I)
MIME-Version: 1.0
Subject: Priority of Sybase process
X-Priority: 3 (Normal)
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 8
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5035
Article PK: 1092398

Does anybody know how can I increase the priority of the Sybase process
in a NT 4.0?
If I press Ctrl-Alt-Del and press the right button over the sqlsrvr.exe
process, I choose high priority, I get an error message of Acces denied.

Thanks

Mariana Arcadia
arcadia@impsat1.com.ar


Jeff Bearden Posted on 1999-05-06 01:44:27.0Z
Message-ID: <3730F3FB.20A9945@beapsy1.his.uab.edu>
Date: Wed, 05 May 1999 20:44:27 -0500
From: Jeff Bearden <jbearden@beapsy1.his.uab.edu>
Organization: UABSAP
X-Mailer: Mozilla 4.51 [en] (Win95; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: Priority of Sybase process
References: <3550CE9E.5C105BA0@impsat1.com.ar>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 26
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:3809
Article PK: 1091200

Me too! I'm running dual processors and some days the server runs at 90 and
100% with spikes that look like the Alps! This makes me have to start and
stop the server over and over again, and man I'm I a "popular" guy at work!
hehe!

No matter how many times Sybase comes to "optimize" the server (at hundreds
an hour) this still happens. Q&A tables aside, sqlsrvr.exe is a pig with
resources, and you can not to my knowledge affect the priority of the
process at all.

Anyone?

Jeff Bearden, ISS-I
jbearden@beapsy1.his.uab.edu

Mariana Arcadia wrote:

> Does anybody know how can I increase the priority of the Sybase process
> in a NT 4.0?
> If I press Ctrl-Alt-Del and press the right button over the sqlsrvr.exe
> process, I choose high priority, I get an error message of Acces denied.
>
> Thanks
>
> Mariana Arcadia
> arcadia@impsat1.com.ar

--
Jeff Bearden
Information Systems Specialist I - UABSAP
jbearden@beapsy1.his.uab.edu


Tony Imbierski Posted on 1999-05-06 10:51:17.0Z
Message-ID: <37317425.50D3@sybase.com>
Date: Thu, 06 May 1999 11:51:17 +0100
From: Tony Imbierski <tonyi@sybase.com>
Reply-To: tonyi@sybase.com
Organization: Sybase Adaptive Server Engineering
X-Mailer: Mozilla 3.02 (WinNT; I)
MIME-Version: 1.0
Subject: Re: Priority of Sybase process
References: <3550CE9E.5C105BA0@impsat1.com.ar> <3730F3FB.20A9945@beapsy1.his.uab.edu>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 96
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:3805
Article PK: 1091195

To answer the original question, if you start ASE with the -P option, it
sets itself to NT's high priority class (normally it sets itself to
'normal' priority class).

However, this has little to do with the CPU usage you are seeing. The
priority only comes into effect when ASE is competing for CPU resource
with other applications. NT's scheduler will schedule threads in
priority order, so using the -P option would allow ASE to pre-empt other
busy applications that might be running. Normally it's a bad idea to run
competing apps like this on a production RDBMS server, whatever RDBMS
you are using.

So, if ASE is using 90-100% of your 2 processors, just reducing its
priority will NOT I repeat NOT make it use less. It'll just make ASE
sometimes be pre-empted by other apps, which will hurt performance of
ASE. You'll still see 90-100% on your CPU graph.

Also, when the database is 'optimised', what normally happens is things
are tweaked to make disk and network access as efficient as possible,
and reduce lock contention. When you do this, CPU usage may INCREASE as
the system is able to process more work from the front end. Remember ANY
application will use as much CPU as it can until it is stopped either by
a resource wait or waiting for user input.

Using 90-100% CPU in peak bursts is not necessarily a 'bad thing',
providing work is being done. If your CPU usage were peaking around the
50% mark, then all it means is ASE is too often waiting for some other
resource to free up (or has no work to do). 50% CPU usage means 50% of
the time the CPU is not doing anything useful - you might as well take
one of your dual CPU's out and throw it away. 90-100% peak usage means
you are making very good use of both processors and your locking and i/o
subsystems are working efficiently. *constant* 100% cpu would be
something to worry about - cpu is then a bottleneck and you would need
to consider upgrading or moving load off to another server.

'A pig with resources' - normally this phrase is used to describe
applications that don't share resources well with other applications.
For any enterprise RDBMS this is *deliberate*. An RDBMS (any RDBMS)
should be the only major thing running on the machine and most are
designed to be run this way. ASE deliberately tries to stay scheduled in
on the CPU as an OS thread switch hurts performance.

Hope this all helps a bit.

cheers,
tonyi

--
===============================================================
Tony Imbierski
Sybase Adaptive Server Engineering
Kernel & Platform Sustaining
---------------------------------------------------------------

===============================================================

Jeff Bearden wrote:
>
> Me too! I'm running dual processors and some days the server runs at 90 and
> 100% with spikes that look like the Alps! This makes me have to start and
> stop the server over and over again, and man I'm I a "popular" guy at work!
> hehe!
>
> No matter how many times Sybase comes to "optimize" the server (at hundreds
> an hour) this still happens. Q&A tables aside, sqlsrvr.exe is a pig with
> resources, and you can not to my knowledge affect the priority of the
> process at all.
>
> Anyone?
>
> Jeff Bearden, ISS-I
> jbearden@beapsy1.his.uab.edu
>
> Mariana Arcadia wrote:
>
> > Does anybody know how can I increase the priority of the Sybase process
> > in a NT 4.0?
> > If I press Ctrl-Alt-Del and press the right button over the sqlsrvr.exe
> > process, I choose high priority, I get an error message of Acces denied.
> >
> > Thanks
> >
> > Mariana Arcadia
> > arcadia@impsat1.com.ar
>
> --
> Jeff Bearden
> Information Systems Specialist I - UABSAP
> jbearden@beapsy1.his.uab.edu


Tony Imbierski Posted on 1998-05-07 09:39:14.0Z
Message-ID: <35518142.697A@sybase.com>
Date: Thu, 07 May 1998 10:39:14 +0100
From: Tony Imbierski <tonyi@sybase.com>
Reply-To: tonyi@sybase.com
Organization: Sybase Adaptive Server Engineering
X-Mailer: Mozilla 3.02 (WinNT; I)
MIME-Version: 1.0
To: arcadia@impsat1.com.ar
Subject: Re: Priority of Sybase process
References: <3550CE9E.5C105BA0@impsat1.com.ar>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 21
Path: forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.sqlserver.nt:5034
Article PK: 1092397


Mariana Arcadia wrote:
>
> Does anybody know how can I increase the priority of the Sybase process
> in a NT 4.0?
> If I press Ctrl-Alt-Del and press the right button over the sqlsrvr.exe
> process, I choose high priority, I get an error message of Acces denied.
>
> Thanks
>
> Mariana Arcadia
> arcadia@impsat1.com.ar

Hi Mariana,

If you add -P to the sqlsrvr start options, it sets itself to high
priority during initialisation.

cheers,
tonyi

--
===============================================================
Tony Imbierski
Sybase Adaptive Server Engineering
Kernel & Platform Sustaining
---------------------------------------------------------------

===============================================================