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 counter requests:Active and unscheduled

12 posts in General Discussion Last posting was on 2008-06-19 15:38:25.0Z
Kim Truong Posted on 2008-06-16 01:24:16.0Z
Sender: 5080.4855b883.1804289383@sybase.com
From: Kim Truong
Newsgroups: ianywhere.public.general
Subject: Performance counter requests:Active and unscheduled
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4855c0c0.516d.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 15 Jun 2008 18:24:16 -0700
X-Trace: forums-1-dub 1213579456 10.22.241.41 (15 Jun 2008 18:24:16 -0700)
X-Original-Trace: 15 Jun 2008 18:24:16 -0700, 10.22.241.41
Lines: 10
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6903
Article PK: 5131

Hi,

I have set our ASA 9.0 server with the option of -gn 150. So
there number of active request 150. When I was monitoring
the Performance counters, I noticed that the active request
counter was 0-40 and the request unscheduled counter was
also 4-42.

The active request has not maxed to 150 and there is
unschedule request. Why is there still unschedule request?


Glenn Paulley [iablog.sybase.com/paulley] Posted on 2008-06-16 01:36:17.0Z
From: "Glenn Paulley [iablog.sybase.com/paulley]" <paulley@ianywhere.com>
Reply-To: paulley@ianywhere.com
Organization: Sybase iAnywhere
User-Agent: Thunderbird 2.0.0.14 (Windows/20080421)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Performance counter requests:Active and unscheduled
References: <4855c0c0.516d.1681692777@sybase.com>
In-Reply-To: <4855c0c0.516d.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: <4855c391$1@forums-1-dub>
Date: 15 Jun 2008 18:36:17 -0700
X-Trace: forums-1-dub 1213580177 10.22.241.152 (15 Jun 2008 18:36:17 -0700)
X-Original-Trace: 15 Jun 2008 18:36:17 -0700, vip152.sybase.com
Lines: 38
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6904
Article PK: 5130

a) Precisely which version and build of 9.x are you using?

b) does your application utilize Java procedures or web services?

Glenn

Kim Truong wrote:
> Hi,
>
> I have set our ASA 9.0 server with the option of -gn 150. So
> there number of active request 150. When I was monitoring
> the Performance counters, I noticed that the active request
> counter was 0-40 and the request unscheduled counter was
> also 4-42.
>
> The active request has not maxed to 150 and there is
> unschedule request. Why is there still unschedule request?

--
Glenn Paulley
Director, Engineering (Query Processing)
Sybase iAnywhere

Blog: http://iablog.sybase.com/paulley

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

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
Sybase iAnywhere pages at
http://www.sybase.com/products/databasemanagement/sqlanywhere/technicalsupport


Kim Truong Posted on 2008-06-16 02:15:05.0Z
Sender: 5080.4855b883.1804289383@sybase.com
From: Kim Truong
Newsgroups: ianywhere.public.general
Subject: Re: Performance counter requests:Active and unscheduled
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4855cca9.52a7.1681692777@sybase.com>
References: <4855c391$1@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 15 Jun 2008 19:15:05 -0700
X-Trace: forums-1-dub 1213582505 10.22.241.41 (15 Jun 2008 19:15:05 -0700)
X-Original-Trace: 15 Jun 2008 19:15:05 -0700, 10.22.241.41
Lines: 47
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6906
Article PK: 5132

> a) Precisely which version and build of 9.x are you using?

9.0.2.3527

> b) does your application utilize Java procedures or web
> services?

Why? anyway, we are using Jaguar 5.2 as the application
server and I am sure we do have java and web services to
running. We are using ODBC connections to the database.


> Glenn
>
>
> Kim Truong wrote:
> > Hi,
> >
> > I have set our ASA 9.0 server with the option of -gn
> > 150. So there number of active request 150. When I was
> > monitoring the Performance counters, I noticed that the
> > active request counter was 0-40 and the request
> > unscheduled counter was also 4-42.
> >
> > The active request has not maxed to 150 and there is
> > unschedule request. Why is there still unschedule
> request?
>
>
> --
> Glenn Paulley
> Director, Engineering (Query Processing)
> Sybase iAnywhere
>
> Blog: http://iablog.sybase.com/paulley
>
> 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
>
> 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 Sybase iAnywhere pages at
>
http://www.sybase.com/products/databasemanagement/sqlanywhere/technicalsupport


