Hello guys,

I need some help.
I need to check the parameters in Sybase database. Are they as recommended.
How can I check this?
If I need to change them how do I do it?
I will really appriciate your help.

Recommend to set the following parameters in the Sybase database
server to the values specified below:
number of locks: 50000 (at least)
page lock promotion HWM: 3000
page lock promotion LWM: 3000
number of aux scan descriptors: 400
stack size: 92160

Thank you

/Jo

sp_configure
go

on it's own will show you all of the current parameters and their values.

sp_configure "number of locks",50000
go
should set the number of locks to 50000. Depending on the version of Sybase
your running you might need to bounce the Sybase server for these new
setting to take affect.

See sybooks for the full documentation on this.

HTH

Derek.

P.S. Just wondering where you got the figures from below, is this the result
of some tuning or sysmon stats?



"jo" <jo@micro.com> wrote in message
news:boo55u$obk$1@newstree.wise.edt.ericsson.se...
> Hello guys,
>
> I need some help.
> I need to check the parameters in Sybase database. Are they as
recommended.
> How can I check this?
> If I need to change them how do I do it?
> I will really appriciate your help.
>
> Recommend to set the following parameters in the Sybase database
> server to the values specified below:
> number of locks: 50000 (at least)
> page lock promotion HWM: 3000
> page lock promotion LWM: 3000
> number of aux scan descriptors: 400
> stack size: 92160
>
> Thank you
>
> /Jo
>
>

Hi

Thank you for help.

The figures got from the mentioned note for upgrade the system.

Thank you
/Jo
"Derek Beacon" <derek.beacon@ntlworld.com> wrote in message
news:K1Nrb.375$W%.302631@newsfep1-win.server.ntli.net...
> sp_configure
> go
>
> on it's own will show you all of the current parameters and their values.
>
> sp_configure "number of locks",50000
> go
> should set the number of locks to 50000. Depending on the version of
Sybase
> your running you might need to bounce the Sybase server for these new
> setting to take affect.
>
> See sybooks for the full documentation on this.
>
> HTH
>
> Derek.
>
> P.S. Just wondering where you got the figures from below, is this the
result
> of some tuning or sysmon stats?
>
>
>
> "jo" <jo@micro.com> wrote in message
> news:boo55u$obk$1@newstree.wise.edt.ericsson.se...
> > Hello guys,
> >
> > I need some help.
> > I need to check the parameters in Sybase database. Are they as
> recommended.
> > How can I check this?
> > If I need to change them how do I do it?
> > I will really appriciate your help.
> >
> > Recommend to set the following parameters in the Sybase database
> > server to the values specified below:
> > number of locks: 50000 (at least)
> > page lock promotion HWM: 3000
> > page lock promotion LWM: 3000
> > number of aux scan descriptors: 400
> > stack size: 92160
> >
> > Thank you
> >
> > /Jo
> >
> >
>
>

jo <jo@micro.com> wrote:
> Hello guys,
>
> I need some help.
> I need to check the parameters in Sybase database. Are they as recommended.
> How can I check this?

Have you tried Oracle? It's much better than Sybase.

-am © 2003

1. no tool is good for everything. choose your tool suitable to needs.

2. oracle costs four times as much, requires much stronger hardware

3. this is a forum about sybase

4. the question was absolutely not related to platform choosing

5. i wonder what kind of guy you are spreading spam under your real name



Anthony Mandic <ie@hotmail.com> wrote in message news:<3fbd787b$0$62734$c3e8da3@news.astraweb.com>. ..
> jo <jo@micro.com> wrote:
> > Hello guys,
> >
> > I need some help.
> > I need to check the parameters in Sybase database. Are they as recommended.
> > How can I check this?
>
> Have you tried Oracle? It's much better than Sybase.
>
> -am © 2003

pinterkr@freemail.hu (Krisztian Pinter) wrote in
news:a3fdccb.0311210106.63772bff@posting.google.co m:

> 5. i wonder what kind of guy you are spreading spam under your
> real name

You didn't see the following in the post-bait:

X-Silly: Anythony Manic is a goofball, I am not he, this is a
parody.
--
Pablo Sanchez - Blueoak Database Engineering, Inc
http://www.blueoakdb.com