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.

deeper profiling?

2 posts in General Discussion Last posting was on 2005-07-28 19:32:26.0Z
John Davey Posted on 2005-07-27 09:11:56.0Z
From: "John Davey" <john.davey@automationpartnership.com>
Newsgroups: ianywhere.public.general
Subject: deeper profiling?
Lines: 26
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
X-Original-NNTP-Posting-Host: tap.theautomationpartnership.co.uk
Message-ID: <42e74fd6$1@forums-2-dub>
X-Original-Trace: 27 Jul 2005 02:11:50 -0700, tap.theautomationpartnership.co.uk
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 27 Jul 2005 02:11:53 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 27 Jul 2005 02:11:56 -0700
X-Trace: forums-1-dub 1122455516 10.22.108.75 (27 Jul 2005 02:11:56 -0700)
X-Original-Trace: 27 Jul 2005 02:11:56 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4647
Article PK: 8454

ASA v9.0.2.2551 on Windows XP

I am interested in gaining an understanding of just where my large and
complex application (operating on a fairly large, pretty complex and very
dynamic database) is spending all its time. I know I can use request-level
logging and profiling; these are great and certainly have given me a lot of
information. My question is whether there are any other ways to understand
where the database engine is spending its time;

- can I find out how much time is being spent maintaining indexes? if so,
which ones?
- which are most significant performance monitor indicators, and how do I
interpret them?
- any other ways to see what is happening inside the engine?

This is not a question in response to a specific event - I know that I can
investigate individual cases and queries in all kinds of ways using query
plans and index consultant - this is more in the nature of how to set up a
monitoring regime to allow me to pick out the most useful areas of the
application to optimise.

Thanks for any ideas,

John Davey


"Rob Waywell" <rwaywell Posted on 2005-07-28 19:32:26.0Z
From: "Rob Waywell" <rwaywell@no_spam.ianywhere.com>
Newsgroups: ianywhere.public.general
References: <42e74fd6$1@forums-2-dub>
Subject: Re: deeper profiling?
Lines: 77
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
X-Original-NNTP-Posting-Host: rwaywell-xp.sybase.com
Message-ID: <42e932c4$1@forums-2-dub>
X-Original-Trace: 28 Jul 2005 12:32:20 -0700, rwaywell-xp.sybase.com
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 28 Jul 2005 12:32:23 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 28 Jul 2005 12:32:26 -0700
X-Trace: forums-1-dub 1122579146 10.22.108.75 (28 Jul 2005 12:32:26 -0700)
X-Original-Trace: 28 Jul 2005 12:32:26 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:4655
Article PK: 8460

Hi John,
Here are a few comments as a starting point:

1) For indexes, your best tool is the index consultant. It won't tell you
how much time is spent maintaining indexes, but it will do a cost-benefit
analysis and tell you if we think you have indexes that are not worth the
cost of maintaining.

2) The most significant performance monitor indicators depend on where your
bottleneck is. I don't usually get down to perfmon itself. I do use Task
Manager to see CPU and Disk utilization for the server process.

3) There are a number of server properties that could be monitored, in order
to give meaningful input we really need a specific issue to look at:

ASA Database Administration Guide

Database Performance and Connection Properties

Database properties

Server-level properties



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

"John Davey" <john.davey@automationpartnership.com> wrote in message
news:42e74fd6$1@forums-2-dub...
> ASA v9.0.2.2551 on Windows XP
>
> I am interested in gaining an understanding of just where my large and
> complex application (operating on a fairly large, pretty complex and very
> dynamic database) is spending all its time. I know I can use request-level
> logging and profiling; these are great and certainly have given me a lot
> of
> information. My question is whether there are any other ways to understand
> where the database engine is spending its time;
>
> - can I find out how much time is being spent maintaining indexes? if so,
> which ones?
> - which are most significant performance monitor indicators, and how do I
> interpret them?
> - any other ways to see what is happening inside the engine?
>
> This is not a question in response to a specific event - I know that I can
> investigate individual cases and queries in all kinds of ways using query
> plans and index consultant - this is more in the nature of how to set up a
> monitoring regime to allow me to pick out the most useful areas of the
> application to optimise.
>
> Thanks for any ideas,
>
> John Davey
>
>