Breck Carter [sqlanywhere.blogspot.com] Posted on 2008-06-16 10:17:07.0Z
From: "Breck Carter [sqlanywhere.blogspot.com]" <NOSPAM__breck.carter@gmail.com>
Newsgroups: ianywhere.public.general
Subject: Re: Performance counter requests:Active and unscheduled
Organization: RisingRoad Professional Services
Reply-To: NOSPAM__breck.carter@gmail.com
Message-ID: <8vec54dr6nm2igsfl8lmkeb2gdd40dgv74@4ax.com>
References: <4855c391$1@forums-1-dub> <4855cca9.52a7.1681692777@sybase.com>
X-Newsreader: Forte Agent 2.0/32.640
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 16 Jun 2008 03:17:07 -0700
X-Trace: forums-1-dub 1213611427 10.22.241.152 (16 Jun 2008 03:17:07 -0700)
X-Original-Trace: 16 Jun 2008 03:17:07 -0700, vip152.sybase.com
Lines: 24
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6907
Article PK: 5133


On 15 Jun 2008 19:15:05 -0700, Kim Truong wrote:
>Why?

Just in case you didn't notice his signature line...

>> Glenn Paulley
>> Director, Engineering (Query Processing)
>> Sybase iAnywhere

...if Glenn asks a question about your use of -gn 150, he probably has
a good reason :)

FWIW section 4.2 of this whitepaper contains a discussion of the
tradeoffs involved in setting very high levels of -gn:
http://www.sybase.com/files/White_Papers/wp_SA_CapacityPlanning.pdf

Breck


--
Breck Carter http://sqlanywhere.blogspot.com/

RisingRoad SQL Anywhere and MobiLink Professional Services
breck.carter@risingroad.com


Glenn Paulley [iablog.sybase.com/paulley] Posted on 2008-06-16 11:07:39.0Z
From: "Glenn Paulley [iablog.sybase.com/paulley]" <paulley@ianywhere.com>
Reply-To: paulley@ianywhere.com
Organization: Sybase iAnywhere
User-Agent: Thunderbird 2.0.0.14 (Windows/20080421)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Performance counter requests:Active and unscheduled
References: <4855c391$1@forums-1-dub> <4855cca9.52a7.1681692777@sybase.com>
In-Reply-To: <4855cca9.52a7.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: <4856497b@forums-1-dub>
Date: 16 Jun 2008 04:07:39 -0700
X-Trace: forums-1-dub 1213614459 10.22.241.152 (16 Jun 2008 04:07:39 -0700)
X-Original-Trace: 16 Jun 2008 04:07:39 -0700, vip152.sybase.com
Lines: 86
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6908
Article PK: 5134

In 9.x, web service requests utilize a kernel task, but since it's not a
"traditional" request I believe the Perfmon requests counter doesn't get
incremented. With external procedures, the server allocates another
kernel task to handle the call, to ensure that if the procedure abends
that there still exists a task to respond to a CANCEL. These additional
tasks also aren't "requests", so their use is not reflected in the
performance counters you're looking at. I believe the above is accurate
- Mohammed can correct me if I've stated something incorrect.

Using -gn of 150, as Breck suggests, has its implications for query
processing. You have to tradeoff stack usage and query memory allocation
for requests, with having additional tasks at the ready to handle
external procedures, if you are using them. In version 10 and up, the
problems above no longer exist - external procedures are called using a
dynamic, independent thread pool that is not affected by the -gn setting.

Glenn

Kim Truong wrote:
>> a) Precisely which version and build of 9.x are you using?
>
> 9.0.2.3527
>
>> b) does your application utilize Java procedures or web
>> services?
> Why? anyway, we are using Jaguar 5.2 as the application
> server and I am sure we do have java and web services to
> running. We are using ODBC connections to the database.
>
>
>> Glenn
>>
>>
>> Kim Truong wrote:
>>> Hi,
>>>
>>> I have set our ASA 9.0 server with the option of -gn
>>> 150. So there number of active request 150. When I was
>>> monitoring the Performance counters, I noticed that the
>>> active request counter was 0-40 and the request
>>> unscheduled counter was also 4-42.
>>>
>>> The active request has not maxed to 150 and there is
>>> unschedule request. Why is there still unschedule
>> request?
>>
>>
>> --
>> Glenn Paulley
>> Director, Engineering (Query Processing)
>> Sybase iAnywhere
>>
>> Blog: http://iablog.sybase.com/paulley
>>
>> 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
>>
>> 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 Sybase iAnywhere pages at
>>
> http://www.sybase.com/products/databasemanagement/sqlanywhere/technicalsupport

