how to clear out data cache, statement cache and procedure cache?

Hi there,
does anyone know is there some commands to to clear out data
cache, statement cache and procedure cache? (without recycle
database server)
And for both ASE 12.5 and ASE 15?

we need to run some performance comparsion in ASE 12.5 and
ASE 15. I'd make sure the data cache are similar and
procedure/statement cache is clear (so cached query plan is
not used) for each case.
0
monkeyKK
3/16/2010 8:53:55 PM
sybase.ase.performance+tuning 2395 articles. 0 followers. Follow

1 Replies
6847 Views

Similar Articles

[PageSpeed] 4

This all depends on the (very) specific version of ASE


data cache:
------------
as of 15.0.3 - dbcc cachedataremove(dbid | dbname, objid | objname, 
partitionid | partitionname, indid | indexname)
you need sa_role for that as well

pre-15.0.2 ESD6 - try sp_unbindcache_all 'default data cache'
for example to clear "default data cache".  For named data caches, you 
should do this, followed by a sp_bindcache again for each object bound to a 
named cache


statement cache:
------------------
set statement_cache off    -- session level
<your sql statements here>

or
sp_configure 'statement cache size',0  -- server level

procedure cache:
-------------------
In 12.5.4 ESD5 and 15.0.2 :
dbcc proc_cache (free_unused)

pre 12.5.4 ESD5:
dbcc proc_cacherm(type, dbname, objname)

where: type is V,P,T,R,D,C,F, or S (must be uppercase) corresponds to View,
Proc, Trigger, Rule, Default, Cursor, SQLJ Function, SQL function


<monkeyKK> wrote in message news:4b9fefe3.3a37.1681692777@sybase.com...
> Hi there,
> does anyone know is there some commands to to clear out data
> cache, statement cache and procedure cache? (without recycle
> database server)
> And for both ASE 12.5 and ASE 15?
>
> we need to run some performance comparsion in ASE 12.5 and
> ASE 15. I'd make sure the data cache are similar and
> procedure/statement cache is clear (so cached query plan is
> not used) for each case. 


0
Sherlock
3/16/2010 9:23:02 PM
Reply:

Similar Artilces:

Caching, Caching,Caching,Caching,Caching Why nobody know???
I have posted this problem quite a few times but never got a decent answer and I have still not found a solution. Every time I have a gridview when the page is refreshed the data in the gridview does not refresh. You might say well and GridView.DataBind() to the pageload method but I think there is a performance problem if you bind your gridviews every time. For example I have a dropdownlist, a gridview and button and the gridview is supposed to refresh depending on the value in the dropdown when the button is pushed. if you click on the button the gridview data does not change unless y...

To cache or not to cache ?
I am really confused here. What I have are two forms one is where I get metadata for a document and next page where the user uploads the file for that document. What I want is a link from upload page back to the metadata page with the fields still filled in (cached maybe ?) and a link that takes back to that page without cache...In other words..I want two links on upload page one that take users back to the metadata page with fields filled in from previous request and the other link which takes to metadata form with empty fields. I am not sure how to accomplish this. I tried using ca...

to cache or not to cache?
i have a toolbar at the top of all my web pages and I am not sure whether it is worth caching or not. this toolbar is in fact a search facility consisting of 4 dropdownlists. 3 of the DDL's are static and 1 is databound. i would like to make the whole toolbar into a user control and cache it. Q1. If one of the DDL's selected item has changed the user control must know not to load from the cache. is it possible to include this kind of logic to a cached user control? Q2. Is it worth caching my toolbar? Or should I just consider caching the 1 databound DDl instead? any help much apprec...

To cache or not to cache
It's a well known fact that it's a good practice to cache results of SQL queries. But here as everywhere we should limit ourselfs and not to cache everything, shouldn't we? ) For example, you know that in facebook you can enter information about yourself - first name, last name, all your schools, jobs and so on. This data changes very rarely. So, as books say this data is perfect to be cached. But, you see, there can be millions of users with there profiles in our cache. So.. to cache or not to cache? )  it is a good practice to use limited size content and low edit freque...

