Добрый день!

Не периодично на сервере 15.0 стала проявляться ошибка при построении запросов (в приложении к сообщению).

При этом бага вылазит крайне не стабильно и ровно также исчезает сама по себе без каких либо действий админа/программиста.

Хотелось бы понять что это такое? Кто-нибудь сталкивался с подобным?
Поиск по нету результатат не дал вообще...

Кэш стоит 32 МБ.
Вот опять - проблема пропала сама по себе :(
Увеличение размера кэша кстати никак не отражается на быстроте выполнения запросов... Хотя ожидалось увеличение производительности...

Parameter NameDefaultMemory UsedConfig ValueRun ValueUnitType'max memory '' 39936'' 2400000'' 1200000'' 1200000''memory pages(2k) ''dynamic '

Значения висят с рождения сервера.
Попытка изменить в 128 приводит к тому, что сервак не запускается.

additional network memory" 0"" 0"" 0"" 0"bytesdynamicallocate max shared memory" 0"" 0"" 1"" 1"switchdynamiccompression memory size" 0"" 76"" 0"" 0"memory pages(2k)dynamicengine memory log size" 0"" 2"" 0"" 0"memory pages(2k)dynamicheap memory per user" 4096"" 0"" 4096"" 4096"bytesdynamiclock shared memory" 0"" 0"" 0"" 0"switchstaticmax memory" 39936"" 2400000"" 1200000"" 1200000"memory pages(2k)dynamicmemory alignment boundary" 2048"" 0"" 2048"" 2048"bytesstaticmemory per worker process" 1024"" 20"" 8192"" 8192"bytesdynamicmessaging memory" 400"" 0"" 400"" 400"memory pages(2k)dynamicshared memory starting address" 0"" 0"" 0"" 0"not applicablestatictotal logical memory" 39936"" 1833076"" 916538"" 916539"memory pages(2k)read-onlytotal physical memory" 0"" 2400000"" 0"" 1200000"memory pages(2k)read-only

"An additional 566922 K bytes of memory is available for reconfiguration. This is the difference between 'max memory' and 'total logical memory'."

Заранее сорри за большое сообщение.
Полный конфиг сервака.

"Group: Configuration Options" "" "Group: Backup/Recovery" "allow remote access" 1"" 0"" 1"" 1"switchdynamicmax concurrently recovered db" 0"" 0"" 0"" 0"numberdynamicnumber of checkpoint tasks" 1"" 0"" 1"" 1"numberdynamicprint recovery information" 0"" 0"" 0"" 0"switchdynamicrecovery interval in minutes" 5"" 0"" 5"" 5"minutesdynamictape retention in days" 0"" 0"" 0"" 0"daysdynamic" "Group: Cache Manager" "extended cache size" 0"" 0"" 0"" 0"memory pages(2k)dynamicglobal async prefetch limit" 10"" 0"" 10"" 10"percentdynamicglobal cache partition number" 1"" 0"" 1"" 1"numberstaticmemory alignment boundary" 2048"" 0"" 2048"" 2048"bytesstaticnumber of index trips" 0"" 0"" 0"" 0"numberdynamicnumber of oam trips" 0"" 0"" 0"" 0"numberdynamictotal data cache size" 0"" 105174"" 0"" 105174"kilobytesread-only" "Group: Component Integration Services" "cis bulk insert array size" 50"" 0"" 50"" 50"rowsdynamiccis bulk insert batch size" 0"" 0"" 0"" 0"rowsdynamiccis connect timeout" 0"" 0"" 0"" 0"secondsdynamiccis cursor rows" 50"" 0"" 50"" 50"numberdynamiccis idle connection timeout" 0"" 0"" 0"" 0"secondsdynamiccis packet size" 512"" 0"" 512"" 512"bytesdynamiccis rpc handling" 0"" 0"" 0"" 0"switchdynamicenable cis" 1"" 0"" 1"" 1"switchstaticenable file access" 0"" 0"" 1"" 1"switchdynamicenable full-text search" 0"" 0"" 0"" 0"switchdynamicenable snmp" 0"" 0"" 0"" 0"switchdynamicmax cis remote connections" 0"" 84"" 0"" 0"numberdynamic" "Group: DTM Administration" "dtm detach timeout period" 300"" 0"" 300"" 300"minutesdynamicdtm lock timeout period" 300"" 0"" 300"" 300"secondsdynamicenable DTM" 0"" 0"" 1"" 1"switchstaticenable xact coordination" 1"" 0"" 1"" 1"switchstaticnumber of dtx participants" 500"" 146"" 500"" 500"numberdynamicstrict dtm enforcement" 0"" 0"" 0"" 0"switchstatictxn to pss ratio" 16"" 850"" 16"" 16"numberdynamicxact coordination interval" 60"" 0"" 60"" 60"secondsdynamic" "Group: Diagnostics" "average cap size" 200"" 0"" 200"" 200"bytesstaticcaps per ccb" 50"" 0"" 50"" 50"numberstaticdump on conditions" 0"" 0"" 0"" 0"switchdynamicengine memory log size" 0"" 2"" 0"" 0"memory pages(2k)dynamicmaximum dump conditions" 10"" 0"" 10"" 10"numberstaticnumber of ccbs" 0"" 0"" 0"" 0"numberstaticnumber of dump threads" 1"" 0"" 1"" 1"numberdynamic" "Group: Disk I/O" "allow sql server async i/o" 1"" 0"" 1"" 1"switchstaticdisable disk mirroring" 1"" 0"" 1"" 1"switchstaticdisk i/o structures" 256"" 40"" 256"" 256"numberdynamicnumber of devices" 10"" #20"" 15"" 15"numberdynamicnumber of large i/o buffers" 6"" 3114"" 6"" 6"numberdynamicpage utilization percent" 95"" 0"" 95"" 95"percentdynamic" "Group: Error Log" "event log computer nameLocalSystem" 0"" LocalSystem"" LocalSystem"namedynamicevent logging" 1"" 0"" 0"" 0"switchdynamiclog audit logon failure" 0"" 0"" 0"" 0"switchdynamiclog audit logon success" 0"" 0"" 0"" 0"switchdynamic" "Group: Extended Stored Procedure" "esp execution priority" 8"" 0"" 8"" 8"iddynamicesp execution stacksize" 65536"" 0"" 65536"" 65536"bytesstaticesp unload dll" 0"" 0"" 0"" 0"switchdynamicstart mail session" 0"" 0"" 0"" 0"switchdynamicstart xp server during boot" 0"" 0"" 0"" 0"switchstaticxp_cmdshell context" 1"" 0"" 1"" 1"switchdynamic" "Group: General Information" "configuration file" 0"" 0"" 0"C:\sybase\SYnamedynamic" "Group: Java Services" "enable java" 0"" 0"" 0"" 0"switchstaticnumber of java sockets" 0"" 0"" 0"" 0"numberdynamicsize of global fixed heap" 150"" 0"" 150"" 150"memory pages(2k)dynamicsize of process object heap" 1500"" 0"" 1500"" 1500"memory pages(2k)dynamicsize of shared class heap" 1536"" 0"" 1536"" 1536"memory pages(2k)dynamic" "Group: Languages" "default character set id" 2"" 0"" 53"" 53"idstaticdefault language id" 0"" 0"" 0"" 0"iddynamicdefault sortorder id" 50"" 0"" 50"" 50"idstaticdisable character set conversi" 0"" 0"" 0"" 0"switchstaticenable unicode conversions" 1"" 0"" 1"" 1"switchdynamic" "Group: Lock Manager" "deadlock checking period" 500"" 0"" 500"" 500"millisecondsdynamicdeadlock retries" 5"" 0"" 5"" 5"numberdynamiclock address spinlock ratio" 100"" 0"" 100"" 100"ratiostaticlock hashtable size" 2048"" 51"" 2048"" 2048"bytesstaticlock scheme" allpages"" 0"" allpages"" allpages"namedynamiclock spinlock ratio" 85"" 0"" 85"" 85"ratiostaticlock table spinlock ratio" 20"" 0"" 20"" 20"ratiostaticlock wait period" 2147483647"" 0"" 2147483647"" 2147483647"secondsdynamicnumber of locks" 10000"" 1632"" 10000"" 10000"numberdynamicpage lock promotion HWM" 200"" 0"" 200"" 200"numberdynamicpage lock promotion LWM" 200"" 0"" 200"" 200"numberdynamicpage lock promotion PCT" 100"" 0"" 100"" 100"percentdynamicprint deadlock information" 0"" 0"" 0"" 0"numberdynamicread committed with lock" 0"" 0"" 0"" 0"switchdynamicrow lock promotion HWM" 200"" 0"" 200"" 200"numberdynamicrow lock promotion LWM" 200"" 0"" 200"" 200"numberdynamicrow lock promotion PCT" 100"" 0"" 100"" 100"percentdynamic" "Group: Memory Use" "additional network memory" 0"" 0"" 0"" 0"bytesdynamicallocate max shared memory" 0"" 0"" 1"" 1"switchdynamicallow resource limits" 0"" #4"" 0"" 0"switchstaticaudit queue size" 100"" 2"" 100"" 100"numberdynamicaverage cap size" 200"" 0"" 200"" 200"bytesstaticcaps per ccb" 50"" 0"" 50"" 50"numberstaticcompression memory size" 0"" 76"" 0"" 0"memory pages(2k)dynamicdeadlock pipe max messages" 0"" 0"" 0"" 0"numberdynamicdefault network packet size" 2048"" #568"" 2048"" 2048"bytesstaticdisk i/o structures" 256"" 40"" 256"" 256"numberdynamicdynamic allocation on demand" 1"" 0"" 1"" 1"switchdynamicenable rep agent threads" 0"" 0"" 0"" 0"switchdynamicerrorlog pipe max messages" 0"" 0"" 0"" 0"numberdynamicevent buffers per engine" 100"" #40"" 100"" 100"numberstaticexecutable codesize + overhead" 0"" 10710"" 0"" 10710"kilobytesread-onlyheap memory per user" 4096"" 0"" 4096"" 4096"bytesdynamiclock hashtable size" 2048"" 51"" 2048"" 2048"bytesstaticlock spinlock ratio" 85"" 0"" 85"" 85"ratiostaticmax SQL text monitored" 0"" 4"" 0"" 0"bytesstaticmax memory" 39936"" 2400000"" 1200000"" 1200000"memory pages(2k)dynamicmax number network listeners" 5"" 545"" 5"" 5"numberdynamicmax online Q engines" 0"" 0"" 0"" 0"not applicablestaticmax online engines" 1"" 124"" 4"" 4"numberstaticmemory per worker process" 1024"" 20"" 8192"" 8192"bytesdynamicmessaging memory" 400"" 0"" 400"" 400"memory pages(2k)dynamicnumber of alarms" 40"" 4"" 40"" 40"numberdynamicnumber of aux scan descriptors" 256"" #322"" 256"" 256"numberdynamicnumber of ccbs" 0"" 0"" 0"" 0"numberstaticnumber of devices" 10"" #20"" 15"" 15"numberdynamicnumber of dtx participants" 500"" 146"" 500"" 500"numberdynamicnumber of java sockets" 0"" 0"" 0"" 0"numberdynamicnumber of large i/o buffers" 6"" 3114"" 6"" 6"numberdynamicnumber of locks" 10000"" 1632"" 10000"" 10000"numberdynamicnumber of mailboxes" 30"" 2"" 30"" 30"numberdynamicnumber of messages" 64"" 3"" 64"" 64"numberdynamicnumber of open databases" 12"" 4724"" 12"" 12"numberdynamicnumber of open indexes" 500"" 1292"" 500"" 500"numberdynamicnumber of open objects" 500"" 794"" 500"" 500"numberdynamicnumber of open partitions" 500"" 497"" 500"" 500"numberdynamicnumber of remote connections" 20"" 123"" 20"" 20"numberstaticnumber of remote logins" 20"" 82"" 20"" 20"numberstaticnumber of remote sites" 10"" 1093"" 10"" 10"numberstaticnumber of user connections" 25"" 2727"" 25"" 25"numberdynamicnumber of worker processes" 0"" 220"" 2"" 2"numberdynamicopen index hash spinlock ratio" 100"" 0"" 100"" 100"ratiodynamicopen index spinlock ratio" 100"" 0"" 100"" 100"ratiodynamicpartition groups" 1024"" 412"" 1024"" 1024"numberdynamicpartition spinlock ratio" 10"" 10"" 10"" 10"ratiodynamicpermission cache entries" 15"" #190"" 15"" 15"numberdynamicplan text pipe max messages" 0"" 0"" 0"" 0"numberdynamicprocedure cache size" 7000"" 2117204"" 1000000"" 1000000"memory pages(2k)dynamicprocess wait events" 0"" 0"" 0"" 0"switchdynamicremote server pre-read packets" 3"" #122"" 3"" 3"numberstaticsize of global fixed heap" 150"" 0"" 150"" 150"memory pages(2k)dynamicsize of process object heap" 1500"" 0"" 1500"" 1500"memory pages(2k)dynamicsize of shared class heap" 1536"" 0"" 1536"" 1536"memory pages(2k)dynamicsize of unilib cache" 0"" 266"" 0"" 0"bytesdynamicsql text pipe max messages" 0"" 0"" 0"" 0"numberdynamicstack guard size" 16384"" #1151"" 16384"" 16384"bytesstaticstack size" 41984"" #3023"" 43008"" 43008"bytesstaticstatement cache size" 0"" 0"" 0"" 0"memory pages(2k)dynamicstatement pipe max messages" 0"" 0"" 0"" 0"numberdynamictotal data cache size" 0"" 105174"" 0"" 105174"kilobytesread-onlytotal logical memory" 39936"" 2256676"" 1128338"" 1128339"memory pages(2k)read-onlytotal physical memory" 0"" 2400000"" 0"" 1200000"memory pages(2k)read-onlytxn to pss ratio" 16"" 850"" 16"" 16"numberdynamicuser log cache size" 2048"" 0"" 4096"" 4096"bytesstaticuser log cache spinlock ratio" 20"" 0"" 20"" 20"ratiodynamicwait event timing" 0"" 0"" 0"" 0"switchdynamic" "Group: Meta-Data Caches" "number of open databases" 12"" 4724"" 12"" 12"numberdynamicnumber of open indexes" 500"" 1292"" 500"" 500"numberdynamicnumber of open objects" 500"" 794"" 500"" 500"numberdynamicnumber of open partitions" 500"" 497"" 500"" 500"numberdynamicopen index hash spinlock ratio" 100"" 0"" 100"" 100"ratiodynamicopen index spinlock ratio" 100"" 0"" 100"" 100"ratiodynamicopen object spinlock ratio" 100"" 0"" 100"" 100"ratiodynamicpartition groups" 1024"" 412"" 1024"" 1024"numberdynamicpartition spinlock ratio" 10"" 10"" 10"" 10"ratiodynamic" "Group: Monitoring" "SQL batch capture" 0"" 0"" 0"" 0"switchdynamicdeadlock pipe active" 0"" 0"" 0"" 0"switchdynamicdeadlock pipe max messages" 0"" 0"" 0"" 0"numberdynamicenable monitoring" 0"" 0"" 0"" 0"switchdynamicenable stmt cache monitoring" 0"" 0"" 0"" 0"switchdynamicerrorlog pipe active" 0"" 0"" 0"" 0"switchdynamicerrorlog pipe max messages" 0"" 0"" 0"" 0"numberdynamicmax SQL text monitored" 0"" 4"" 0"" 0"bytesstaticobject lockwait timing" 0"" 0"" 0"" 0"switchdynamicper object statistics active" 0"" 0"" 0"" 0"switchdynamicperformance monitoring option" 0"" 0"" 0"" 0"switchdynamicplan text pipe active" 0"" 0"" 0"" 0"switchdynamicplan text pipe max messages" 0"" 0"" 0"" 0"numberdynamicprocess wait events" 0"" 0"" 0"" 0"switchdynamicsql text pipe active" 0"" 0"" 0"" 0"switchdynamicsql text pipe max messages" 0"" 0"" 0"" 0"numberdynamicstatement pipe active" 0"" 0"" 0"" 0"switchdynamicstatement pipe max messages" 0"" 0"" 0"" 0"numberdynamicstatement statistics active" 0"" 0"" 0"" 0"switchdynamicwait event timing" 0"" 0"" 0"" 0"switchdynamic" "Group: Network Communication" "additional network memory" 0"" 0"" 0"" 0"bytesdynamicallow remote access" 1"" 0"" 1"" 1"switchdynamicallow sendmsg" 0"" 0"" 0"" 0"switchdynamicdefault network packet size" 2048"" #568"" 2048"" 2048"bytesstaticmax network packet size" 2048"" 0"" 2048"" 2048"bytesstaticmax number network listeners" 5"" 545"" 5"" 5"numberdynamicnumber of remote connections" 20"" 123"" 20"" 20"numberstaticnumber of remote logins" 20"" 82"" 20"" 20"numberstaticnumber of remote sites" 10"" 1093"" 10"" 10"numberstaticremote server pre-read packets" 3"" #122"" 3"" 3"numberstaticsend doneinproc tokens" 1"" 0"" 1"" 1"switchdynamicsyb_sendmsg port number" 0"" 0"" 0"" 0"idstatictcp no delay" 1"" 0"" 1"" 1"switchstatic" "Group: O/S Resources" "max async i/os per engine" 2147483647"" 0"" 2147483647"" 2147483647"numberstaticmax async i/os per server" 2147483647"" 0"" 2147483647"" 2147483647"numberstaticmax native threads per engine" 50"" 0"" 50"" 50"numberdynamico/s file descriptors" 0"" 0"" 0"" 100000"numberread-onlytcp no delay" 1"" 0"" 1"" 1"switchstatic" "Group: Physical Resources" "" "Group: Physical Memory" "additional network memory" 0"" 0"" 0"" 0"bytesdynamicallocate max shared memory" 0"" 0"" 1"" 1"switchdynamiccompression memory size" 0"" 76"" 0"" 0"memory pages(2k)dynamicdynamic allocation on demand" 1"" 0"" 1"" 1"switchdynamicheap memory per user" 4096"" 0"" 4096"" 4096"bytesdynamiclock shared memory" 0"" 0"" 0"" 0"switchstaticmax memory" 39936"" 2400000"" 1200000"" 1200000"memory pages(2k)dynamicmessaging memory" 400"" 0"" 400"" 400"memory pages(2k)dynamicshared memory starting address" 0"" 0"" 0"" 0"not applicablestatictotal logical memory" 39936"" 2256676"" 1128338"" 1128339"memory pages(2k)read-onlytotal physical memory" 0"" 2400000"" 0"" 1200000"memory pages(2k)read-only" "Group: Processors" "max online Q engines" 0"" 0"" 0"" 0"not applicablestaticmax online engines" 1"" 124"" 4"" 4"numberstaticnumber of Q engines at startup" 0"" 0"" 0"" 0"numberstaticnumber of engines at startup" 1"" 0"" 4"" 4"numberstatic" "Group: Query Tuning" "abstract plan cache" 0"" 0"" 0"" 0"switchdynamicabstract plan dump" 0"" 0"" 0"" 0"switchdynamicabstract plan load" 0"" 0"" 0"" 0"switchdynamicabstract plan replace" 0"" 0"" 0"" 0"switchdynamicallow backward scans" 1"" 0"" 1"" 1"switchdynamicauto query tuning" 0"" 0"" 0"" 0"switchdynamiccost of a cpu unit" 1000"" 0"" 1000"" 1000"numberdynamiccost of a logical io" 2"" 0"" 2"" 2"numberdynamiccost of a physical io" 25"" 0"" 25"" 25"numberdynamicenable literal autoparam" 0"" 0"" 0"" 0"switchdynamicenable merge join" 2"" 0"" 2"" 2"switchdynamicenable query tuning mem limit" 1"" 0"" 1"" 1"switchdynamicenable query tuning time limit" 1"" 0"" 1"" 1"switchdynamicenable sort-merge join and JTC" 0"" 0"" 0"" 0"switchdynamicmax buffers per lava operator" 2048"" 0"" 2048"" 2048"numberdynamicmax parallel degree" 1"" 0"" 2"" 2"numberdynamicmax query parallel degree" 1"" 0"" 2"" 2"numberdynamicmax repartition degree" 1"" 0"" 2"" 2"numberdynamicmax resource granularity" 10"" 0"" 10"" 10"numberdynamicmax scan parallel degree" 1"" 0"" 2"" 2"numberdynamicmemory per worker process" 1024"" 20"" 8192"" 8192"bytesdynamicmetrics elap max" 0"" 0"" 0"" 0"millisecondsdynamicmetrics exec max" 0"" 0"" 0"" 0"millisecondsdynamicmetrics lio max" 0"" 0"" 0"" 0"logical pagesdynamicmetrics pio max" 0"" 0"" 0"" 0"logical pagesdynamicmin pages for parallel scan" 200"" 0"" 200"" 200"logical pagesdynamicnumber of histogram steps" 20"" 0"" 20"" 20"numberdynamicnumber of worker processes" 0"" 220"" 2"" 2"numberdynamicoptimization goalallrows_mix" 0"" allrows_mix"" allrows_mix"namedynamicoptimization timeout limit" 10"" 0"" 10"" 10"percentdynamicprod-consumer overlap factor" 20"" 0"" 20"" 20"percentdynamicquery tuning plan executions" 3"" 0"" 3"" 3"numberdynamicsampling percent" 0"" 0"" 0"" 0"percentdynamicsproc optimize timeout limit" 40"" 0"" 40"" 40"percentdynamic" "Group: Rep Agent Thread Administration" "enable rep agent threads" 0"" 0"" 0"" 0"switchdynamic" "Group: SQL Server Administration" "SQL Perfmon Integration" 1"" 0"" 1"" 1"switchstaticallow nested triggers" 1"" 0"" 1"" 1"switchstaticallow resource limits" 0"" #4"" 0"" 0"switchstaticallow updates to system tables" 0"" 0"" 0"" 0"switchdynamiccpu accounting flush interval" 200"" 0"" 200"" 200"clock ticksdynamiccpu grace time" 500"" 0"" 500"" 500"clock ticksdynamicdeadlock retries" 5"" 0"" 5"" 5"numberdynamicdefault database size" 3"" 0"" 3"" 3"megabytesdynamicdefault exp_row_size percent" 5"" 0"" 5"" 5"percentdynamicdefault fill factor percent" 0"" 0"" 0"" 0"percentdynamicenable DTM" 0"" 0"" 1"" 1"switchstaticenable HA" 0"" 0"" 0"" 0"switchstaticenable housekeeper GC" 1"" 0"" 1"" 1"switchdynamicenable job scheduler" 0"" 0"" 1"" 1"switchdynamicenable metrics capture" 0"" 0"" 0"" 0"switchdynamicenable real time messaging" 0"" 0"" 0"" 0"switchdynamicenable semantic partitioning" 0"" 0"" 0"" 0"switchdynamicenable sql debugger" 1"" 0"" 1"" 1"switchstaticenable webservices" 0"" 0"" 0"" 0"switchdynamicenable xml" 0"" 0"" 0"" 0"switchdynamicevent buffers per engine" 100"" #40"" 100"" 100"numberstatichistogram tuning factor" 20"" 0"" 20"" 20"numberdynamichousekeeper free write percent" 1"" 0"" 1"" 1"percentdynamici/o accounting flush interval" 1000"" 0"" 1000"" 1000"clock ticksdynamici/o batch size" 100"" 0"" 100"" 100"numberdynamici/o polling process count" 10"" 0"" 10"" 10"numberdynamicidentity burning set factor" 5000"" 0"" 5000"" 5000"numberstaticidentity grab size" 1"" 0"" 1"" 1"numberdynamicidentity reservation size" 1"" 0"" 1"" 1"numberdynamicjob scheduler interval" 1"" 0"" 1"" 1"secondsdynamicjob scheduler tasks" 32"" 0"" 32"" 32"numberdynamiclicense information" 0"" 0"" 0"" 0"numberdynamicmaximum job output" 32768"" 0"" 32768"" 32768"bytesdynamicnumber of alarms" 40"" 4"" 40"" 40"numberdynamicnumber of aux scan descriptors" 256"" #322"" 256"" 256"numberdynamicnumber of large i/o buffers" 6"" 3114"" 6"" 6"numberdynamicnumber of mailboxes" 30"" 2"" 30"" 30"numberdynamicnumber of messages" 64"" 3"" 64"" 64"numberdynamicnumber of open databases" 12"" 4724"" 12"" 12"numberdynamicnumber of open objects" 500"" 794"" 500"" 500"numberdynamicnumber of pre-allocated extent" 2"" 0"" 2"" 2"numberdynamicnumber of sort buffers" 500"" 0"" 500"" 500"numberdynamicpage lock promotion HWM" 200"" 0"" 200"" 200"numberdynamicpage lock promotion LWM" 200"" 0"" 200"" 200"numberdynamicpage lock promotion PCT" 100"" 0"" 100"" 100"percentdynamicpercent database for history" 20"" 0"" 20"" 20"percentdynamicpercent database for output" 30"" 0"" 30"" 30"percentdynamicpercent history free" 30"" 0"" 30"" 30"percentdynamicpercent output free" 50"" 0"" 50"" 50"percentdynamicprint deadlock information" 0"" 0"" 0"" 0"numberdynamicprocedure cache size" 7000"" 2117204"" 1000000"" 1000000"memory pages(2k)dynamicrow lock promotion HWM" 200"" 0"" 200"" 200"numberdynamicrow lock promotion LWM" 200"" 0"" 200"" 200"numberdynamicrow lock promotion PCT" 100"" 0"" 100"" 100"percentdynamicrtm thread idle wait period" 600"" 0"" 600"" 600"secondsdynamicrunnable process search count" 2000"" 0"" 2000"" 2000"numberdynamicsize of auto identity column" 10"" 0"" 10"" 10"bytesdynamicsql server clock tick length" 100000"" 0"" 100000"" 100000"microsecondsstaticstatement cache size" 0"" 0"" 0"" 0"memory pages(2k)dynamicsysstatistics flush interval" 0"" 0"" 0"" 0"minutesdynamictext prefetch size" 16"" 0"" 16"" 16"logical pagesdynamictime slice" 100"" 0"" 100"" 100"millisecondsdynamicupgrade version" 15000"" 0"" 15000"" 15000"iddynamic" "Group: Security Related" "allow procedure grouping" 1"" 0"" 1"" 1"switchdynamicaudit queue size" 100"" 2"" 100"" 100"numberdynamicauditing" 0"" 0"" 0"" 0"switchdynamiccheck password for digit" 0"" 0"" 0"" 0"switchdynamiccurread change w/ open cursors" 1"" 0"" 1"" 1"switchdynamiccurrent audit table" 1"" 0"" 1"" 1"iddynamicenable encrypted columns" 0"" 2"" 0"" 0"switchdynamicenable ldap user auth" 0"" 0"" 0"" 0"not applicabledynamicenable logins during recovery" 1"" 0"" 1"" 1"switchdynamicenable pam user auth" 0"" 0"" 0"" 0"numberdynamicenable row level access" 0"" 0"" 0"" 0"switchdynamicenable ssl" 0"" 0"" 0"" 0"switchstaticmaximum failed logins" 0"" 0"" 0"" 0"numberdynamicminimum password length" 6"" 0"" 6"" 6"bytesdynamicmsg confidentiality reqd" 0"" 0"" 0"" 0"switchdynamicmsg integrity reqd" 0"" 0"" 0"" 0"switchdynamicnet password encryption reqd" 0"" 0"" 0"" 0"switchdynamicrestricted decrypt permission" 0"" 0"" 0"" 0"switchdynamicsecure default login" guest"" 0"" guest"" guest"not applicabledynamicselect on syscomments.text" 1"" 0"" 1"" 1"switchdynamicsuspend audit when device full" 1"" 0"" 1"" 1"switchdynamicsystemwide password expiration" 0"" 0"" 0"" 0"daysdynamicunified login required" 0"" 0"" 0"" 0"switchdynamicuse security services" 0"" 0"" 0"" 0"switchstatic" "Group: Unicode" "default unicode sortorder" binary"" 0"" binary"" binary"namestaticdefault xml sortorder" binary"" 0"" binary"" binary"namestaticenable surrogate processing" 1"" 0"" 1"" 1"switchdynamicenable unicode conversions" 1"" 0"" 1"" 1"switchdynamicenable unicode normalization" 1"" 0"" 1"" 1"switchdynamicsize of unilib cache" 0"" 266"" 0"" 0"bytesdynamic" "Group: User Environment" "default network packet size" 2048"" #568"" 2048"" 2048"bytesstaticnumber of user connections" 25"" 2727"" 25"" 25"numberdynamicpermission cache entries" 15"" #190"" 15"" 15"numberdynamicsession tempdb log cache size" 2048"" 0"" 2048"" 2048"bytesstaticstack guard size" 16384"" #1151"" 16384"" 16384"bytesstaticstack size" 41984"" #3023"" 43008"" 43008"bytesstaticuser log cache size" 2048"" 0"" 4096"" 4096"bytesstaticuser log cache spinlock ratio" 20"" 0"" 20"" 20"ratiodynamic

'Adaptive Server Enterprise/15.0.2/EBF 14332/P/NT (IX86)/Windows 2000/ase1502/2486/32-bit/OPT/Thu May 24 04:10:36 2007'

sp_helpcache
Cache NameConfig SizeRun SizeOverhead'default data cache'' 96.00 Mb'' 96.00 Mb'' 6.71 Mb'

sp_cacheconfig
Cache NameStatusTypeConfig ValueRun Value'default data cache''Active''Default'' 96.00 Mb'' 96.00 Mb'

Сейчас сервер отъедает порядка 2 ГБ памяти (по таск манагеру судя).
При работе любых запросов "загруз" процессора составляет максимум 15%...

Да... по крайней мере то, что показывает interactive SQL

blzz забыл парольу вас просто невероятно огромный "procedure cache size" в 2117204kb - около 2ГБ,

провел уменьшение кэша для процедур.
Но вот выделить кэш под данные в полном объеме не удалось - максимум 120 мегабайт.
При попытках жать больший объем - запрос падает.
Вот то, что возвращает sp_cacheconfig


Кстати, всем спасибо за советы - база стала крутиться намного веселее и быстрее :).
Но хотелось бы разобраться окончательно во всем этом безобразии...

не удается расширить основной - после увеличения размера более 100 М , сервер просто не запускается...