--
Glenn Paulley
Director, Engineering (Query Processing)
Sybase iAnywhere

Blog: http://iablog.sybase.com/paulley

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

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
Sybase iAnywhere pages at
http://www.sybase.com/products/databasemanagement/sqlanywhere/technicalsupport


Kim Truong Posted on 2008-06-17 06:22:18.0Z
Sender: 78ec.4856f0af.1804289383@sybase.com
From: Kim Truong
Newsgroups: ianywhere.public.general
Subject: Re: Performance counter requests:Active and unscheduled
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4857581a.509.1681692777@sybase.com>
References: <4856497b@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 16 Jun 2008 23:22:18 -0700
X-Trace: forums-1-dub 1213683738 10.22.241.41 (16 Jun 2008 23:22:18 -0700)
X-Original-Trace: 16 Jun 2008 23:22:18 -0700, 10.22.241.41
Lines: 104
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6910
Article PK: 5136

Thanks Glenn,

I appreciate the response. I guest I should be using those
counters then.

Can I ask is there a way in 9.x that I can used to monitor
threads/request and queue threads/request?

Also does 9.x able to use -gn 150?

> In 9.x, web service requests utilize a kernel task, but
> since it's not a "traditional" request I believe the
> Perfmon requests counter doesn't get incremented. With
> external procedures, the server allocates another kernel
> task to handle the call, to ensure that if the procedure
> abends that there still exists a task to respond to a
> CANCEL. These additional tasks also aren't "requests", so
> their use is not reflected in the performance counters
> you're looking at. I believe the above is accurate -
> Mohammed can correct me if I've stated something
> incorrect.
>
> Using -gn of 150, as Breck suggests, has its implications
> for query processing. You have to tradeoff stack usage
> and query memory allocation for requests, with having
> additional tasks at the ready to handle external
> procedures, if you are using them. In version 10 and up,
> the problems above no longer exist - external procedures
> are called using a dynamic, independent thread pool that
> is not affected by the -gn setting.
>
> Glenn
>
> Kim Truong wrote:
> >> a) Precisely which version and build of 9.x are you
> > using?
> > 9.0.2.3527
> >
> >> b) does your application utilize Java procedures or web
> >> services?
> > Why? anyway, we are using Jaguar 5.2 as the application
> > server and I am sure we do have java and web services to
> > running. We are using ODBC connections to the database.
> >
> >
> >> Glenn
> >>
> >>
> >> Kim Truong wrote:
> >>> Hi,
> >>>
> >>> I have set our ASA 9.0 server with the option of -gn
> >>> 150. So there number of active request 150. When I was
> >>> monitoring the Performance counters, I noticed that
> the >>> active request counter was 0-40 and the request
> >>> unscheduled counter was also 4-42.
> >>>
> >>> The active request has not maxed to 150 and there is
> >>> unschedule request. Why is there still unschedule
> >> request?
> >>
> >>
> >> --
> >> Glenn Paulley
> >> Director, Engineering (Query Processing)
> >> Sybase iAnywhere
> >>
> >> Blog: http://iablog.sybase.com/paulley
> >>
> >> 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
> >>
> >> 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 Sybase iAnywhere pages at
> >>
> >
>
http://www.sybase.com/products/databasemanagement/sqlanywhere/technicalsupport
>
>
> --
> Glenn Paulley
> Director, Engineering (Query Processing)
> Sybase iAnywhere
>
> Blog: http://iablog.sybase.com/paulley
>
> 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
>
> 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 Sybase iAnywhere pages at
>

http://www.sybase.com/products/databasemanagement/sqlanywhere/technicalsupport


Glenn Paulley [iablog.sybase.com/paulley] Posted on 2008-06-17 11:08:04.0Z
From: "Glenn Paulley [iablog.sybase.com/paulley]" <paulley@ianywhere.com>
Reply-To: paulley@ianywhere.com
Organization: Sybase iAnywhere
User-Agent: Thunderbird 2.0.0.14 (Windows/20080421)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Performance counter requests:Active and unscheduled
References: <4856497b@forums-1-dub> <4857581a.509.1681692777@sybase.com>
In-Reply-To: <4857581a.509.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: <48579b14$1@forums-1-dub>
Date: 17 Jun 2008 04:08:04 -0700
X-Trace: forums-1-dub 1213700884 10.22.241.152 (17 Jun 2008 04:08:04 -0700)
X-Original-Trace: 17 Jun 2008 04:08:04 -0700, vip152.sybase.com
Lines: 154
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6911
Article PK: 5137

