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.

sqlanywhere 5.5 preformance

3 posts in General Discussion Last posting was on 2005-08-24 01:39:45.0Z
Alex Posted on 2005-08-22 23:01:09.0Z
From: "Alex" <nowhere@invalid>
Newsgroups: ianywhere.public.general
Subject: sqlanywhere 5.5 preformance
Lines: 16
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: ip-210-185-10-179.internet.co.nz
X-Original-NNTP-Posting-Host: ip-210-185-10-179.internet.co.nz
Message-ID: <430a5935$1@forums-1-dub>
Date: 22 Aug 2005 16:01:09 -0700
X-Trace: forums-1-dub 1124751669 210.185.10.179 (22 Aug 2005 16:01:09 -0700)
X-Original-Trace: 22 Aug 2005 16:01:09 -0700, ip-210-185-10-179.internet.co.nz
X-Authenticated-User: pb105beta
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4708
Article PK: 17339

one of our users is still running sql anywhere 5.5
they have 10 heavy users and 5 lite users

it is a windows 2000 server with 512mb ram, the server has some shared files
on it, but no other major applications on it
the database is 70mb in size and the cache is set to 128mb

they have noticed a slowdown recently
is 128mb cache suitable for that number of users ?
or is there something else i should be looking at

cheers

alex


"Rob Waywell" <rwaywell Posted on 2005-08-23 16:17:58.0Z
From: "Rob Waywell" <rwaywell@no_spam.ianywhere.com>
Newsgroups: ianywhere.public.general
References: <430a5935$1@forums-1-dub>
Subject: Re: sqlanywhere 5.5 preformance
Lines: 56
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; Response
X-Original-NNTP-Posting-Host: 10.25.98.159
Message-ID: <430b4c32$1@forums-2-dub>
X-Original-Trace: 23 Aug 2005 09:17:54 -0700, 10.25.98.159
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 23 Aug 2005 09:17:55 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 23 Aug 2005 09:17:58 -0700
X-Trace: forums-1-dub 1124813878 10.22.108.75 (23 Aug 2005 09:17:58 -0700)
X-Original-Trace: 23 Aug 2005 09:17:58 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4711
Article PK: 8500

Cache size is likely not the issue in this case. A more typical cache size
for a 70MB database would be about 14MB, so 128MB is generous.

Since performance was reasonable but has recently degraded, and since this
database appears to have been in use for a long time, the first thing I
would check would be fragmentation, both at the disk level and internally
within the database. To defragment within the database for version 5.x you
will need to do an unload/reload. If this happens to be a replicating
database, then ensure that you follow the documented process for unloading
and reloading a replicating database. Disk fragmentation can be handled by
your standard disk defragmentation utility.

A couple of assumptions that I'm making are:

1) The database has not grown recently.
2) The application has not changed recently.

--
-----------------------------------------------
Robert Waywell
Sybase Adaptive Server Anywhere Developer - Version 8
Sybase Certified Professional

Sybase's iAnywhere Solutions

Please respond ONLY to newsgroup

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports:
http://case-express.sybase.com/cx/cx.stm?starturl=casemessage.ssc?CASETYPE=Bug

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

Whitepapers, TechDocs, and bug fixes are all available through the iAnywhere
Developer Community at www.ianywhere.com/developer

"Alex" <nowhere@invalid> wrote in message news:430a5935$1@forums-1-dub...
> one of our users is still running sql anywhere 5.5
> they have 10 heavy users and 5 lite users
>
> it is a windows 2000 server with 512mb ram, the server has some shared
> files on it, but no other major applications on it
> the database is 70mb in size and the cache is set to 128mb
>
> they have noticed a slowdown recently
> is 128mb cache suitable for that number of users ?
> or is there something else i should be looking at
>
> cheers
>
> alex
>


Alex Posted on 2005-08-24 01:39:45.0Z
From: "Alex" <nowhere@invalid>
Newsgroups: ianywhere.public.general
References: <430a5935$1@forums-1-dub> <430b4c32$1@forums-2-dub>
Subject: Re: sqlanywhere 5.5 preformance
Lines: 68
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2670
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: ip-210-185-10-179.internet.co.nz
X-Original-NNTP-Posting-Host: ip-210-185-10-179.internet.co.nz
Message-ID: <430bcfe1$1@forums-1-dub>
Date: 23 Aug 2005 18:39:45 -0700
X-Trace: forums-1-dub 1124847585 210.185.10.179 (23 Aug 2005 18:39:45 -0700)
X-Original-Trace: 23 Aug 2005 18:39:45 -0700, ip-210-185-10-179.internet.co.nz
X-Authenticated-User: pb105beta
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4713
Article PK: 8502

your assumptions are correct
i will give it a go and see if there is any difference

thanks

alex

"Rob Waywell" <rwaywell@no_spam.ianywhere.com> wrote in message
news:430b4c32$1@forums-2-dub...
> Cache size is likely not the issue in this case. A more typical cache size
> for a 70MB database would be about 14MB, so 128MB is generous.
>
> Since performance was reasonable but has recently degraded, and since this
> database appears to have been in use for a long time, the first thing I
> would check would be fragmentation, both at the disk level and internally
> within the database. To defragment within the database for version 5.x you
> will need to do an unload/reload. If this happens to be a replicating
> database, then ensure that you follow the documented process for unloading
> and reloading a replicating database. Disk fragmentation can be handled by
> your standard disk defragmentation utility.
>
> A couple of assumptions that I'm making are:
>
> 1) The database has not grown recently.
> 2) The application has not changed recently.
>
> --
> -----------------------------------------------
> Robert Waywell
> Sybase Adaptive Server Anywhere Developer - Version 8
> Sybase Certified Professional
>
> Sybase's iAnywhere Solutions
>
> Please respond ONLY to newsgroup
>
> EBF's and Patches: http://downloads.sybase.com
> choose SQL Anywhere Studio >> change 'time frame' to all
>
> To Submit Bug Reports:
> http://case-express.sybase.com/cx/cx.stm?starturl=casemessage.ssc?CASETYPE=Bug
>
> SQL Anywhere Studio Supported Platforms and Support Status
> http://my.sybase.com/detail?id=1002288
>
> Whitepapers, TechDocs, and bug fixes are all available through the
> iAnywhere
> Developer Community at www.ianywhere.com/developer
> "Alex" <nowhere@invalid> wrote in message news:430a5935$1@forums-1-dub...
>> one of our users is still running sql anywhere 5.5
>> they have 10 heavy users and 5 lite users
>>
>> it is a windows 2000 server with 512mb ram, the server has some shared
>> files on it, but no other major applications on it
>> the database is 70mb in size and the cache is set to 128mb
>>
>> they have noticed a slowdown recently
>> is 128mb cache suitable for that number of users ?
>> or is there something else i should be looking at
>>
>> cheers
>>
>> alex
>>
>
>