To Cache or Not To Cache?
Hello, I'd like the opinion of the community on this question. We've just completed a migration from Exchange 5.5 to GroupWise 7. Migration went well. Right now, everyone is using WebAccess but I am rolling out the GroupWise Windows client (with latest FTFs) along with an updated XP SP2 workstation image shortly, to the office people. They had been using Outlook with Exchange, no caching. We have 6 locations with office people. About 25 are local to the PO server. The other locations, ranging from 25 to 8 per location are connected to the PO server via a T-1 WAN lin...

About Procedure cache & Data cache..
Hi, 1. Procedure cache: I had to reconfigure my procedure cache with sp_configure (sp_configure "procedure cache", XX) but... I was wondering how could the procedure cache run out of capacity/memory? If there is not enough place in the procedure cache for a new procedure plan didn't the server "flushes" out the oldest used procedure query plan from cache and let the place for the newest ? I would like to know more on how the Procedure cache works... (I just know that it's the memory -RAM- allocated for ASE stored procedures--> compiled store procedure...

superreview requested: [Bug 257491] Resetting Browser and clearing the cache should clear the memory cache as well as the disk cache : [Attachment 163271] in Navigation pref pane, clear cache in memo
Josh Aas <joshmoz@gmail.com> has asked Mike Pinkerton <pinkerton@aol.net> for superreview: Bug 257491: Resetting Browser and clearing the cache should clear the memory cache as well as the disk cache https://bugzilla.mozilla.org/show_bug.cgi?id=257491 Attachment 163271: in Navigation pref pane, clear cache in memory as well as on disk https://bugzilla.mozilla.org/attachment.cgi?id=163271&action=edit ...

superreview granted: [Bug 257491] Resetting Browser and clearing the cache should clear the memory cache as well as the disk cache : [Attachment 163271] in Navigation pref pane, clear cache in memory
Mike Pinkerton <pinkerton@aol.net> has granted Josh Aas <joshmoz@gmail.com>'s request for superreview: Bug 257491: Resetting Browser and clearing the cache should clear the memory cache as well as the disk cache https://bugzilla.mozilla.org/show_bug.cgi?id=257491 Attachment 163271: in Navigation pref pane, clear cache in memory as well as on disk https://bugzilla.mozilla.org/attachment.cgi?id=163271&action=edit ------- Additional Comments from Mike Pinkerton <pinkerton@aol.net> sr=pink ...

Capacity Planning
We are looking at adding more users to our systems. Is there any documentation on how to plan for the amount of additional data and procedure that is required (and if it is required)? We have some capacity planning folks who are looking at O/S statistics and I think we should be looking at what ASE is doing. Thanks Richard Kinread Richard Kinread wrote: > > We are looking at adding more users to our systems. Is there any > documentation on how to plan for the amount of additional data and procedure > that is required (and if it is required)? Each user c...

Procedure Cache and Statement Cache (reported in sysmon)
All - In reviewing my sysmons for a reporting dataserver, I found that my 'Statements not cached' were non-zero with my 'statement cache size' configured at '0'. So, for testing, I increased that configuration to '100' MB to see what effects this would have in sysmon. Before starting my tests, I also looked at 'Procedure Removals' which have been consistently ~0 for months. Immediately upon testing and my subsequent sysmons, my 'Statements not Cached' drop to 0, but my 'Procedure Removal' jumped anywhere from 12-49 for each...

superreview requested: [Bug 257491] Resetting Browser and clearing the cache should clear the memory cache as well as the disk cache : [Attachment 163273] clear up text in prefs interface
Geoff Beier <me@mollyandgeoff.com> has asked Mike Pinkerton <pinkerton@aol.net> for superreview: Bug 257491: Resetting Browser and clearing the cache should clear the memory cache as well as the disk cache https://bugzilla.mozilla.org/show_bug.cgi?id=257491 Attachment 163273: clear up text in prefs interface https://bugzilla.mozilla.org/attachment.cgi?id=163273&action=edit ------- Additional Comments from Geoff Beier <me@mollyandgeoff.com> This is clearer. r=me@mollyandgeoff.com ...

