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.

Performance woes.

3 posts in Migration Last posting was on 2001-01-04 20:48:26.0Z
David_LaFlamme Posted on 2001-01-03 15:02:19.0Z
From: David_LaFlamme
Date: Wed, 3 Jan 2001 10:02:19 -0500
Newsgroups: sybase.public.sqlserver.migration
Subject: Performance woes.
Message-ID: <C3939CC6D40947EC00529C18852569C9.00529C27852569C9@webforums>
Lines: 10
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub sybase.public.sqlserver.migration:328
Article PK: 1067753

Hi,
Our application has experienced many performance problems since upgrading
from 11.0.3
to 11.9.2 on AIX. One customer has experienced a general slowdown on
high throughput processing jobs. Are there any configuration settings that
I should look into
to overcome the problems? Help appreciated.

Thanks,
David


Rey Wang Posted on 2001-01-04 20:48:26.0Z
From: "Rey Wang" <lucky0505@worldnet.att.net>
References: <C3939CC6D40947EC00529C18852569C9.00529C27852569C9@webforums>
Subject: Re: Performance woes.
Date: Thu, 4 Jan 2001 15:48:26 -0500
Lines: 34
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4133.2400
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400
Message-ID: <#vMB#EpdAHA.267@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.migration
NNTP-Posting-Host: 224.newark-23-24rs.nj.dial-access.att.net 12.89.137.224
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.migration:322
Article PK: 1067746

It is better off if you can tell us which release you just upgrade and
server configuration.

In general, you might counter those issues:
1. data mismatch
2. bugs in string like clause
3. distinct mix with order which I saw some queries are much worse in ASE 12
or 11.9,2
4. query with desc might have problem, then you can turn desc option off in
server configuration

For DW type queries, many table joins, ASE 12 beats Sybase SQL 11.0.3 could
be 10 times faster.
But your users won't thank you about this though.

Rey Wang
www.dbmethods.com

<David_LaFlamme> wrote in message
news:C3939CC6D40947EC00529C18852569C9.00529C27852569C9@webforums...
> Hi,
> Our application has experienced many performance problems since upgrading
> from 11.0.3
> to 11.9.2 on AIX. One customer has experienced a general slowdown on
> high throughput processing jobs. Are there any configuration settings
that
> I should look into
> to overcome the problems? Help appreciated.
>
> Thanks,
> David


Anthony Mandic <am Posted on 2001-01-04 03:42:41.0Z
Date: Thu, 04 Jan 2001 14:42:41 +1100
From: Anthony Mandic <am@*t.com.au>
Organization: Mandic Consulting Pty. Ltd.
X-Mailer: Mozilla 4.72 [en] (X11; U; Linux 2.2.14-5.0 i686)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: Performance woes.
References: <C3939CC6D40947EC00529C18852569C9.00529C27852569C9@webforums>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Message-ID: <HSn7pJgdAHA.294@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.migration
Lines: 22
NNTP-Posting-Host: 210.9.51.46
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.migration:326
Article PK: 1067749


David_LaFlamme wrote:

> Our application has experienced many performance problems since upgrading
> from 11.0.3 to 11.9.2 on AIX. One customer has experienced a general slowdown
> on high throughput processing jobs. Are there any configuration settings that
> I should look into to overcome the problems?

It might be better to ask in the performance+tuning newsgroup where
you'll likely get a better response as well as find a lot of similar
posts. Michael P.'s suggestion of mismatched datatypes is one worth
checking. Checking the stats with the optdiag utility is also very
useful. The other things you can do is capture some of the queries
for analysis by running auditing or using sp_showplan on running
queries that you think are slow and examine the plan. However, some
of the trace flags available may provide better insight.

-am