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.

update statistics and task context switches

2 posts in General Discussion Last posting was on 2009-08-10 16:32:44.0Z
vtpcnk Posted on 2009-08-04 13:15:23.0Z
Sender: 2f94.4a770c03.1804289383@sybase.com
From: vtpcnk
Newsgroups: sybase.public.ase.general
Subject: update statistics and task context switches
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4a78346b.1a9c.1681692777@sybase.com>
NNTP-Posting-Host: forums-3-dub.sybase.com
X-Original-NNTP-Posting-Host: forums-3-dub.sybase.com
Date: 4 Aug 2009 06:15:23 -0700
X-Trace: forums-3-dub.sybase.com 1249391723 10.22.241.188 (4 Aug 2009 06:15:23 -0700)
X-Original-Trace: 4 Aug 2009 06:15:23 -0700, forums-3-dub.sybase.com
Lines: 4
Path: forums-1-dub!forums-master!forums-3-dub.sybase.com!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28098
Article PK: 77341

in sysmon i am getting a tcs for a 99.6% due to 'cache
search misses' while running update statistics on all dbs.
but is that really a problem? how can the data (leaf pages)
of all tables in all dbs be present in the cache?


Sherlock, Kevin [TeamSybase] Posted on 2009-08-10 16:32:44.0Z
From: "Sherlock, Kevin [TeamSybase]" <kevin.sherlock@teamsybase.com>
Newsgroups: sybase.public.ase.general
References: <4a78346b.1a9c.1681692777@sybase.com>
Subject: Re: update statistics and task context switches
Lines: 10
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: <4a804bac$3@forums-3-dub.sybase.com>
Date: 10 Aug 2009 09:32:44 -0700
X-Trace: forums-3-dub.sybase.com 1249921964 10.22.241.152 (10 Aug 2009 09:32:44 -0700)
X-Original-Trace: 10 Aug 2009 09:32:44 -0700, vip152.sybase.com
X-Authenticated-User: teamsybase
Path: forums-1-dub!forums-master!forums-3-dub.sybase.com!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28122
Article PK: 77366

Considering that you are essentially reading every page of every table in
every database, cache misses are to be expected.

<vtpcnk> wrote in message news:4a78346b.1a9c.1681692777@sybase.com...
> in sysmon i am getting a tcs for a 99.6% due to 'cache
> search misses' while running update statistics on all dbs.
> but is that really a problem? how can the data (leaf pages)
> of all tables in all dbs be present in the cache?