1> select @@version
2> go

---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Adaptive Server Enterprise/12.5.2/EBF 12061 ESD#2/P/Linux Intel/Enterprise Linu
x/ase1252/1844/32-bit/OPT/Wed Aug 11 21:36:26 2004

(1 row affected)





maximum failed logins 0 0 0
0 number dynamic
maximum job output 32768 0 32768
32768 bytes dynamic
memory alignment boundary 2048 0 2048
2048 bytes static
memory per worker process 1024 4 1024
1024 bytes dynamic
Memory Use 0 0 0
0 not applicable NULL
messaging memory 400 0 400
400 memory pages(2k) dynamic
Meta-Data Caches 0 0 0
0 not applicable NULL
minimum password length 6 0 6
6 bytes dynamic
Monitoring 0 0 0
0 not applicable NULL
msg confidentiality reqd 0 0 0
0 switch dynamic
msg integrity reqd 0 0 0
0 switch dynamic
Network Communication 0 0 0
0 not applicable NULL
number of alarms 40 4 40
40 number dynamic
number of aux scan descriptors 200 #232 200
200 number dynamic
number of ccbs 0 0 0
0 number static
number of checkpoint tasks 1 0 1
1 number dynamic
number of devices 10 #10 10
10 number dynamic
number of dtx participants 500 146 500
500 number dynamic
number of dump threads 1 0 1
1 number dynamic
number of engines at startup 1 0 2
2 number static
number of histogram steps 20 0 20
20 number dynamic
number of index trips 0 0 0
0 number dynamic
number of java sockets 0 0 0
0 number dynamic
number of large i/o buffers 6 3112 6
6 number dynamic
number of locks 5000 7080 50000
50000 number dynamic
number of mailboxes 30 6 30
30 number dynamic
number of messages 64 6 64
64 number dynamic
number of oam trips 0 0 0
0 number dynamic
number of open databases 12 1416 12
12 number dynamic
number of open indexes 500 592 500
500 number dynamic
number of open objects 500 7105 5000
5000 number dynamic
number of pre-allocated extent 2 0 2
2 number dynamic
number of remote connections 20 33 20
20 number static
number of remote logins 20 22 20
20 number static
number of remote sites 10 1564 10
10 number static
number of sort buffers 500 0 500
500 number dynamic
number of user connections 25 3905 25
25 number dynamic
number of worker processes 0 0 0
0 number dynamic
o/s file descriptors 0 0 0
1024 number read-only
O/S Resources 0 0 0
0 not applicable NULL
object lockwait timing 0 0 0
0 switch dynamic
open index hash spinlock ratio 100 0 100
100 ratio dynamic
open index spinlock ratio 100 0 100
100 ratio dynamic
open object spinlock ratio 100 0 100
100 ratio dynamic
page lock promotion HWM 200 0 200
200 number dynamic
page lock promotion LWM 200 0 200
200 number dynamic
page lock promotion PCT 100 0 100
100 percent dynamic
page utilization percent 95 0 95
95 percent dynamic
Parallel Query 0 0 0
0 not applicable NULL
partition groups 1024 860 1024
1024 number dynamic
partition spinlock ratio 10 0 10
10 ratio dynamic
per object statistics active 0 0 0
0 switch dynamic
percent database for history 20 0 20
20 percent dynamic
percent database for output 30 0 30
30 percent dynamic
percent history free 30 0 30
30 percent dynamic
percent output free 50 0 50
50 percent dynamic
performance monitoring option 0 0 0
0 switch dynamic
permission cache entries 15 #178 15
15 number dynamic
Physical Memory 0 0 0
0 not applicable NULL
Physical Resources 0 0 0
0 not applicable NULL
plan text pipe active 0 0 0
0 switch dynamic
plan text pipe max messages 0 0 0
0 number dynamic
print deadlock information 0 0 0
0 switch dynamic
print recovery information 0 0 0
0 switch dynamic
procedure cache size 3271 69246 32710
32710 memory pages(2k) dynamic
process wait events 0 0 0
0 switch dynamic
Processors 0 0 0
0 not applicable NULL
read committed with lock 0 0 0
0 switch dynamic
recovery interval in minutes 5 0 5
5 minutes dynamic
remote server pre-read packets 3 #32 3
3 number static
Rep Agent Thread Administratio 0 0 0
0 not applicable NULL
row lock promotion HWM 200 0 200
200 number dynamic
row lock promotion LWM 200 0 200
200 number dynamic
row lock promotion PCT 100 0 100
100 percent dynamic
runnable process search count 2000 0 2000
2000 number dynamic
sampling percent 0 0 10
10 percent dynamic
secure default login guest 0 guest
guest not applicable dynamic
Security Related 0 0 0
0 not applicable NULL
select on syscomments.text 1 0 1
1 switch dynamic
send doneinproc tokens 1 0 1
1 switch dynamic
shared memory starting address 0 0 0
0 not applicable static
size of auto identity column 10 0 10
10 bytes dynamic
size of global fixed heap 150 0 150
150 memory pages(2k) dynamic
size of process object heap 1500 0 1500
1500 memory pages(2k) dynamic
size of shared class heap 1536 0 1536
1536 memory pages(2k) dynamic
size of unilib cache 0 120 0
0 bytes dynamic
SQL batch capture 0 0 0
0 switch dynamic
SQL Perfmon Integration 1 0 1
1 switch static
SQL Server Administration 0 0 0
0 not applicable NULL
sql server clock tick length 100000 0 100000
100000 microseconds static
sql text pipe active 0 0 0
0 switch dynamic
sql text pipe max messages 0 0 0
0 number dynamic
stack guard size 4096 #280 4096
4096 bytes static
stack size 61440 #4200 61440
61440 bytes static
start mail session 0 0 0
0 switch dynamic
statement cache size 0 0 0
0 memory pages(2k) dynamic
statement pipe active 0 0 0
0 switch dynamic
statement pipe max messages 0 0 0
0 number dynamic
statement statistics active 0 0 0
0 switch dynamic
strict dtm enforcement 0 0 0
0 switch static
suspend audit when device full 1 0 1
1 switch dynamic
syb_sendmsg port number 0 0 0
0 id static
systemwide password expiration 0 0 0
0 days dynamic
tape retention in days 0 0 0
0 days dynamic
tcp no delay 1 0 1
1 switch static
text prefetch size 16 0 16
16 logical pages dynamic
time slice 100 0 100
100 milliseconds dynamic
total data cache size 0 8742 0
8742 kilobytes read-only
total logical memory 32768 116712 58356
58356 memory pages(2k) read-only
total physical memory 0 116712 0
58356 memory pages(2k) read-only
txn to pss ratio 16 764 16
16 number dynamic
Unicode 0 0 0
0 not applicable NULL
unified login required 0 0 0
0 switch dynamic
upgrade version 12500 0 12500
12500 id dynamic
use security services 0 0 0
0 switch static
User Environment 0 0 0
0 not applicable NULL
user log cache size 2048 0 2048
2048 bytes static
user log cache spinlock ratio 20 0 20
20 ratio dynamic
wait event timing 0 0 0
0 switch dynamic
xact coordination interval 60 0 60
60 seconds dynamic
xp_cmdshell context 1 0 1
1 switch dynamic

