Solved

Sybase - sp_cacheconfig

Posted on 2013-12-05
1
945 Views
Last Modified: 2014-01-14
Hello there,
I'm little loss with sp_cacheconfig, what is this use for and how the cacheconfig will help to improve total performance of ASE ? what are the different between cacheconfig and sp_configure 'memory' ??

1> sp_cacheconfig
2>
 Cache Name         Status   Type     Config Value   Run Value
 ------------------ -------- -------- -------------- ------------
 default data cache Active   Default    1000.00 Mb     1000.00 Mb
                                   ------------ ------------
                            Total    1000.00 Mb   1000.00 Mb
==========================================================================
Cache: default data cache,   Status: Active,   Type: Default
      Config Size: 1000.00 Mb,   Run Size: 1000.00 Mb
      Config Replacement: strict LRU,   Run Replacement: strict LRU
      Config Partition:            1,   Run Partition:            1
 IO Size  Wash Size     Config Size  Run Size     APF Percent
 -------- ------------- ------------ ------------ -----------
     2 Kb      61440 Kb    750.00 Mb    750.00 Mb     10
     4 Kb      10240 Kb     50.00 Mb     50.00 Mb     10
    16 Kb      40960 Kb    200.00 Mb    200.00 Mb     10
(return status = 0)
1>
0
Comment
Question by:motioneye
1 Comment
 
LVL 13

Accepted Solution

by:
alpmoon earned 500 total points
ID: 39701327
It is a long topic. But basically sp_cacheconfig shows configuration of data cache. You can create named caches as well. In that way you can allocate certain amount of data cache to certain objects or a database.

Also you can use sp_poolconfig to change size of memory pools (2K, 4K and 16K pools you have) or to create a new one (you can create a 8K pool as well even though it is not suggested when you have 16K pool).

More details for sp_cacheconfig can be found at:

http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc36273.1570/html/sprocs/X66462.htm

To put into perspective data cache is part of total memory used during data read/write operations (that includes both actual data and transaction log read/write). Procedure cache, metadata structures are also part of total memory. sp_configure shows all of them including other memory structures.
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

SSH (Secure Shell) - Tips and Tricks As you all know SSH(Secure Shell) is a network protocol, which we use to access/transfer files securely between two networked devices. SSH was actually designed as a replacement for insecure protocols that sen…
Linux users are sometimes dumbfounded by the severe lack of documentation on a topic. Sometimes, the documentation is copious, but other times, you end up with some obscure "it varies depending on your distribution" over and over when searching for …
Learn several ways to interact with files and get file information from the bash shell. ls lists the contents of a directory: Using the -a flag displays hidden files: Using the -l flag formats the output in a long list: The file command gives us mor…
Learn how to get help with Linux/Unix bash shell commands. Use help to read help documents for built in bash shell commands.: Use man to interface with the online reference manuals for shell commands.: Use man to search man pages for unknown command…

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now