Answers inlined.

Kim Truong wrote:
> Thanks Glenn,
>
> I appreciate the response. I guest I should be using those
> counters then.
>
> Can I ask is there a way in 9.x that I can used to monitor
> threads/request and queue threads/request?
>

I'm not sure that there is in 9.x. I'll check with Mohammed, but I
believe our monitoring of non-request tasks was only improved in 10.x -
and, at the same time, our kernel architecture was altered so that
non-request tasks no longer conflicted with tasks reserved for
"ordinary" client requests.

> Also does 9.x able to use -gn 150?
>

Yes, but there are tradeoffs. I would argue that 150 is high in
virtually all production scenarios. An exception would be a workload
consisting entirely of small, short SQL requests with no reporting or
memory-intensive operators on a multi-CPU machine.

The tradeoffs are:

- with 150 tasks reserved, each consuming 1MB of stack space, the
address space of the dbsrv9.exe process is lowered by 150MB, meaning
that the largest buffer pool size you can get with a 32-bit server is
now about 1.35MB.
- more problematic is that in a mixed-workload environment,
memory-intensive operators (hash join, hash distinct, sorting) are
allocated only a portion of the total memory available to the server, to
reserve memory in anticipation of other requests.

In your case, a higher multiprogramming level than the default (20) may
certainly be warranted due (1) to your workload and (2) to the use of
additional tasks for web-services and Java procedures. My recommendation
is to be more conservative, start with a -gn of 20 (or 30) and monitor
the system's throughput....then increment by 10 or so with subsequent tests.

Glenn
>> In 9.x, web service requests utilize a kernel task, but
>> since it's not a "traditional" request I believe the
>> Perfmon requests counter doesn't get incremented. With
>> external procedures, the server allocates another kernel
>> task to handle the call, to ensure that if the procedure
>> abends that there still exists a task to respond to a
>> CANCEL. These additional tasks also aren't "requests", so
>> their use is not reflected in the performance counters
>> you're looking at. I believe the above is accurate -
>> Mohammed can correct me if I've stated something
>> incorrect.
>>
>> Using -gn of 150, as Breck suggests, has its implications
>> for query processing. You have to tradeoff stack usage
>> and query memory allocation for requests, with having
>> additional tasks at the ready to handle external
>> procedures, if you are using them. In version 10 and up,
>> the problems above no longer exist - external procedures
>> are called using a dynamic, independent thread pool that
>> is not affected by the -gn setting.
>>
>> Glenn
>>
>> Kim Truong wrote:
>>>> a) Precisely which version and build of 9.x are you
>>> using?
>>> 9.0.2.3527
>>>
>>>> b) does your application utilize Java procedures or web
>>>> services?
>>> Why? anyway, we are using Jaguar 5.2 as the application
>>> server and I am sure we do have java and web services to
>>> running. We are using ODBC connections to the database.
>>>
>>>
>>>> Glenn
>>>>
>>>>
>>>> Kim Truong wrote:
>>>>> Hi,
>>>>>
>>>>> I have set our ASA 9.0 server with the option of -gn
>>>>> 150. So there number of active request 150. When I was
>>>>> monitoring the Performance counters, I noticed that
>> the >>> active request counter was 0-40 and the request
>>>>> unscheduled counter was also 4-42.
>>>>>
>>>>> The active request has not maxed to 150 and there is
>>>>> unschedule request. Why is there still unschedule
>>>> request?
>>>>
>>>>
>>>> --
>>>> Glenn Paulley
>>>> Director, Engineering (Query Processing)
>>>> Sybase iAnywhere
>>>>
>>>> Blog: http://iablog.sybase.com/paulley
>>>>
>>>> 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
>>>>
>>>> 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 Sybase iAnywhere pages at
>>>>
> http://www.sybase.com/products/databasemanagement/sqlanywhere/technicalsupport
>>
>> --
>> Glenn Paulley
>> Director, Engineering (Query Processing)
>> Sybase iAnywhere
>>
>> Blog: http://iablog.sybase.com/paulley
>>
>> 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
>>
>> 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 Sybase iAnywhere pages at
>>
> http://www.sybase.com/products/databasemanagement/sqlanywhere/technicalsupport


