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.

Maximize performance of Sybase

2 posts in QAnywhere Last posting was on 2004-10-13 12:50:54.0Z
Felix Natividad Posted on 2004-10-13 11:03:57.0Z
From: "Felix Natividad" <winz@phisl.net>
Newsgroups: ianywhere.public.sqlanywhere.qanywhere
Subject: Maximize performance of Sybase
Lines: 26
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.3790.181
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.181
NNTP-Posting-Host: 202.74.0.2
X-Original-NNTP-Posting-Host: 202.74.0.2
Message-ID: <416d0b9d@forums-1-dub>
Date: 13 Oct 2004 04:03:57 -0700
X-Trace: forums-1-dub 1097665437 202.74.0.2 (13 Oct 2004 04:03:57 -0700)
X-Original-Trace: 13 Oct 2004 04:03:57 -0700, 202.74.0.2
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.sqlanywhere.qanywhere:39
Article PK: 10430

We just recently purchase a new server with the ff information :
-PowerEdge 2850 with dual processor of 3Ghz
-3GbRAM
-170G HDD

I have these connection parameter with one of my database but the
performance is not really that impressive with the old server with
specification of PIII 1Ghz, 1G RAM.

connection parameters:
-n test -c 50%% -ch 90%% -gp 8192 -p 1490 -tl 2000

Can you give me the best connection parameters for these powerful device?

How to maximize the resources of this server with Sybase Anywhere 8.0.3 on
it?

Is there any way to use the two processor for sybase?

thnx
Felix


Chris Keating (iAnywhere Solutions) Posted on 2004-10-13 12:50:54.0Z
From: "Chris Keating \(iAnywhere Solutions\)" <Spam_NoThanks_keating@iAnywhere.com>
Newsgroups: ianywhere.public.sqlanywhere.qanywhere
References: <416d0b9d@forums-1-dub>
Subject: Re: Maximize performance of Sybase
Lines: 34
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: keating-xp2.sybase.com
X-Original-NNTP-Posting-Host: keating-xp2.sybase.com
Message-ID: <416d24ae$1@forums-1-dub>
Date: 13 Oct 2004 05:50:54 -0700
X-Trace: forums-1-dub 1097671854 10.25.98.199 (13 Oct 2004 05:50:54 -0700)
X-Original-Trace: 13 Oct 2004 05:50:54 -0700, keating-xp2.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.sqlanywhere.qanywhere:40
Article PK: 10429

I have moved this question to sybase.public.sqlanywhere.general as it is not
related to qanywhere.

"Felix Natividad" <winz@phisl.net> wrote in message
news:416d0b9d@forums-1-dub...
> We just recently purchase a new server with the ff information :
> -PowerEdge 2850 with dual processor of 3Ghz
> -3GbRAM
> -170G HDD
>
> I have these connection parameter with one of my database but the
> performance is not really that impressive with the old server with
> specification of PIII 1Ghz, 1G RAM.
>
> connection parameters:
> -n test -c 50%% -ch 90%% -gp 8192 -p 1490 -tl 2000
>
> Can you give me the best connection parameters for these powerful device?
>
> How to maximize the resources of this server with Sybase Anywhere 8.0.3 on
> it?
>
> Is there any way to use the two processor for sybase?
>
> thnx
> Felix
>
>
>
>
>