superreview granted: [Bug 257491] Resetting Browser and clearing the cache should clear the memory cache as well as the disk cache : [Attachment 163273] clear up text in prefs interface
Mike Pinkerton <pinkerton@aol.net> has granted Geoff Beier <me@mollyandgeoff.com>'s request for superreview: Bug 257491: Resetting Browser and clearing the cache should clear the memory cache as well as the disk cache https://bugzilla.mozilla.org/show_bug.cgi?id=257491 Attachment 163273: clear up text in prefs interface https://bugzilla.mozilla.org/attachment.cgi?id=163273&action=edit ------- Additional Comments from Mike Pinkerton <pinkerton@aol.net> sr=pink ...

cache loading and cache clearing
I use XML to configure what pages get displayed based on URL named value pairs. For example, for www.mysite.com\list.aspx?pageID=0, I want the file associated with PageID=0. Simple enough. My question is what cache is the best one to use and when/where do I load it? At the moment, in global.asax, I'm using the HttpContext cache and I load it with an ArrayList of filenames from the XML. The problem I have is HttpContext continues to accumulate elements in the ArrayList with every http request to the server (each time global.asax executes) so I get the same base PageID arrayList eleme...

Cache tuning (videos are not cached)
Hi Group, I have an online-Learning site with a lot of videos, while they never change firefox don't cache them and allways reloads them. I have given firefox 3GB disk cache but only 80MB are in (about:cache) I'm using fasterfox and Bether Cache but nothing improves this. How can I modify how long the videos are hold? On 18.11.2010 13:40, iwl wrote: --- Original Message --- > Hi Group, > > I have an online-Learning site with a lot of videos, while they never > change firefox don't cache them and allways reloads them. I have given > firefox 3GB di...

Web resources about - how to clear out data cache, statement cache and procedure cache? - sybase.ase.performance+tuning

User:Jimbo Wales/Statement of principles - Wikipedia, the free encyclopedia
As we move forward with software and social changes, I think it is imperative that I state clearly and forcefully my views on openness and the ...

Category:Articles containing potentially dated statements from June 2006 - Wikipedia, the free encyclopedia ...
This is an administration category . It is used for administration of the Wikipedia project and is not part of the encyclopedia. It contains ...

Reserve Bank dons rose-tinted glasses in Statement on Monetary Policy
The Reserve Bank reckons things are on the up and up.

Stuart Robert: Labor demands 'full statement' on trip to China, meeting with Chinese Government Minister ...
Federal Minister Stuart Robert under pressure to explain his trip to Beijing, amid revelations he met a Chinese Government Minister.

Ohio Attorney General's Planned Parenthood Statements Based On Misinformation
Autoclaving experts and Kentucky state inspectors say Attorney General Mike DeWine was wrong about Planned Parenthood allowing fetal remains ...

CNN’s Brooke Baldwin Calls Ted Cruz Statement ‘B.S.’
CNN has accused the campaign of Republican presidential candidate Ted Cruz of making false statements about the network’s reporting on the campaign ...

Donald Trump rips Ted Cruz in closing statement - Business Insider Deutschland
Donald Trump attacked Sen. Ted Cruz (R-Texas) in his closing statement at the ABC News Republican debate on Saturday night.


Cleveland Browns Point To Johnny Manziel’s Release In Statement « CBS New York
The team issued a strong statement Tuesday, condemning quarterback Johnny Manziel's actions and pointing to his release in March, a move that ...

DSA speaks out on Steinem's statement
Here is part of the NPC Statement on Gloria Steinem. Gloria Steinem, who supports former Secretary of State Hill...

Resources last updated: 2/13/2016 8:33:54 AM