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 (AT) micro (DOT) com> wrote

Hi

Thank you for help.

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

Thank you
/Jo
"Derek Beacon" <derek.beacon (AT) ntlworld (DOT) com> wrote

jo <jo (AT) micro (DOT) com> wrote:
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 (AT) hotmail (DOT) com> wrote

pinterkr (AT) freemail (DOT) hu (Krisztian Pinter) wrote in
news:a3fdccb.0311210106.63772bff (AT) posting (DOT) google.com:

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