Criar um CACHE no Sybase ASE

Um excelente recurso do Sybase ASE é o CACHE nominado, que pode ser criado para uso por apenas um (ou mais) banco de dados.

Desta forma, a memória da máquina pode ser direcionada para os bancos de dados mais críticos.

[sybase@Sybase01 ~]$ isql -Usa -PNerv2011 -SSYBASE01 -w 150
1> USE master
2> go
1> exec sp_cacheconfig IMBD_Cache, '131072.0K', mixed
2> go
00:00:00000:00025:2011/03/23 14:29:30.80 server Configuration file '/opt/sybase/ASE-15_0/SYBASE01.cfg' has been written and the previous version has been renamed to '/opt/sybase/ASE-15_0/SYBASE01.045'.
00:00:00000:00025:2011/03/23 14:29:30.97 kernel Allocating a shared memory segment of size 139096064 bytes.
00:00:00000:00025:2011/03/23 14:29:30.98 kernel Could not allocate memory using Huge Pages. Allocated using regular pages. For better performance, reboot the server after configuring enough Huge Pages.
00:00:00000:00025:2011/03/23 14:29:30.98 kernel Total shared memory allocated in this attempt. Number of segments(s): 1. Total size of allocation in bytes: 139096064
00:00:00000:00025:2011/03/23 14:29:31.55 server Size of the 4K memory pool: 131072 Kb
Memory allocated for the IMBD_Cache cachelet 1: 131072 Kb
The change is completed. The option is dynamic and ASE need not be rebooted for the change to take effect.
(return status = 0)
1> exit
[sybase@Sybase01 ~]$

Leave a Reply

O seu endereço de e-mail não será publicado. Campos obrigatórios são marcados com *

Esse site utiliza o Akismet para reduzir spam. Aprenda como seus dados de comentários são processados.