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.

Stress Testing

6 posts in General Discussion Last posting was on 2006-06-06 20:22:27.0Z
Charles Phillips Posted on 2006-05-30 23:09:01.0Z
From: "Charles Phillips" <tptbusines_2005@hotmail.com>
Newsgroups: ianywhere.public.general
Subject: Stress Testing
Lines: 22
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4922.1500
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4925.2800
NNTP-Posting-Host: c-24-127-123-60.hsd1.ca.comcast.net
X-Original-NNTP-Posting-Host: c-24-127-123-60.hsd1.ca.comcast.net
Message-ID: <447cd08d$1@forums-1-dub>
Date: 30 May 2006 16:09:01 -0700
X-Trace: forums-1-dub 1149030541 24.127.123.60 (30 May 2006 16:09:01 -0700)
X-Original-Trace: 30 May 2006 16:09:01 -0700, c-24-127-123-60.hsd1.ca.comcast.net
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5410
Article PK: 1460

Hello,
I'm using MS-Access 97 as a model database for about 50 Users on a Windows
network. I plan to upgrade the database to iAnywhere 9.01. I'd like to know,
if there is a standard set of test to perform on the database for
verification.
Are there processes to test CPU utilization, memory utilization, processing
time & whatever else there is needed to validate the database... One the
iAnywhere version has been stressed tested, I plan to deploy the database to
be used on a website. I'd like for both ends of the database to run in
union. I'd like to know, if there is a standard set of test to perform on
the database, that the website & the "flat" version are in sync.

If there is a set of standard stress test, what are they, where can I find
them & how long should I stress test this database before I give it to my
customers or go public with it???


Thank you,

Charles L. Phillips


"Chris Keating(iAnywhere Solutions)" <NoSpamPlease_k_e_a_t_i_n_g Posted on 2006-05-31 00:46:38.0Z
From: "Chris Keating(iAnywhere Solutions)" <NoSpamPlease_k_e_a_t_i_n_g@i_A_n_y_w_h_e_r_e.com>
Organization: iAnywhere Solutions
User-Agent: Thunderbird 1.5.0.2 (Windows/20060308)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Stress Testing
References: <447cd08d$1@forums-1-dub>
In-Reply-To: <447cd08d$1@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: cpe001217e36468-cm0014e8868e10.cpe.net.cable.rogers.com
X-Original-NNTP-Posting-Host: cpe001217e36468-cm0014e8868e10.cpe.net.cable.rogers.com
Message-ID: <447ce76e@forums-1-dub>
Date: 30 May 2006 17:46:38 -0700
X-Trace: forums-1-dub 1149036398 24.43.0.24 (30 May 2006 17:46:38 -0700)
X-Original-Trace: 30 May 2006 17:46:38 -0700, cpe001217e36468-cm0014e8868e10.cpe.net.cable.rogers.com
Lines: 34
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5411
Article PK: 1461

There are no standard stress tests since each application will have its
own set of unique characteristics that need to be tested.

There are a large number of server and database statistics that can be
monitored via Sybase Central and/or the performance monitor on Windows
systems.

BTW ASA should not get stressed by a web based application supporting 50
users. If you are coming from a multiuser Access environment, you should
find ASA a better performer provided that your schema and query design
is solid.
--

Chris Keating
Sybase Adaptive Server Anywhere Professional Version 8

*****************************************************************************
Sign up today for your copy of the SQL Anywhere Studio 9 Developer
Edition =and try out the market-leading database for mobile, embedded
and small to medium sized business environments for free!

http://www.ianywhere.com/promos/deved/index.html

*****************************************************************************

iAnywhere Solutions http://www.iAnywhere.com

** Please only post to the newsgroup

** Whitepapers can be found at http://www.iAnywhere.com/developer
** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
** Use Case Express to report bugs http://case-express.sybase.com

*****************************************************************************


Jason Hinsperger (iAnywhere) Posted on 2006-05-31 23:25:44.0Z
From: "Jason Hinsperger \(iAnywhere\)" <NOjason_hinspergerSPAM@hotmail.com>
Newsgroups: ianywhere.public.general
References: <447cd08d$1@forums-1-dub> <447ce76e@forums-1-dub>
Subject: Re: Stress Testing
Lines: 56
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2869
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: vpn-dub-216.sybase.com
X-Original-NNTP-Posting-Host: vpn-dub-216.sybase.com
Message-ID: <447e25f8@forums-1-dub>
Date: 31 May 2006 16:25:44 -0700
X-Trace: forums-1-dub 1149117944 10.22.120.216 (31 May 2006 16:25:44 -0700)
X-Original-Trace: 31 May 2006 16:25:44 -0700, vpn-dub-216.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5416
Article PK: 1466