(1 row affected)
(return status = 0)



1> sp_helpcache
2> go
Cache Name Config Size Run Size Overhead
------------------------ ------------- ---------- ----------
default data cache 0.00 Mb 8.00 Mb 0.54 Mb


Memory Available For Memory Configured
Named Caches To Named Caches
-------------------- ----------------
8.01 Mb 0.00 Mb


------------------ Cache Binding Information: ------------------

Cache Name Entity Name Type Index Name
Status
---------- ----------- ---- ----------
------
(return status = 0)





1> sp_cacheconfig
2> go
Cache Name Status Type Config Value Run Value
------------------------------ --------- -------- ------------ ------------
default data cache Active Default 0.00 Mb 8.00 Mb
------------ ------------
Total 0.00 Mb 8.00 Mb
==========================================================================
Cache: default data cache, Status: Active, Type: Default
Config Size: 0.00 Mb, Run Size: 8.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 1638 Kb 0.00 Mb 8.00 Mb 10
(return status = 0)

Дело в том . .что я сам совсем новичок в этом деле..
АСЕ поставил по руководству моего софта , который будет использоват его.

просто у меня этот софт пишет что с 1000МБ рам памяти фрии 100мб

но это не постоянно, обычно фрии рам у меня 700 750 мб

Дело в том что , он постипенно снижается,, после ребута фрии рам 800 Мб гдето, а потом постепенно снижается,,, как это исправить?


1> sp_configure memory
2> go
Msg 17411, Level 16, State 1:
Server 'ipsoft', Procedure 'sp_configure', Line 209:
Configuration option is not unique.

Parameter Name Default Memory Used Config Value
Run Value Unit Type
------------------------------ ----------- ----------- ------------
----------- -------------------- ----------
additional network memory 0 0 0
0 bytes dynamic
allocate max shared memory 0 0 0
0 switch dynamic
heap memory per user 4096 0 4096
4096 bytes dynamic
lock shared memory 0 0 0
0 switch static
max memory 32768 1048576 524288
524288 memory pages(2k) dynamic
memory alignment boundary 2048 0 2048
2048 bytes static
memory per worker process 1024 4 1024
1024 bytes dynamic
Memory Use 0 0 0
0 not applicable NULL
messaging memory 400 0 400
400 memory pages(2k) dynamic
Physical Memory 0 0 0
0 not applicable NULL
shared memory starting address 0 0 0
0 not applicable static
total logical memory 32768 116712 58356
58356 memory pages(2k) read-only
total physical memory 0 116712 0
58356 memory pages(2k) read-only

(1 row affected)
An additional 931864 K bytes of memory is available for reconfiguration. This is
the difference between 'max memory' and 'total logical memory'.
(return status = 1)
1>