| Subject | Re: [firebird-support] Very very very slow FB 2.5.2 64bit performance on Windows 2008 R2 |
|---|---|
| Author | |
| Post date | 2014-01-21T09:52:17Z |
Maybe your problem is that you buy a internet server from dell, not a database server!
What is the diference? Internet servers from Dell does not have a disk controller WITH physical cache.
Run CrystalDiskMark or other disk benckmark on this computer and in another desktop computer. If it is slow you need to replace your disk controller.
Also read from Helen sayd. You are loosing the point when using a gente ram disk.
Hi.
I am facing a similar situation.
32GB RAM
Dell PowerEdge R420
Intel Xeon CPU E5-2609 two processors 2.40ghz 8 cores
RAID
Firebird 2.5.2 do not use the available resources of the server
even I try to login to the server just one user.
I am using SuperClassic
I felt a little diference by modifying parameters in firebird.conf
like DefaultDbCachePages = 2250 and some others
This increases performance in about 30% in my case
But I expected more.
As Firebird do not use available RAM I created a RAM DRIVE with 10GB and pointed parameter 'TempDirectories' (firebird.conf) to this RAM DRIVE, but FB just uses it rarely in very big 'SELECT'. OK, when FB uses the RAM DRIVE it increases a SELECT speed in more than 80%. I expected FB could use this for every SELECTS and so improve the application.
Hugo Eyng
Em 20/01/2014 20:51, Roland Turcan escreveu:
Hello guys,
I found some info about problems with performance when FB is running
on Win2008R2 which is domain controller.
But in my case is it not DC, but the performance is the worst I met.
It is new server running 10GB of RAM, RAID, ... it is quite new
server box.
It cannot be, that basically dummy update on table with about 700 000
records is executing over one hour. CPU is relaxing, HDD is relaxing
too and I cannot force server to fun faster.
What can I check?
Thanks in advance.
--
Best regards, TRoland
http://www.rotursoft.sk
http://exekutor.rotursoft.sk
-- Atenciosamente, Hugo Eyng