As Chris says, there are no standard stress tests. However, you should take
a look at the "performancetransaction" sample in the samples\asa directory
of your SQL Anywhere install. It is a basic framework that will allow you
to co-ordinate multiple clients executing transactions against the server
and measure results.

--
Jason Hinsperger
Product Manager
iAnywhere Solutions
************************************************************
For the latest downloads technotes, whitepapers, webcasts and other
developer
resources, go to: http://www.ianywhere.com/developer/
************************************************************


"Chris Keating(iAnywhere Solutions)"

<NoSpamPlease_k_e_a_t_i_n_g@i_A_n_y_w_h_e_r_e.com> wrote in message
news:447ce76e@forums-1-dub...
> There are no standard stress tests since each application will have its
> own set of unique characteristics that need to be tested.
>
> There are a large number of server and database statistics that can be
> monitored via Sybase Central and/or the performance monitor on Windows
> systems.
>
> BTW ASA should not get stressed by a web based application supporting 50
> users. If you are coming from a multiuser Access environment, you should
> find ASA a better performer provided that your schema and query design is
> solid.
> --
>
> Chris Keating
> Sybase Adaptive Server Anywhere Professional Version 8
>
> *****************************************************************************
> Sign up today for your copy of the SQL Anywhere Studio 9 Developer Edition
> =and try out the market-leading database for mobile, embedded and small to
> medium sized business environments for free!
>
> http://www.ianywhere.com/promos/deved/index.html
>
> *****************************************************************************
>
> iAnywhere Solutions http://www.iAnywhere.com
>
> ** Please only post to the newsgroup
>
> ** Whitepapers can be found at http://www.iAnywhere.com/developer
> ** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
> ** Use Case Express to report bugs http://case-express.sybase.com
>
> *****************************************************************************


News Posted on 2006-06-06 20:22:27.0Z
From: "News" <msnews.microsoft.com>
Newsgroups: ianywhere.public.general
References: <447cd08d$1@forums-1-dub> <447ce76e@forums-1-dub> <447e25f8@forums-1-dub>
Subject: Re: Stress Testing
Lines: 74
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
X-Original-NNTP-Posting-Host: c-24-127-123-60.hsd1.ca.comcast.net
Message-ID: <4485e353$1@forums-2-dub>
X-Original-Trace: 6 Jun 2006 13:19:31 -0700, c-24-127-123-60.hsd1.ca.comcast.net
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 6 Jun 2006 13:19:32 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 6 Jun 2006 13:22:27 -0700
X-Trace: forums-1-dub 1149625347 10.22.108.75 (6 Jun 2006 13:22:27 -0700)
X-Original-Trace: 6 Jun 2006 13:22:27 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5425
Article PK: 1473

Thank You...

"Jason Hinsperger (iAnywhere)" <NOjason_hinspergerSPAM@hotmail.com> wrote in
message news:447e25f8@forums-1-dub...
> As Chris says, there are no standard stress tests. However, you should
take
> a look at the "performancetransaction" sample in the samples\asa directory
> of your SQL Anywhere install. It is a basic framework that will allow you
> to co-ordinate multiple clients executing transactions against the server
> and measure results.
>
> --
> Jason Hinsperger
> Product Manager
> iAnywhere Solutions
> ************************************************************
> For the latest downloads technotes, whitepapers, webcasts and other
> developer
> resources, go to: http://www.ianywhere.com/developer/
> ************************************************************
>
>
> "Chris Keating(iAnywhere Solutions)"
> <NoSpamPlease_k_e_a_t_i_n_g@i_A_n_y_w_h_e_r_e.com> wrote in message
> news:447ce76e@forums-1-dub...
> > There are no standard stress tests since each application will have its
> > own set of unique characteristics that need to be tested.
> >
> > There are a large number of server and database statistics that can be
> > monitored via Sybase Central and/or the performance monitor on Windows
> > systems.
> >
> > BTW ASA should not get stressed by a web based application supporting 50
> > users. If you are coming from a multiuser Access environment, you should
> > find ASA a better performer provided that your schema and query design
is
> > solid.
> > --
> >
> > Chris Keating
> > Sybase Adaptive Server Anywhere Professional Version 8
> >
> >

****************************************************************************
*
> > Sign up today for your copy of the SQL Anywhere Studio 9 Developer
Edition
> > =and try out the market-leading database for mobile, embedded and small
to
> > medium sized business environments for free!
> >
> > http://www.ianywhere.com/promos/deved/index.html
> >
> >
****************************************************************************
*
> >
> > iAnywhere Solutions http://www.iAnywhere.com
> >
> > ** Please only post to the newsgroup
> >
> > ** Whitepapers can be found at http://www.iAnywhere.com/developer
> > ** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
> > ** Use Case Express to report bugs http://case-express.sybase.com
> >
> >
****************************************************************************
*
>
>


