[firebase-br] Ajuda com Performance! Configurações FB3

[Stanley Mendes]

Olá amigos,
Estou em busca de melhorar o desempenho em um ambiente e venho aqui pedir
pela ajuda de vocês.

Gostaria de apresentar o ambiente que possuímos atualmente.

Server:
Windows Server 2008 - 64bits
Intel Xeon CPU E5-2620
32GB of RAM

Nesse server eu tenho 14 banco de dados rodando no FB3 SuperServer.

*databases* *size (GB)*
BD001 1,6
BD002 3,1
BD003 2,1
BD004 2,1
BD005 3,8
BD006 2,1
BD007 0,2
BD008 2,6
BD009 0,8
BD010 3,4
BD011 1,6
BD012 0,8
BD013 2,05
BD014 2,1
14 *28,35*

Diariamente recebemos cerca de 300 conexões.

Segue abaixo o arquivo firebird.conf, um técnico fez alterações nele
baseado em um arquivo de performance disponibilizado pela IBSurgeon.

# Firebird configuration file for Firebird 3.0 64-bit SuperServer
# Optimized by IBSurgeon (www.ib-aid.com) for HQbird distribution.
#
# This is an optimized configuration for Firebird 3.0 SuperServer 64 bit,
it can be used
# instead of standard firebird.conf from 3.0 distribution - copy it to
Firebird folder,
# rename it to firebird.conf, then restart Firebird
# (all users should be disconnected before restart!). Keep old config as a
backup!
# Please be aware that some settings can be configured at database level
(in databases.conf)
#
# If you need configuration file, optimized for your specific environment
# to get the best possible performance, or if your performance problem
# still persists after configuration changes, contact us:
#
http://www.ibsurgeon.com/en/firebird-interbase-performance-optimization-service/
# or via email support em ib-aid.com

# Make sure you have HQBird plugins (fbtrace2db and replconf) in plugins
folder of Firebird
#

*ServerMode = Super*

#DatabaseAccess = Full
#RemoteAccess = true
#ExternalFileAccess = None
#UdfAccess = Restrict UDF
#TempDirectories =
#AuditTraceConfigFile =
#MaxUserTraceLogSize = 10

*DefaultDbCachePages = 150000*

#DatabaseGrowthIncrement = 128M
#FileSystemCacheThreshold = 64K
#FileSystemCacheSize = 0
#RemoteFileOpenAbility = 0



*TempBlockSize = 2MTempCacheLimit = 364M*
# AuthServer and AuthClient determine what authentication methods will be
used
# by network server and client redirector. Secure remote passwords plugin
# is default one. Except configured by default SRP plugin firebird also has
# Legacy_Auth plugin which is used to emulate pre-FB3 login protocol making
it
# possible for client to talk to old servers and for server to listen to
requests
# from old clients. Legacy_Auth is VERY unsecure. On windows Win_Sspi
plugin may
# be also used - it implements windows trusted authentication and backward
# compatible with 2.1 and 2.5 clients and servers running on windows.
# Per-database configurable.



*AuthServer = Legacy_Auth, Srp, Win_SspiAuthClient = Legacy_Auth, Srp,
Win_SspiUserManager = Legacy_Auth, Srp*

#hqbird traceapi plugin should be in plugins folder!
#TracePlugin = fbtrace2db

#CryptPlugin = Arc4
#KeyHolderPlugin =
#Providers = Remote,Engine12,Loopback
#DeadlockTimeout = 10
#MaxUnflushedWrites = 100
#MaxUnflushedWriteTime = 5
#BugcheckAbort = 0
#RelaxedAliasChecking = 0
#ConnectionTimeout = 180
#(for client) / Required (for server)

*WireCrypt = Enabled *
#DummyPacketInterval = 0
#RemoteServiceName = gds_db

*RemoteServicePort = 3050*

#RemoteAuxPort = 0
#TcpRemoteBufferSize = 8192
#TcpNoNagle = 1
#RemoteBindAddress =

*LockMemSize = 32M*
#LockAcquireSpins = 0
*LockHashSlots = 30011*

#EventMemSize = 64K
#CpuAffinityMask = 0
#GCPolicy = combined
#SecurityDatabase = $(dir_secDb)/security3.fdb

*GuardianOption = 1*

#ProcessPriorityLevel = 0
#IpcName = FIREBIRD
#RemotePipeName = interbas

Obrigado pela atenção de todos!