Buenos días,
tengo problemas con el consumo de memoria del servidor de interbase 7.1 que se dispara hasta los dos megas muriendo al llegar a este nivel. Desde que se levanta el servicio hasta llegar a los dos megas suele pasar aproximadamente tres semanas.
Adjunto información del servidor:
Cita:
Windows Server 2003 Enterprise edition Service Pack 2
Intel Xeon CPU X3363 @ 2.83GHz 2.83 GHz, 11.9 GB de RAM Extensión de dirección física
|
El servidor esta activo 24/365
El número de usuarios activos concurrentes en una jornada normal llegan a ser de 120. y unas 600 transacciones activas (READ_COMMITTED).
Adjunto el fichero de configuración:
Cita:
## The default value for each entry is listed the right of it.
## To activate an entry, uncomment it and supply the desired value.
#ADMIN_DB "admin.ib"
## Specifies a filename for the InterBase security database.
##Needed only if you do not want to use the default name, admin.ib.
## The security database must reside in the InterBase home directory.
#ANY_EVENT_MEM_SIZE 32768
## Bytes of shared memory allocated for event manager.
#ANY_LOCK_MEM_SIZE 98304
## Bytes of shared memory allocated for lock manager.
## Default is 98304 on Linux and Solaris, 256K on Windows.
#ANY_LOCK_SEM_COUNT 32
## Number of semaphores for interprocess communication
## (Classic architecture only).
#ANY_LOCK_SIGNAL 16
## UNIX signal to use for interprocess communication
## (Classic architecture only).
#CPU_AFFINITY
## (Windows only) In an SMP system, sets which processors can be used
## by the InterBase server. The value is taken from a bit vector in
## which each bit represents a machine. Thus, to use only the first
## processor, the value is 1. To use both the first and second processors,
## the value is 3. To use the second and third, the value is 6.
## Default is all processors (when entry is commented out).
#CONNECTION_TIMEOUT 180
## Seconds to wait before concluding an attempt to connect has failed.
DATABASE_CACHE_PAGES 10000
#DATABASE_CACHE_PAGES 2048
## Server-wide default for the number of database pages
## to allocate in memory per database.
## Can be overridden by clients.
#DEADLOCK_TIMEOUT 10
## Seconds before an ungranted lock causes a scan to check for deadlocks.
#DUMMY_PACKET_INTERVAL 60
## Seconds to wait on a silent client connection before the
## server sends dummy packets to request acknowledgment.
#ENABLE_HYPERTHREADING 1
## Specifies whether Intel Hyper-threading technology enabled logical
## processors should be enabled
## Valid values are: 1 (enable), 0 (disable)
## Default: 0 (disable)
#EXTERNAL_FILE_DIRECTORY
## If your external files are not in <interbase_home>/ext,
## specify their location here. For security reasons, do not
## put other files in this directory.
#EXTERNAL_FUNCTION_DIRECTORY
## If your UDF library is not in <interbase_home>/UDF, then specify
## the location of the library here. For security reasons, do not
## put other files in this directory.
#LOCK_ACQUIRE_SPINS 0
## Number of spins during a busy wait on the lock table mutex.
## Relevant only on SMP machines.
#LOCK_HASH_SLOTS 101
## Tune lock hash list; more hash slots mean shorter hash chains.
## Not necessary except under very high load.
## Prime number values are recommended.
#MAX_THREADS 1000000
## Controls the maximum number of threads that can be active
## at one time within the InterBase engine. The listed value
## applies to a system with multiple licensed CPUs. For a
## single CPU system, the value defaults to 1 which eliminates
## the synchronization overhead required by multiple CPUs.
#SERVER_CLIENT_MAPPING 4096
## Size in bytes of one client’s portion of the memory mapped
## file used for interprocess communication.
SERVER_PRIORITY_CLASS 2
## Priority of the InterBase service on Windows NT, 2000, or XP.
## The value 1 is low priority, 2 is high priority.
## Relevant only on Windows NT/2000/XP.
#SERVER_WORKING_SIZE_MAX 0
## Threshold above which the OS is requested to swap out all memory.
## Relevant only on Windows NT, 2000, and XP
## Default is system-determined
#SERVER_WORKING_SIZE_MIN 0
## Threshold below which the OS is requested to swap out no memory
## Relevant only on Windows NT, 2000, and XP
## Default is system-determined
#SWEEP_QUANTUM 250
## Specifies the maximum number of records that a garbage collector
## thread or a sweeper thread is allowed to work before yielding
## control back to the worker threads.
#SWEEP_YIELD_TIME 1
## Specifies the time, in milliseconds, the sweeper or
## garbage collector thread sleeps.
#TCP_REMOTE_BUFFER 8192
## TCP/IP buffer size for send and receive buffers. This applies to
## both client and server programs.
## Default is 8192 bytes. Valid range is 1448 to 32768
#TMP_DIRECTORY
## Directory to use for storing temporary files.
## Specify directory path and number of bytes available in the directory.
## List multiple entries one per line; directories are
## used in the order specified.
## Default is the value of the INTERBASE_TMP environment
## variable; otherwise /tmp on UNIX or C:\temp on Windows NT/2000/XP.
#USER_QUANTUM 250
## Specifies the maximum number of records that a worker thread
## (thread running an user query) is allowed to work before
## yielding control back to other threads.
#V4_EVENT_MEMSIZE 32768
## Bytes of shared memory allocated for event manager.
## Overridden by ANY_EVENT_MEMSIZE.
#V4_LOCK_GRANT_ORDER 1
## 1 means locks are granted first come, first served.
## 0 means emulate InterBase V3.3 behavior, where locks are granted
## as soon as they are available; can result in lock request starvation.
#V4_LOCK_MEM_SIZE 98304
## Bytes of shared memory allocated for lock manager.
## Default is 98304 on Linux and Solaris, 256K on Windows.
## Overridden by ANY_LOCK_MEM_SIZE.
#V4_LOCK_SEM_COUNT 32
## Number of semaphores for interprocess communication
## (Classic architecture only).
## Overridden by ANY_LOCK_SEM_COUNT.
#V4_LOCK_SIGNAL 16
## UNIX signal to use for interprocess communication
## (Classic architecture only).
## Overridden by ANY_LOCK_SIGNAL.
#V4_SOLARIS_STALL_VALUE 60
## Number of seconds a server process waits before retrying
## for the lock table mutex.
## Relevant on Solaris only.
|
Librerias UDF
¿Alguna idea?
gracias de antemano