Rob Waywell Posted on 2006-05-31 13:53:21.0Z
From: "Rob Waywell" <rwaywell_no_spam_please@ianywhere.com>
Newsgroups: ianywhere.public.general
References: <447cd08d$1@forums-1-dub>
Subject: Re: Stress Testing
Lines: 52
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2869
X-RFC2646: Format=Flowed; Original
X-Original-NNTP-Posting-Host: rwaywell-xp2.sybase.com
Message-ID: <447d9f45@forums-2-dub>
X-Original-Trace: 31 May 2006 06:51:01 -0700, rwaywell-xp2.sybase.com
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 31 May 2006 06:51:02 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 31 May 2006 06:53:21 -0700
X-Trace: forums-1-dub 1149083601 10.22.108.75 (31 May 2006 06:53:21 -0700)
X-Original-Trace: 31 May 2006 06:53:21 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5414
Article PK: 1464

How are you stress testing your existing version?
Why would you upgrade to 9.0.1 when the current released version is 9.0.2?
Are there specific scenarios that you are concerned about?

--
-----------------------------------------------
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

"Charles Phillips" <tptbusines_2005@hotmail.com> wrote in message
news:447cd08d$1@forums-1-dub...
> Hello,
> I'm using MS-Access 97 as a model database for about 50 Users on a Windows
> network. I plan to upgrade the database to iAnywhere 9.01. I'd like to
> know,
> if there is a standard set of test to perform on the database for
> verification.
> Are there processes to test CPU utilization, memory utilization,
> processing
> time & whatever else there is needed to validate the database... One the
> iAnywhere version has been stressed tested, I plan to deploy the database
> to
> be used on a website. I'd like for both ends of the database to run in
> union. I'd like to know, if there is a standard set of test to perform on
> the database, that the website & the "flat" version are in sync.
>
> If there is a set of standard stress test, what are they, where can I find
> them & how long should I stress test this database before I give it to my
> customers or go public with it???
>
>
> Thank you,
>
> Charles L. Phillips
>
>


Charles Phillips Posted on 2006-05-31 19:58:29.0Z
From: "Charles Phillips" <tptbusines_2005@hotmail.com>
Newsgroups: ianywhere.public.general
References: <447cd08d$1@forums-1-dub> <447d9f45@forums-2-dub>
Subject: Re: Stress Testing
Lines: 81
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4922.1500
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4925.2800
X-Original-NNTP-Posting-Host: c-24-127-123-60.hsd1.ca.comcast.net
Message-ID: <447df4d4@forums-2-dub>
X-Original-Trace: 31 May 2006 12:56:04 -0700, c-24-127-123-60.hsd1.ca.comcast.net
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 31 May 2006 12:56:07 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 31 May 2006 12:58:29 -0700
X-Trace: forums-1-dub 1149105509 10.22.108.75 (31 May 2006 12:58:29 -0700)
X-Original-Trace: 31 May 2006 12:58:29 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5415
Article PK: 1465

Hello,
I am not stress testing ANYTHING now.
The reasons for posting the questions, was to find out "how-to" & with what
procedures or processes.
I want to make sure my db works under some "real" conditions before I make
it available to my customers.
I was not aware of ver 9.0.2
The three (3) scenarios that come to mind are: CPU utilization, memory
utilization & processing time or, how does the app func when the network is
being loaded down...


Thank you,

Charles L. Phillips

"Rob Waywell" <rwaywell_no_spam_please@ianywhere.com> wrote in message
news:447d9f45@forums-2-dub...
> How are you stress testing your existing version?
> Why would you upgrade to 9.0.1 when the current released version is 9.0.2?
> Are there specific scenarios that you are concerned about?
>
> --
> -----------------------------------------------
> 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=B
ug
>
> SQL Anywhere Studio Supported Platforms and Support Status
> http://my.sybase.com/detail?id=1002288
>
> "Charles Phillips" <tptbusines_2005@hotmail.com> wrote in message
> news:447cd08d$1@forums-1-dub...
> > Hello,
> > I'm using MS-Access 97 as a model database for about 50 Users on a
Windows
> > network. I plan to upgrade the database to iAnywhere 9.01. I'd like to
> > know,
> > if there is a standard set of test to perform on the database for
> > verification.
> > Are there processes to test CPU utilization, memory utilization,
> > processing
> > time & whatever else there is needed to validate the database... One the
> > iAnywhere version has been stressed tested, I plan to deploy the
database
> > to
> > be used on a website. I'd like for both ends of the database to run in
> > union. I'd like to know, if there is a standard set of test to perform
on
> > the database, that the website & the "flat" version are in sync.
> >
> > If there is a set of standard stress test, what are they, where can I
find
> > them & how long should I stress test this database before I give it to
my
> > customers or go public with it???
> >
> >
> > Thank you,
> >
> > Charles L. Phillips
> >
> >
>
>