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.

Stored procedure caching

2 posts in Cluster Last posting was on 2008-07-07 15:07:30.0Z
Joe Gard Posted on 2008-07-07 14:42:48.0Z
Sender: 2f14.4872298d.1804289383@sybase.com
From: Joe Gard
Newsgroups: sybase.public.ase.cluster
Subject: Stored procedure caching
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <48722b68.2f72.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 7 Jul 2008 07:42:48 -0700
X-Trace: forums-1-dub 1215441768 10.22.241.41 (7 Jul 2008 07:42:48 -0700)
X-Original-Trace: 7 Jul 2008 07:42:48 -0700, 10.22.241.41
Lines: 10
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.cluster:83
Article PK: 48367

We have migrated from Sybase 12.3 to Sybase 15.0.2 ...

We have stored procedures that are now running longer. When
we run the SQL outside of the stored procedure, the results
are coming back in milliseconds. However, when the stored
procedure runs, the same SQL is very slow.

Is there something in Sybase 15 that we should be looking at
that has to do with stored procedure cache ? Is there
somewhere else that will help us identify the problem ..


Sherlock, Kevin Posted on 2008-07-07 15:07:30.0Z
From: "Sherlock, Kevin" <kevin.sherlock@teamsybase.com>
Newsgroups: sybase.public.ase.cluster
References: <48722b68.2f72.1681692777@sybase.com>
Subject: Re: Stored procedure caching
Lines: 22
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <48723132@forums-1-dub>
Date: 7 Jul 2008 08:07:30 -0700
X-Trace: forums-1-dub 1215443250 10.22.241.152 (7 Jul 2008 08:07:30 -0700)
X-Original-Trace: 7 Jul 2008 08:07:30 -0700, vip152.sybase.com
X-Authenticated-User: teamsybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.cluster:85
Article PK: 48368

Joe,
This is probably the wrong forum to ask this question. This is the
newsgroup for the Cluster Edition of ASE.

You would more likely get more eyes looking at your question if you post it
to

sybase.public.ase.performance+tuning

<Joe Gard> wrote in message news:48722b68.2f72.1681692777@sybase.com...
> We have migrated from Sybase 12.3 to Sybase 15.0.2 ...
>
> We have stored procedures that are now running longer. When
> we run the SQL outside of the stored procedure, the results
> are coming back in milliseconds. However, when the stored
> procedure runs, the same SQL is very slow.
>
> Is there something in Sybase 15 that we should be looking at
> that has to do with stored procedure cache ? Is there
> somewhere else that will help us identify the problem ..