sybase加密ENCRYPTION選項與記憶體消耗

----------------------------------------------------------------------------

---- 本文為andkylee個人原創，請在尊重作者勞動成果的前提下進行轉載；

---- 轉載務必註明原始出處
:
http://blog.csdn.net/andkylee

---- 關鍵字： ASE 15.0.3 加密 記憶體 encryption memory

----------------------------------------------------------------------------

 

 今天在測試sybase伺服器上配置encryption加密功能，測試一下資料加密的新特性。

sp_configure "enable encrypted columns",1

go

之後errorlog中顯示：

======================================================================

00:00000:00026:2010/01/18 11:09:51.56 kernel  SySAM: Checked out license for 1 ASE_ENCRYPTION (2009.1231/permanent/19B3 47BC 0B7E 8DC3).
00:00000:00026:2010/01/18 11:09:51.56 kernel  Checked out license ASE_ENCRYPTION
00:00000:00026:2010/01/18 11:09:51.67 kernel  SySAM: Failed to obtain 2 license(s) for ASE_ENCRYPTION feature from license file(s) or server(s).
00:00000:00026:2010/01/18 11:09:51.67 kernel  SySAM: ASE requires 2 'per-CPU' licenses for use on this machine but only 1 could be obtained. Check whether additional licenses are available at the Sybase Product Download Center; or check whether the licensing terms allow you to partition the machine so that ASE can only use 1 CPU(s).
00:00000:00026:2010/01/18 11:09:51.67 kernel  SySAM: License feature name:  ASE_ENCRYPTION
00:00000:00026:2010/01/18 11:09:51.67 kernel  SySAM: License search path:   D:/sybase//SYSAM-2_0/licenses/SYBASE_ASE_DE.lic
00:00000:00026:2010/01/18 11:09:51.67 kernel  SySAM: FLEXnet Licensing error:-73,125
00:00000:00026:2010/01/18 11:09:51.67 kernel  SySAM: For further information, refer to the Sybase Software Asset Management website at http://www.sybase.com/sysam
00:00000:00026:2010/01/18 11:09:51.73 server  Configuration file 'D:/sybase/TEST.cfg' has been written and the previous version has been renamed to 'D:/sybase/TEST.057'.
00:00000:00026:2010/01/18 11:09:51.73 server  The configuration option 'enable encrypted columns' has been changed by 'sa' from '0' to '1'.

======================================================================

 

重啟了一下sybase伺服器，就啟動不起來了。

errorlog如下：

0:00000:00000:2010/01/18 15:11:26.37 kernel  SySAM: Using licenses from: D:/sybase//SYSAM-2_0/licenses
00:00000:00000:2010/01/18 15:11:27.31 kernel  SySAM: Checked out license for 1 ASE_CORE (2009.1231/permanent/19B3 47BC 0B7E 8DC3).
00:00000:00000:2010/01/18 15:11:27.31 kernel  This product is licensed to: ASE Developer Edition - For Development and Test use only
00:00000:00000:2010/01/18 15:11:27.31 kernel  Checked out license ASE_CORE
00:00000:00000:2010/01/18 15:11:27.31 kernel  Adaptive Server Enterprise (Developer Edition)
00:00000:00000:2010/01/18 15:11:27.48 kernel  Using config area from primary master device.
00:00000:00000:2010/01/18 15:11:27.53 kernel  Warning: Using default file 'D:/sybase/TEST.cfg' since a configuration file was not specified. Specify a configuration file name in the RUNSERVER file to avoid this message.
00:00000:00000:2010/01/18 15:11:27.53 server  Illegal value '1' specified for configuration option 'max online engines'. The legal values are between '2' and '2'.
00:00000:00000:2010/01/18 15:11:27.53 server  The value specified for configuration option 'max online engines' '1' cannot be less than the sum of the configuration options 'number of engines at startup' and 'max online Q engines'. The current sum is '2'.
00:00000:00000:2010/01/18 15:11:27.53 server  'max online engines' has been modified from '1' to '2' by the verification routine.
00:00000:00000:2010/01/18 15:11:27.56 kernel  SySAM: Checked out license for 1 ASE_PARTITIONS (2009.1231/permanent/19B3 47BC 0B7E 8DC3).
00:00000:00000:2010/01/18 15:11:27.56 kernel  Checked out license ASE_PARTITIONS
00:00000:00000:2010/01/18 15:11:27.59 kernel  SySAM: Checked out license for 1 ASE_ENCRYPTION (2009.1231/permanent/19B3 47BC 0B7E 8DC3).
00:00000:00000:2010/01/18 15:11:27.59 kernel  Checked out license ASE_ENCRYPTION
00:00000:00000:2010/01/18 15:11:27.59 server  The value of the 'max memory' parameter (39936) defined in the configuration file is not high enough to set the other parameter values specified in the configuration file. 'max memory' should be greater than the 'total logical memory' '41568'.

======================================================================

 

暫時忽略number of engines at startup 和 max online engines 這兩個參數不一致的情況。因為我的本是雙核cpu。

 

關於記憶體配置，我沒有調整max memory,在.cfg檔案中一致都是DEFAULT。現在啟動的時候報記憶體39936不夠用，需要41568bytes記憶體。說明sybase中的encryption選項是需要消耗一定的記憶體的， 另外用加密這個選項不知道對效能的影響有多大。想想每次寫入資料庫裝置的資料都要在記憶體中進行加密處理了之後才寫入磁碟。這給處理器有增加了負擔。對效能的影響待以後有時間體會一下。