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.

How to measure performance on slow database

2 posts in General Discussion Last posting was on 2005-02-11 00:32:32.0Z
Frank Vestjens Posted on 2005-02-10 16:06:41.0Z
From: "Frank Vestjens" <FVestjens@InforIT.nl>
Newsgroups: ianywhere.public.general
Subject: How to measure performance on slow database
Lines: 17
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
NNTP-Posting-Host: 62.58.186.102
X-Original-NNTP-Posting-Host: 62.58.186.102
Message-ID: <420b8691$1@forums-1-dub>
Date: 10 Feb 2005 08:06:41 -0800
X-Trace: forums-1-dub 1108051601 62.58.186.102 (10 Feb 2005 08:06:41 -0800)
X-Original-Trace: 10 Feb 2005 08:06:41 -0800, 62.58.186.102
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4124
Article PK: 8008

What is the best way to check what is making my database slow. My customer
is complaining about the speed of my application.
How can I check what is causing this slow performance and where should I
look for.
Has it sometinhg to do with memory on the machine, do I need to create
additional indexes.
Where should I look and what should I use to find things out.

They're currently working on sybase 7.0.4, but we want to have them running
on sybase 9.0 by the end of februari.

Regards,

Frank Vestjens
InforIT bv


Shuchit Posted on 2005-02-11 00:32:32.0Z
Newsgroups: ianywhere.public.general
Subject: Re: How to measure performance on slow database
From: Shuchit <me@privacy.net>
References: <420b8691$1@forums-1-dub>
Message-ID: <Xns95F9C6B9BA4Csvelkarprivacynet@127.0.0.1>
User-Agent: Xnews/06.08.25 Hamster/2.0.6.0
NNTP-Posting-Host: cpe0080c6ee7d81-cm024340006571.cpe.net.cable.rogers.com
X-Original-NNTP-Posting-Host: cpe0080c6ee7d81-cm024340006571.cpe.net.cable.rogers.com
Date: 10 Feb 2005 16:32:32 -0800
X-Trace: forums-1-dub 1108081952 24.102.107.183 (10 Feb 2005 16:32:32 -0800)
X-Original-Trace: 10 Feb 2005 16:32:32 -0800, cpe0080c6ee7d81-cm024340006571.cpe.net.cable.rogers.com
Lines: 18
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4128
Article PK: 8010

"Frank Vestjens" <FVestjens@InforIT.nl> wrote in news:420b8691$1@forums-1-
dub:

> What is the best way to check what is making my database slow. My customer
> is complaining about the speed of my application.
> How can I check what is causing this slow performance and where should I
> look for.
> Has it sometinhg to do with memory on the machine, do I need to create
> additional indexes.
> Where should I look and what should I use to find things out.
>

You might want to start with the whitepaper we have on improving SQL Anywhere
performance.
http://www.ianywhere.com/whitepapers/sqlany_performance.html

Shuchit