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.

Batch and OLTP

4 posts in General Discussion Last posting was on 2012-02-16 05:28:52.0Z
RGS Posted on 2012-02-14 18:40:23.0Z
Sender: 6a0b.4f3aa7d8.1804289383@sybase.com
From: RGS
Newsgroups: sybase.public.ase.general
Subject: Batch and OLTP
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4f3aaa97.6a81.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 14 Feb 2012 10:40:23 -0800
X-Trace: forums-1-dub 1329244823 172.20.134.41 (14 Feb 2012 10:40:23 -0800)
X-Original-Trace: 14 Feb 2012 10:40:23 -0800, 172.20.134.41
Lines: 17
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:30916
Article PK: 73805

I am using ASE 15.5

We need to run OLTP and Batch Processes at the same time

OLTP systems use a "online" user and Batch Processes use a
"batch" user

How can I asign more priority to "online" user?

Can you explain me the "time slice" concept? If I have a
stored procedure with 100 commands inside, ASE execute only
a part of the program, nexy give a portion of time of the
resource to another process or ASE has to execute all
commands in the SP before it can give a portion of time to
another process?

Thanks!


peta62 Posted on 2012-02-14 19:34:07.0Z
From: peta62 <no@mail.com>
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:8.0) Gecko/20111105 Thunderbird/8.0
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: Batch and OLTP
References: <4f3aaa97.6a81.1681692777@sybase.com>
In-Reply-To: <4f3aaa97.6a81.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4f3ab72f@forums-1-dub>
Date: 14 Feb 2012 11:34:07 -0800
X-Trace: forums-1-dub 1329248047 10.22.241.152 (14 Feb 2012 11:34:07 -0800)
X-Original-Trace: 14 Feb 2012 11:34:07 -0800, vip152.sybase.com
Lines: 30
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:30917
Article PK: 73807

Hello,
I think this part of manual explains is very well :
http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.dc20020_1251/html/databases/X14941.htm

but you may also want to check :
http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.dc20020_1251/html/databases/X63915.htm

Best regards,
Peter

On 2/14/2012 7:40 PM, RGS wrote:
> I am using ASE 15.5
>
> We need to run OLTP and Batch Processes at the same time
>
> OLTP systems use a "online" user and Batch Processes use a
> "batch" user
>
> How can I asign more priority to "online" user?
>
> Can you explain me the "time slice" concept? If I have a
> stored procedure with 100 commands inside, ASE execute only
> a part of the program, nexy give a portion of time of the
> resource to another process or ASE has to execute all
> commands in the SP before it can give a portion of time to
> another process?
>
> Thanks!


Manish Negandhi [TeamSybase] Posted on 2012-02-15 03:30:02.0Z
From: "Manish Negandhi [TeamSybase]" <nospam_negandhi.manish@gmail.com>
Newsgroups: sybase.public.ase.general
References: <4f3aaa97.6a81.1681692777@sybase.com>
Subject: Re: Batch and OLTP
Lines: 52
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3664
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3664
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4f3b26ba@forums-1-dub>
Date: 14 Feb 2012 19:30:02 -0800
X-Trace: forums-1-dub 1329276602 10.22.241.152 (14 Feb 2012 19:30:02 -0800)
X-Original-Trace: 14 Feb 2012 19:30:02 -0800, vip152.sybase.com
X-Authenticated-User: teamsybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:30918
Article PK: 73808

You might want to look at how execution class works in ASE. Execution class
can prioritize one process over other which is what you want





For example, assuming you are running with 10 cpus, you can create an
engine group with 7 cpus and bind "online" user to the corresponding
execution class which is bound to that engine group

Remaining 3 cpus can be used by "batch" user. You need to first test what
works best in your environment for this type of workload before implementing
it into production. Another idea would be to bind "online" user to EC1 group



Here is link mentioning how it works



http://infocenter.sybase.com/help/topic/com.sybase.dc20020_1251/html/databases/X23253.htm





-HTH

Manish Negandhi
[TeamSybase]

<RGS> wrote in message news:4f3aaa97.6a81.1681692777@sybase.com...
>I am using ASE 15.5
>
> We need to run OLTP and Batch Processes at the same time
>
> OLTP systems use a "online" user and Batch Processes use a
> "batch" user
>
> How can I asign more priority to "online" user?
>
> Can you explain me the "time slice" concept? If I have a
> stored procedure with 100 commands inside, ASE execute only
> a part of the program, nexy give a portion of time of the
> resource to another process or ASE has to execute all
> commands in the SP before it can give a portion of time to
> another process?
>
> Thanks!


Cory Sane [TeamSybase] Posted on 2012-02-16 05:28:52.0Z
From: "Cory Sane [TeamSybase]" <cory!=sane>
Newsgroups: sybase.public.ase.general
References: <4f3aaa97.6a81.1681692777@sybase.com>
In-Reply-To: <4f3aaa97.6a81.1681692777@sybase.com>
Subject: Re: Batch and OLTP
Lines: 33
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Windows Mail 6.0.6002.18197
X-MimeOLE: Produced By Microsoft MimeOLE V6.0.6002.18463
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4f3c9414$1@forums-1-dub>
Date: 15 Feb 2012 21:28:52 -0800
X-Trace: forums-1-dub 1329370132 10.22.241.152 (15 Feb 2012 21:28:52 -0800)
X-Original-Trace: 15 Feb 2012 21:28:52 -0800, vip152.sybase.com
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:30920
Article PK: 73810

RGS,

AS best that I understand...
A timeslice only comes into play if there is no physical or network i/o... A timeslice will cause a process to stop running if a
physical or network i/o has not already cause the process to step off of the running processor.

Depending on your testing, you may find that oltp & batch queries can co-exist without problems.
You may be able to better tune the named caches and bound objects than worry about the changes to the run scheduler.


--
Cory Sane
[TeamSybase]
Certified Sybase Associate DBA for ASE 15.0

"RGS" wrote in message news:4f3aaa97.6a81.1681692777@sybase.com...
>I am using ASE 15.5
>
> We need to run OLTP and Batch Processes at the same time
>
> OLTP systems use a "online" user and Batch Processes use a
> "batch" user
>
> How can I asign more priority to "online" user?
>
> Can you explain me the "time slice" concept? If I have a
> stored procedure with 100 commands inside, ASE execute only
> a part of the program, nexy give a portion of time of the
> resource to another process or ASE has to execute all
> commands in the SP before it can give a portion of time to
> another process?
>
> Thanks!