IB 7.5 performance and crash


2006-01-24 09:12:01 PM
delphi52
Hi all
I have just relocated a database to a new server. I have tried to
optimize the system but it crashes all the time
It runs windows 2003 Enterprise edtion, with 8 Gb Ram and 4 Xeon
processors with licenses. The server is dedicated to run only run
interbase, so I can in theory use all the Ram I want. I say in theory
because I am not sure how to use all the available ram.
Here some info about the system and it is configuration
Database size: 2,1 gb and growing about 5mb per day
There is about 200 clients hook up to the server
IBConfig file looks like this
#V4_LOCK_MEM_SIZE 262144
#V4_LOCK_SEM_COUNT 32
#V4_LOCK_SIGNAL 16
#V4_EVENT_MEM_SIZE 32768
DATABASE_CACHE_PAGES 500000
SERVER_PRIORITY_CLASS 1
SERVER_CLIENT_MAPPING 8192
#SERVER_WORKING_SIZE_MIN 0
#SERVER_WORKING_SIZE_MAX 0
#V4_LOCK_GRANT_ORDER 1
#ANY_LOCK_MEM_SIZE 262144
#ANY_LOCK_SEM_COUNT 32
#ANY_LOCK_SIGNAL 16
#ANY_EVENT_MEM_SIZE 32768
#LOCK_HASH_SLOTS 101
DEADLOCK_TIMEOUT 30
#LOCK_ACQUIRE_SPINS 0
#CONNECTION_TIMEOUT 180
DUMMY_PACKET_INTERVAL 60
#TRACE_MEMORY_POOLS 0
#TCP_REMOTE_BUFFER 8192
CPU_AFFINITY 15
ENABLE_HYPERTHREADING 1
#SWEEP_QUANTUM 250
#USER_QUANTUM 1000
#SWEEP_YIELD_TIME 1
MAX_THREADS 10000
#ADMIN_DB 0
#USE_SANCTUARY 0
#SORTMEM_BUFFER_SIZE 1048500
#SQL_COMPILER_RECURSION 2000
And database stats like this:
Database header page information:
Flags 0
Checksum 12345
Generation 3939
Page size 8192
ODS version 11.2
Oldest transaction 1428
Oldest active 1429
Oldest snapshot 1429
Next transaction 31873
Bumped transaction 1
Sequence number 0
Next attachment ID 0
Implementation ID 16
Shadow count 0
Page buffers 62000
Next header page 0
Database dialect 3
Creation date Jan 23, 2006 23:22:34
Attributes
Variable header data:
Sweep interval: 20000
*END*
Any