Re: Sybase performance (26 Views)
Reply
Honored Contributor
Ken Hubnik_2
Posts: 563
Registered: ‎05-20-2002
Message 1 of 4 (26 Views)

Sybase performance

I have a sybase dataserver process that runs high cpu with a wait state on PRI. Attached is a glance snapshot. Freshly installed 11.00 O/S with current patches applied. The DBA's are trying to a large table. Any clues?
Please use plain text.
Honored Contributor
Martin Johnson
Posts: 2,866
Registered: ‎05-07-2002
Message 2 of 4 (26 Views)

Re: Sybase performance

Has the database been tuned? Has the table been indexed? Look at your cache hit ratios. They should be in the high 90s.

HTH
Marty
Please use plain text.
Valued Contributor
David Totsch
Posts: 44
Registered: ‎02-07-1999
Message 3 of 4 (26 Views)

Re: Sybase performance

Ken:

It has been a long time since I have dealt with Sybase, but...welcome to Sybase. There is a reason you configure N-1 dataservers (where N is the number of CPUs). Each dataserver process will consume a CPU, even when the database is "quiet". Maybe someone will tell us that this is antiquated knowledge.

-dlt-
Please use plain text.
Advisor
Johan Bergwitz
Posts: 10
Registered: ‎09-22-1998
Message 4 of 4 (26 Views)

Re: Sybase performance

Does the machine run other applikations also? It seems that you have more CPUs availible that you might consider to run Sybase on. The parameter "Online engines" states how many processes it should run. Inside Sybase, sp_sysmon shows how Sybase thinks of its performance.

Regards
Johan
Please use plain text.
The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation