1> sp_cacheconfig "default data cache","1G"
2> go
Msg 10879, Level 16, State 1:
Server 'SPICE_BIAPPS', Procedure 'sp_cacheconfig', Line 1167:
The current 'max memory' value '58368', is not sufficient to change the size of
cache 'default data cache' to '1G' (1048576 KB). 'max memory' should be greater
than 'total logical memory' '579786' required for the configuration.
(return status = 1)
1> sp_configure "max memory"
2> go
Parameter Name Default Memory Used Config Value
Run Value Unit Type
------------------------------ ----------- ----------- ------------
------------ -------------------- ----------
max memory 58368 116736 58368
58368 memory pages(2k) dynamic
(1 row affected)
(return status = 0)
1> sp_configure "max memory","1G"
2> go
Msg 257, Level 16, State 1:
Server 'SPICE_BIAPPS', Procedure 'sp_configure':
Implicit conversion from datatype 'VARCHAR' to 'INT' is not allowed. Use the
CONVERT function to run this query.
(return status = -6)
1> sp_configure "max memory",512000
2> go
Parameter Name Default Memory Used Config Value
Run Value Unit Type
------------------------------ ----------- ----------- ------------
------------ -------------------- ----------
max memory 58368 1024000 512000
512000 memory pages(2k) dynamic
(1 row affected)
Configuration option changed. ASE need not be rebooted since the option is
dynamic.
Changing the value of 'max memory' to '512000' reduces the amount of memory ASE
uses by 14 K. The reduced memory may be reused when this configure value
changes, but will not be released until ASE restarts.
(return status = 0)
1> sp_cacheconfig "default data cache","600M"
2> go
606208 Kilobytes added successfully to named cache (default data cache). Change
takes effect immediately.
(return status = 0)
1> sp_cacheconfig "p
2>
3> reset
1> sp_configure "procedure cache
2> "
(1 row affected)
(return status = 1)
1> sp_configure "procedure cache"
2> go
Parameter Name Default Memory Used Config Value
Run Value Unit Type
------------------------------ ----------- ----------- ------------
------------ -------------------- ----------
procedure cache size 7000 15254 7000
7000 memory pages(2k) dynamic
(1 row affected)
(return status = 0)
1> sp_configure "procedure cache",204800
2> go
Msg 5861, Level 16, State 2:
Server 'SPICE_BIAPPS', Procedure 'sp_configure', Line 860:
The current 'max memory' value '512000', is not sufficient to change the
parameter 'procedure cache size' to '204800'. 'max memory' should be greater
than 'total logical memory' '572584' required for the configuration.
(return status = 1)
1> sp_configure "procedure cache"179200
2> go
Msg 102, Level 15, State 1:
Server 'SPICE_BIAPPS', Line 1:
Incorrect syntax near '179200'.
1> sp_configure "procedure cache",179200
2> go
Msg 5861, Level 16, State 2:
Server 'SPICE_BIAPPS', Procedure 'sp_configure', Line 860:
The current 'max memory' value '512000', is not sufficient to change the
parameter 'procedure cache size' to '179200'. 'max memory' should be greater
than 'total logical memory' '544684' required for the configuration.
(return status = 1)
1> sp_configure "max memory",512000
2> go
Parameter Name Default Memory Used Config Value
Run Value Unit Type
------------------------------ ----------- ----------- ------------
------------ -------------------- ----------
max memory 58368 1024000 512000
512000 memory pages(2k) dynamic
(1 row affected)
Resulting configuration value and memory use have not changed from previous
values: new configuration value 512000, previous value 512000.
(return status = 0)
1> sp_configure "max memory",512000
2> go
Parameter Name Default Memory Used Config Value
Run Value Unit Type
------------------------------ ----------- ----------- ------------
------------ -------------------- ----------
max memory 58368 1024000 512000
512000 memory pages(2k) dynamic
(1 row affected)
Resulting configuration value and memory use have not changed from previous
values: new configuration value 512000, previous value 512000.
(return status = 0)
1> sp_configure "max memory",1024000
2> go
Parameter Name Default Memory Used Config Value
Run Value Unit Type
------------------------------ ----------- ----------- ------------
------------ -------------------- ----------
max memory 58368 2048000 1024000
1024000 memory pages(2k) dynamic
(1 row affected)
Configuration option changed. ASE need not be rebooted since the option is
dynamic.
Changing the value of 'max memory' does not increase the amount of memory
Adaptive Server uses.
(return status = 0)
1> sp_configure "procedure cache",204800
2> go
Parameter Name Default Memory Used Config Value
Run Value Unit Type
------------------------------ ----------- ----------- ------------
------------ -------------------- ----------
procedure cache size 7000 446474 204800
204800 memory pages(2k) dynamic
(1 row affected)
Configuration option changed. ASE need not be rebooted since the option is
dynamic.
Changing the value of 'procedure cache size' to '204800' increases the amount of
memory ASE uses by 431246 K.
(return status = 0)
1>
2> go
Msg 10879, Level 16, State 1:
Server 'SPICE_BIAPPS', Procedure 'sp_cacheconfig', Line 1167:
The current 'max memory' value '58368', is not sufficient to change the size of
cache 'default data cache' to '1G' (1048576 KB). 'max memory' should be greater
than 'total logical memory' '579786' required for the configuration.
(return status = 1)
1> sp_configure "max memory"
2> go
Parameter Name Default Memory Used Config Value
Run Value Unit Type
------------------------------ ----------- ----------- ------------
------------ -------------------- ----------
max memory 58368 116736 58368
58368 memory pages(2k) dynamic
(1 row affected)
(return status = 0)
1> sp_configure "max memory","1G"
2> go
Msg 257, Level 16, State 1:
Server 'SPICE_BIAPPS', Procedure 'sp_configure':
Implicit conversion from datatype 'VARCHAR' to 'INT' is not allowed. Use the
CONVERT function to run this query.
(return status = -6)
1> sp_configure "max memory",512000
2> go
Parameter Name Default Memory Used Config Value
Run Value Unit Type
------------------------------ ----------- ----------- ------------
------------ -------------------- ----------
max memory 58368 1024000 512000
512000 memory pages(2k) dynamic
(1 row affected)
Configuration option changed. ASE need not be rebooted since the option is
dynamic.
Changing the value of 'max memory' to '512000' reduces the amount of memory ASE
uses by 14 K. The reduced memory may be reused when this configure value
changes, but will not be released until ASE restarts.
(return status = 0)
1> sp_cacheconfig "default data cache","600M"
2> go
606208 Kilobytes added successfully to named cache (default data cache). Change
takes effect immediately.
(return status = 0)
1> sp_cacheconfig "p
2>
3> reset
1> sp_configure "procedure cache
2> "
(1 row affected)
(return status = 1)
1> sp_configure "procedure cache"
2> go
Parameter Name Default Memory Used Config Value
Run Value Unit Type
------------------------------ ----------- ----------- ------------
------------ -------------------- ----------
procedure cache size 7000 15254 7000
7000 memory pages(2k) dynamic
(1 row affected)
(return status = 0)
1> sp_configure "procedure cache",204800
2> go
Msg 5861, Level 16, State 2:
Server 'SPICE_BIAPPS', Procedure 'sp_configure', Line 860:
The current 'max memory' value '512000', is not sufficient to change the
parameter 'procedure cache size' to '204800'. 'max memory' should be greater
than 'total logical memory' '572584' required for the configuration.
(return status = 1)
1> sp_configure "procedure cache"179200
2> go
Msg 102, Level 15, State 1:
Server 'SPICE_BIAPPS', Line 1:
Incorrect syntax near '179200'.
1> sp_configure "procedure cache",179200
2> go
Msg 5861, Level 16, State 2:
Server 'SPICE_BIAPPS', Procedure 'sp_configure', Line 860:
The current 'max memory' value '512000', is not sufficient to change the
parameter 'procedure cache size' to '179200'. 'max memory' should be greater
than 'total logical memory' '544684' required for the configuration.
(return status = 1)
1> sp_configure "max memory",512000
2> go
Parameter Name Default Memory Used Config Value
Run Value Unit Type
------------------------------ ----------- ----------- ------------
------------ -------------------- ----------
max memory 58368 1024000 512000
512000 memory pages(2k) dynamic
(1 row affected)
Resulting configuration value and memory use have not changed from previous
values: new configuration value 512000, previous value 512000.
(return status = 0)
1> sp_configure "max memory",512000
2> go
Parameter Name Default Memory Used Config Value
Run Value Unit Type
------------------------------ ----------- ----------- ------------
------------ -------------------- ----------
max memory 58368 1024000 512000
512000 memory pages(2k) dynamic
(1 row affected)
Resulting configuration value and memory use have not changed from previous
values: new configuration value 512000, previous value 512000.
(return status = 0)
1> sp_configure "max memory",1024000
2> go
Parameter Name Default Memory Used Config Value
Run Value Unit Type
------------------------------ ----------- ----------- ------------
------------ -------------------- ----------
max memory 58368 2048000 1024000
1024000 memory pages(2k) dynamic
(1 row affected)
Configuration option changed. ASE need not be rebooted since the option is
dynamic.
Changing the value of 'max memory' does not increase the amount of memory
Adaptive Server uses.
(return status = 0)
1> sp_configure "procedure cache",204800
2> go
Parameter Name Default Memory Used Config Value
Run Value Unit Type
------------------------------ ----------- ----------- ------------
------------ -------------------- ----------
procedure cache size 7000 446474 204800
204800 memory pages(2k) dynamic
(1 row affected)
Configuration option changed. ASE need not be rebooted since the option is
dynamic.
Changing the value of 'procedure cache size' to '204800' increases the amount of
memory ASE uses by 431246 K.
(return status = 0)
1>
flicerFper-ro Carlos Boylan https://wakelet.com/wake/PaEqLFp6vSfGy5YP9ivU6
ReplyDeleteriwhigile