--
Glenn Paulley
Director, Engineering (Query Processing)
Sybase iAnywhere

Blog: http://iablog.sybase.com/paulley

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

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
Sybase iAnywhere pages at
http://www.sybase.com/products/databasemanagement/sqlanywhere/technicalsupport


Kim Truong Posted on 2008-06-17 23:51:45.0Z
Sender: 78ec.4856f0af.1804289383@sybase.com
From: Kim Truong
Newsgroups: ianywhere.public.general
Subject: Re: Performance counter requests:Active and unscheduled
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <48584e11.2c65.1681692777@sybase.com>
References: <48579b14$1@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 17 Jun 2008 16:51:45 -0700
X-Trace: forums-1-dub 1213746705 10.22.241.41 (17 Jun 2008 16:51:45 -0700)
X-Original-Trace: 17 Jun 2008 16:51:45 -0700, 10.22.241.41
Lines: 171
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6912
Article PK: 5138

Thanks Glenn,

I'll speak to my managers regarding the possibity of an
upgrade.

Thanks again for the prompted response.

> Answers inlined.
>
> Kim Truong wrote:
> > Thanks Glenn,
> >
> > I appreciate the response. I guest I should be using
> > those counters then.
> >
> > Can I ask is there a way in 9.x that I can used to
> > monitor threads/request and queue threads/request?
> >
>
> I'm not sure that there is in 9.x. I'll check with
> Mohammed, but I believe our monitoring of non-request
> tasks was only improved in 10.x - and, at the same time,
> our kernel architecture was altered so that non-request
> tasks no longer conflicted with tasks reserved for
> "ordinary" client requests.
>
> > Also does 9.x able to use -gn 150?
> >
>
> Yes, but there are tradeoffs. I would argue that 150 is
> high in virtually all production scenarios. An exception
> would be a workload consisting entirely of small, short
> SQL requests with no reporting or memory-intensive
> operators on a multi-CPU machine.
>
> The tradeoffs are:
>
> - with 150 tasks reserved, each consuming 1MB of stack
> space, the address space of the dbsrv9.exe process is
> lowered by 150MB, meaning that the largest buffer pool
> size you can get with a 32-bit server is now about
> 1.35MB. - more problematic is that in a mixed-workload
> environment, memory-intensive operators (hash join, hash
> distinct, sorting) are allocated only a portion of the
> total memory available to the server, to reserve memory
> in anticipation of other requests.
>
> In your case, a higher multiprogramming level than the
> default (20) may certainly be warranted due (1) to your
> workload and (2) to the use of additional tasks for
> web-services and Java procedures. My recommendation is to
> be more conservative, start with a -gn of 20 (or 30) and
> monitor the system's throughput....then increment by 10
> or so with subsequent tests.
>
> Glenn
> >> In 9.x, web service requests utilize a kernel task, but
> >> since it's not a "traditional" request I believe the
> >> Perfmon requests counter doesn't get incremented. With
> >> external procedures, the server allocates another
> kernel >> task to handle the call, to ensure that if the
> procedure >> abends that there still exists a task to
> respond to a >> CANCEL. These additional tasks also
> aren't "requests", so >> their use is not reflected in the
> performance counters >> you're looking at. I believe the
> above is accurate - >> Mohammed can correct me if I've
> stated something >> incorrect.
> >>
> >> Using -gn of 150, as Breck suggests, has its
> implications >> for query processing. You have to
> tradeoff stack usage >> and query memory allocation for
> requests, with having >> additional tasks at the ready to
> handle external >> procedures, if you are using them. In
> version 10 and up, >> the problems above no longer exist
> - external procedures >> are called using a dynamic,
> independent thread pool that >> is not affected by the -gn
> setting. >>
> >> Glenn
> >>
> >> Kim Truong wrote:
> >>>> a) Precisely which version and build of 9.x are you
> >>> using?
> >>> 9.0.2.3527
> >>>
> >>>> b) does your application utilize Java procedures or
> web >>>> services?
> >>> Why? anyway, we are using Jaguar 5.2 as the
> application >>> server and I am sure we do have java and
> web services to >>> running. We are using ODBC connections
> to the database. >>>
> >>>
> >>>> Glenn
> >>>>
> >>>>
> >>>> Kim Truong wrote:
> >>>>> Hi,
> >>>>>
> >>>>> I have set our ASA 9.0 server with the option of -gn
> >>>>> 150. So there number of active request 150. When I
> was >>>>> monitoring the Performance counters, I noticed
> that >> the >>> active request counter was 0-40 and the
> request >>>>> unscheduled counter was also 4-42.
> >>>>>
> >>>>> The active request has not maxed to 150 and there is
> >>>>> unschedule request. Why is there still unschedule
> >>>> request?
> >>>>
> >>>>
> >>>> --
> >>>> Glenn Paulley
> >>>> Director, Engineering (Query Processing)
> >>>> Sybase iAnywhere
> >>>>
> >>>> Blog: http://iablog.sybase.com/paulley
> >>>>
> >>>> 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
> >>>>
> >>>> 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 Sybase iAnywhere pages at
> >>>>
> >
>
http://www.sybase.com/products/databasemanagement/sqlanywhere/technicalsupport
> >>
> >> --
> >> Glenn Paulley
> >> Director, Engineering (Query Processing)
> >> Sybase iAnywhere
> >>
> >> Blog: http://iablog.sybase.com/paulley
> >>
> >> 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
> >>
> >> 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 Sybase iAnywhere pages at
> >>
> >
>
http://www.sybase.com/products/databasemanagement/sqlanywhere/technicalsupport
>
>
> --
> Glenn Paulley
> Director, Engineering (Query Processing)
> Sybase iAnywhere
>
> Blog: http://iablog.sybase.com/paulley
>
> 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
>
> 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 Sybase iAnywhere pages at
>

