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.

Which pool size does update index statistics use?

2 posts in General Discussion Last posting was on 2009-09-24 13:57:07.0Z
Cory Sane [TeamSybase] Posted on 2009-09-24 06:16:23.0Z
From: "Cory Sane [TeamSybase]" <cory!=sane>
Newsgroups: sybase.public.ase.general
Subject: Which pool size does update index statistics use?
Lines: 12
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.18005
X-MimeOLE: Produced By Microsoft MimeOLE V6.0.6002.18005
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4abb0eb7$1@forums-1-dub>
Date: 23 Sep 2009 23:16:23 -0700
X-Trace: forums-1-dub 1253772983 10.22.241.152 (23 Sep 2009 23:16:23 -0700)
X-Original-Trace: 23 Sep 2009 23:16:23 -0700, vip152.sybase.com
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28357
Article PK: 77601

Guys,
I'm trying to do a little server tuning for weekend work...

On a 2k page server version 15.0.3, which pool size will be used by update idex statistics if 2,4 & 16k pools are available?
I've looked at monCachedObjects, I did not see a column that would help.

Is the answer the same for a 12.5.x server?

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


Sherlock, Kevin [TeamSybase] Posted on 2009-09-24 13:57:07.0Z
From: "Sherlock, Kevin [TeamSybase]" <kevin.sherlock@teamsybase.com>
Newsgroups: sybase.public.ase.general
References: <4abb0eb7$1@forums-1-dub>
Subject: Re: Which pool size does update index statistics use?
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; Response
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4abb7ab3@forums-1-dub>
Date: 24 Sep 2009 06:57:07 -0700
X-Trace: forums-1-dub 1253800627 10.22.241.152 (24 Sep 2009 06:57:07 -0700)
X-Original-Trace: 24 Sep 2009 06:57:07 -0700, vip152.sybase.com
X-Authenticated-User: teamsybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28366
Article PK: 77611

All IO on the object will use the largest io pool available to the cache
that the object is bound to (or default data cache).

True for 12.5.x as well.

"Cory Sane [TeamSybase]" <cory!=sane> wrote in message
news:4abb0eb7$1@forums-1-dub...
> Guys,
> I'm trying to do a little server tuning for weekend work...
>
> On a 2k page server version 15.0.3, which pool size will be used by update
> idex statistics if 2,4 & 16k pools are available?
> I've looked at monCachedObjects, I did not see a column that would help.
>
> Is the answer the same for a 12.5.x server?
>
> --
> Cory Sane
> [TeamSybase]
> Certified Sybase Associate DBA for ASE 15.0