Hi Fabiano.

My server:

• Intel® Xeon® E5-2609 v2 2.50GHz,10M Cache, 6.4GT/s QPI, No Turbo, 4C, 80W, Max Mem 1333MHz
• 8GB RDIMM, 1600MT/s, Low Volt, Dual Rank, x4 Data Width
• HD 6 x 300GB SAS, 10K RPM, 6GBPS Hot-Plug de 2.5"
• PowerEdgeR620,Intel®Xeon®E-26XXv2Processors

CristalDiskMark:

Seq 468 MB/s Read    161 MB/s Write    (Ten times faster than a notebook vostro 1510 intel core 2 duo 1.8ghz)

 

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.

Em 20/01/2014 23:01, "Hugo Eyng" <hugoeyng@...> escreveu:

 

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

-- 


Atenciosamente,

Hugo Eyng