http://www.sybase.com/products/databasemanagement/sqlanywhere/technicalsupport


Breck Carter [sqlanywhere.blogspot.com] Posted on 2008-06-18 10:52:26.0Z
From: "Breck Carter [sqlanywhere.blogspot.com]" <NOSPAM__breck.carter@gmail.com>
Newsgroups: ianywhere.public.general
Subject: Re: Performance counter requests:Active and unscheduled
Organization: RisingRoad Professional Services
Reply-To: NOSPAM__breck.carter@gmail.com
Message-ID: <9tph54ddgss0ta5bn96h7220nphdnepmc0@4ax.com>
References: <4856497b@forums-1-dub> <4857581a.509.1681692777@sybase.com> <48579b14$1@forums-1-dub>
X-Newsreader: Forte Agent 2.0/32.640
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 18 Jun 2008 03:52:26 -0700
X-Trace: forums-1-dub 1213786346 10.22.241.152 (18 Jun 2008 03:52:26 -0700)
X-Original-Trace: 18 Jun 2008 03:52:26 -0700, vip152.sybase.com
Lines: 22
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6916
Article PK: 5141

On 17 Jun 2008 04:08:04 -0700, "Glenn Paulley

[iablog.sybase.com/paulley]" <paulley@ianywhere.com> wrote:

>a workload
>consisting entirely of small, short SQL requests

FWIW I think that characterizes a busy V9 web service application, or
a V10 application not using the new session support, where each web
service gets its own database connection. If the application is
serving up a website where each page has dozens of HTTP connections,
say, to serve up teeny images, and each of those HTTP connections
fires up a SQL Anywhere web service, then voila! bazillions of
short-lived low-overhead database connections. Tons of activity and
nothing showing in a monitor (say, like Foxhound).

Breck

--
Breck Carter http://sqlanywhere.blogspot.com/

RisingRoad SQL Anywhere and MobiLink Professional Services
breck.carter@risingroad.com


Jeff Albion (Sybase iAnywhere) Posted on 2008-06-18 14:32:38.0Z
From: "Jeff Albion (Sybase iAnywhere)" <firstname.lastname@ianywhere.com>
User-Agent: Thunderbird 2.0.0.14 (Windows/20080421)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Performance counter requests:Active and unscheduled
References: <4856497b@forums-1-dub> <4857581a.509.1681692777@sybase.com> <48579b14$1@forums-1-dub> <9tph54ddgss0ta5bn96h7220nphdnepmc0@4ax.com>
In-Reply-To: <9tph54ddgss0ta5bn96h7220nphdnepmc0@4ax.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: <48591c86$1@forums-1-dub>
Date: 18 Jun 2008 07:32:38 -0700
X-Trace: forums-1-dub 1213799558 10.22.241.152 (18 Jun 2008 07:32:38 -0700)
X-Original-Trace: 18 Jun 2008 07:32:38 -0700, vip152.sybase.com
Lines: 23
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6918
Article PK: 5144


