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.

execution classes

2 posts in Windows NT Last posting was on 2000-10-31 21:14:17.0Z
Robert de Jager Posted on 2000-10-31 14:13:34.0Z
From: "Robert de Jager" <r.dejager@isah.nl>
Subject: execution classes
Date: Tue, 31 Oct 2000 15:13:34 +0100
Lines: 16
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
Message-ID: <ejMG0Y0QAHA.275@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: dyn.dailup.c227128219.isd.to 213.227.128.219
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:1534
Article PK: 1089015

Hi,

We are running ASE 11.5.1 EBF 8158. The machine on which NT4 is installed is
equiped with a single cpu. We are running some experiments with the binding
of a specific sp to different execution classes in the server
(high/medium/low). However whichever execution-class is choosen we notice no
difference in the total-runtime of the specific sp nor do we notice any
difference in the 'trouble' other processes are having from the sp in
question at the moment that sp is running.

Anyone having experiences with using execution-classes in their
applications?

Regards, Robert


Rob Verschoor Posted on 2000-10-31 21:14:17.0Z
Reply-To: "Rob Verschoor" <rob@sypron.nl>
From: "Rob Verschoor" <rob@sypron.nl>
References: <ejMG0Y0QAHA.275@forums.sybase.com>
Subject: Re: execution classes
Date: Tue, 31 Oct 2000 22:14:17 +0100
Lines: 53
Organization: Sypron B.V.
X-Newsreader: Microsoft Outlook Express 5.00.2919.6600
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
Message-ID: <BZWiyG4QAHA.162@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: i0326.pvu.euronet.nl 194.134.165.71
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:1531
Article PK: 1089009


"Robert de Jager" <r.dejager@isah.nl> wrote in message
news:ejMG0Y0QAHA.275@forums.sybase.com...
> Hi,
>
> We are running ASE 11.5.1 EBF 8158. The machine on which NT4 is
installed is
> equiped with a single cpu. We are running some experiments with the
binding
> of a specific sp to different execution classes in the server
> (high/medium/low). However whichever execution-class is choosen we
notice no
> difference in the total-runtime of the specific sp nor do we notice
any
> difference in the 'trouble' other processes are having from the sp
in
> question at the moment that sp is running.
>
> Anyone having experiences with using execution-classes in their
> applications?
>
> Regards, Robert

Robert,

Execution classes is a feature which is really aimed at ASE servers
using multiple engines. Typically, you'd find this feature in
environments with heavy hardware (GBytes of memory and with many
CPUs), many users and a high workload.
With all respect for your system, a single-processor NT machine is not
the sort of system that would be likely to benefit from using
execution classes. I would expect that you wouldn't see much
difference anyway (as you already indicate).
When you're having performance problems, it might be more useful to
have a look at the algorithms and queries of the application and
stored procedures.

HTH,

Rob
----------------------------------------------------------------------
Rob Verschoor

Certified Sybase Professional DBA for ASE 12.0
Certified Sybase Professional DBA/SQL Developer for ASE 11.5
Certified DBA/Performance & Tuning Specialist for Sybase System 11

email mailto:rob@sypron.nl.*No*Spam*Please*
WWW http://www.sypron.nl
snail Sypron B.V., P.O.Box 10695, 2501HR Den Haag, The Netherlands
----------------------------------------------------------------------