Breck Carter [sqlanywhere.blogspot.com] wrote:
> fires up a SQL Anywhere web service, then voila! bazillions of
> short-lived low-overhead database connections. Tons of activity and
> nothing showing in a monitor (say, like Foxhound).

Well, a SQL Anywhere HTTP Web Service can prevent this type of
connection activity by using HTTP Sessions (See:
http://www.ianywhere.com/developer/product_manuals/sqlanywhere/1001/en/html/dbpgen10/pg-http-session.html
).

However, a SOAP service definitely will display that type of activity
since there is no (universal) session equivalent for such requests. ;)

Cheers,

--
Jeff Albion, Product Support Analyst
Sybase iAnywhere

iAnywhere Developer Community : http://www.ianywhere.com/developer
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
ASA Patches and EBFs :
http://downloads.sybase.com/swd/summary.do?baseprod=144&client=ianywhere&timeframe=0


Breck Carter [sqlanywhere.blogspot.com] Posted on 2008-06-19 14:38:33.0Z
From: "Breck Carter [sqlanywhere.blogspot.com]" <NOSPAM__breck.carter@gmail.com>
Newsgroups: ianywhere.public.general
Subject: Re: Performance counter requests:Active and unscheduled
Organization: RisingRoad Professional Services
Reply-To: NOSPAM__breck.carter@gmail.com
Message-ID: <uprk54dede5qcfom7euu20mmacm79cq54q@4ax.com>
References: <4856497b@forums-1-dub> <4857581a.509.1681692777@sybase.com> <48579b14$1@forums-1-dub> <9tph54ddgss0ta5bn96h7220nphdnepmc0@4ax.com> <48591c86$1@forums-1-dub>
X-Newsreader: Forte Agent 2.0/32.640
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 19 Jun 2008 07:38:33 -0700
X-Trace: forums-1-dub 1213886313 10.22.241.152 (19 Jun 2008 07:38:33 -0700)
X-Original-Trace: 19 Jun 2008 07:38:33 -0700, vip152.sybase.com
Lines: 15
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6920
Article PK: 5147

On 18 Jun 2008 07:32:38 -0700, "Jeff Albion (Sybase iAnywhere)"

<firstname.lastname@ianywhere.com> wrote:

>Well, a SQL Anywhere HTTP Web Service can prevent this type of
>connection activity by using HTTP Sessions

wellllll... I *did* say "a V10 application not using the new session
support"... :)


--
Breck Carter http://sqlanywhere.blogspot.com/

RisingRoad SQL Anywhere and MobiLink Professional Services
breck.carter@risingroad.com


Jeff Albion (Sybase iAnywhere) Posted on 2008-06-19 15:38:25.0Z
From: "Jeff Albion (Sybase iAnywhere)" <firstname.lastname@ianywhere.com>
User-Agent: Thunderbird 2.0.0.14 (Windows/20080421)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Performance counter requests:Active and unscheduled
References: <4856497b@forums-1-dub> <4857581a.509.1681692777@sybase.com> <48579b14$1@forums-1-dub> <9tph54ddgss0ta5bn96h7220nphdnepmc0@4ax.com> <48591c86$1@forums-1-dub> <uprk54dede5qcfom7euu20mmacm79cq54q@4ax.com>
In-Reply-To: <uprk54dede5qcfom7euu20mmacm79cq54q@4ax.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: <485a7d71$1@forums-1-dub>
Date: 19 Jun 2008 08:38:25 -0700
X-Trace: forums-1-dub 1213889905 10.22.241.152 (19 Jun 2008 08:38:25 -0700)
X-Original-Trace: 19 Jun 2008 08:38:25 -0700, vip152.sybase.com
Lines: 14
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:6921
Article PK: 5146

Yes, yes you did. My mistake! :)

Breck Carter [sqlanywhere.blogspot.com] wrote:
> wellllll... I *did* say "a V10 application not using the new session
> support"... :)

--
Jeff Albion, Product Support Analyst
Sybase iAnywhere

iAnywhere Developer Community : http://www.ianywhere.com/developer
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
ASA Patches and EBFs :
http://downloads.sybase.com/swd/summary.do?baseprod=144&client=ianywhere&timeframe=0