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 b
Check for long running transactions.
Test: disconnect everithing from database and run a gfix -sweep.
If you solved your problem you have long running transactions
Em 20/01/2014 20:51, "Roland Turcan" escreveu:
>
>
> Hello guys,
>
> I found some info about problems with performance when FB is run
> 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, tha
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 modif
At 02:01 p.m. 21/01/2014, Hugo Eyng wrote:
>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 sp
Guten Tag Roland Turcan,
a large Raid Stripe Set can be a real showstopper for Databases
what are your settings for
Database Page Size
and for the Raid
What Type of Raid 1,5,10
Size of the Stripe Set
> Hello guys,
> I found some info about problems with performance when FB is running
> on
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 y
Hi Helen.
Thanks for your answer.
You are right.
But the "Windows 64 file cache performance" was a problem, as said Sean.
Só 'reserving' 10GB as a RAM DRIVE grant that I would have always
available RAM.
But now I solved the 'cache performance' and I will not need RAM DRIVE
anymore.
Even
How you solved your problem?
De: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] Em nome de Hugo Eyng
Enviada em: terça-feira, 21 de janeiro de 2014 10:24
Para: firebird-support@yahoogroups.com
Assunto: Re: [firebird-support] Very very very slow FB 2.5.2 64bit
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
Hi Fabiano.
The numbers of CristalDiskMarkSx64 are better:
662 MB/s read and 169 MB/s write
I don´t know de difference between CristalDiskMarkX64 and DiskMarkSx64
But DiskMarkSx64 gave me better numbers.
Hugo
Em 21/01/2014 07:52, fabianoas...@gmail.com escreveu:
Maybe your problem is that
go Eyng
*Enviada em:* terça-feira, 21 de janeiro de 2014 10:24
*Para:* firebird-support@yahoogroups.com
*Assunto:* Re: [firebird-support] Very very very slow FB 2.5.2 64bit
performance on Windows 2008 R2
Hi Helen.
Thanks for your answer.
You are right.
But the "Windows 64 file cache per
* terça-feira, 21 de janeiro de 2014 10:24
*Para: *firebird-support@yahoogroups.com
<mailto:firebird-support@yahoogroups.com>
*Assunto:* Re: [firebird-support] Very very very slow FB 2.5.2 64bit
performance on Windows 2008 R2
Hi Helen.
Thanks for your answer.
You are right.
But the "
s.com]
*Em nome de *Hugo Eyng
*Enviada em:* terça-feira, 21 de janeiro de 2014 10:24
*Para: *firebird-support@yahoogroups.com
<mailto:firebird-support@yahoogroups.com>
*Assunto:* Re: [firebird-support] Very very very slow FB 2.5.2 64bit
performance on Windows 2008 R2
Hi Helen.
Thanks for your a
t;<< 21.01.2014 15:29 - Fabiano - Desenvolvimento SCI
> "fabi...@sci10.com.br" <mailto:fabi...@sci10.com.br>>>>
>
>
>
> How you solved your problem?
>
> *De: *firebird-support@yahoogroups.com
> <mailto:firebird-support@yahoogroups.com&g
g.html
>>
>> Hugo
>>
>> Em 21/01/2014 12:06, Roland Turcan escreveu:
>>
>> Yes, I am interested too.
>>
>> What was the key to get rid of this problem?
>>
>> Thanks in advance.
>>
>> <<< 21.01.2014
Hi!
> CristalDiskMark:
>
> Seq 468 MB/s Read161 MB/s Write(Ten times faster than a notebook
> vostro 1510 intel core 2 duo 1.8ghz)
>
Sequential Disk performance is completely irrelevant to a database
workload which is 99% random I/O. You need to check the random disk
performance. Make sur
-feira, 21 de janeiro de 2014 10:24
*Para: *firebird-support@yahoogroups.com
<mailto:firebird-support@yahoogroups.com>
*Assunto:* Re: [firebird-support] Very very very slow FB 2.5.2 64bit
performance on Windows 2008 R2
Hi Helen.
Thanks for your answer.
You are right.
But the "Wi
Hello all again,
I have met more computers with Windows 2008 R2 64bit where the performance is
very bad.
I was importing into database about 80 GB files into tables with blob fields I
had to use for server
casual Windows 7 32bit computer to get it done on time.
How can it be, that Intel i3 w
>
>
> 'So the only effective solution seems to disable the random access request
> (i.e. remove the FILE_FLAG_RANDOM_ACCESS flag) from the Windows API calls
> used to create/open the files. Moreover, in this case the file-system cache
> size limit should not be actual anymore, as Windows won't be e
'So the only effective solution seems to disable the random access request
(i.e. remove the FILE_FLAG_RANDOM_ACCESS flag) from the Windows API calls
used to create/open the files. Moreover, in this case the file-system cache
size limit should not be actual anymore, as Windows won't be expanding th
Hi All,
Hereby I notify everyone that Windows 2008R2 has NO performance issues
with Firebird databases till 200Gb in size, and not so many after this size.
In all cases when you see performance degradation at Win2008R2 and
everything is smooth on Linux/Win7/etc - it is not an OS fault, it's a
There are other things that should be considered, specially when you compare
two different hardwares. For example, I know there are some DELL servers
being sold with disk controller with *no cache*! This would be terrible
(regarding performance) when running a database server.
So, the Windows cach
Hi All,
Hereby I notify everyone that Windows 2008R2 has NO performance issues with
Firebird databases till 200Gb in size, and not so many after this size.
In all cases when you see performance degradation at Win2008R2 and
everything is smooth on Linux/Win7/etc - it is not an OS fault, it's a
pro
Hi,
>I suppose we all have our opinions.
This is not an opinion, this is statement, confirmed by our 12 years
experience with Firebird and 5 years with Win 2008.
Your problem with Win2008 is lack of knowledge, that's all, sorry for
the truth.
And I'm not going to offer such technical suppor
Hi,
>I suppose we all have our opinions.
This is not an opinion, this is statement, confirmed by our 12 years
experience with Firebird and 5 years with Win 2008.
Your problem with Win2008 is lack of knowledge, that's all, sorry for the
truth.
And I'm not going to offer such technical support fo
Hi Marius,
Sorry, I don't want to be rude.
I just want to point that there is no problem with Windows 2008 R2, and
a bit tired with all the same questions (with the same answers).
Our largest customers databases are on Win2008R2, and it works just fine
- 500+ users and 150Gb, 440Gb with 50 user
Subject: Re: [firebird-support] Very very very slow FB 2.5.2 64bit
performance on Windows 2008 R2
Hi Marius,
Sorry, I don't want to be rude.
I just want to point that there is no problem with Windows 2008 R2, and a
bit tired with all the same questions (with the same answers).
Our la
yahoogroups.com [mailto:
> firebird-support@yahoogroups.com] *On Behalf Of *Alexey Kovyazin
> *Sent:* Tuesday, February 18, 2014 3:01 PM
> *To:* firebird-support@yahoogroups.com
> *Subject:* Re: [firebird-support] Very very very slow FB 2.5.2 64bit
> performance on Windows 2008 R2
>
>
>
rebird-support@yahoogroups.com]
*Em nome de *Hugo Eyng
*Enviada em:* terça-feira, 21 de janeiro de 2014 10:24
*Para: *firebird-support@yahoogroups.com
<mailto:firebird-support@yahoogroups.com>
*Assunto:* Re: [firebird-support] Very very very slow FB 2.5.2 64bit
performance on Windows 2008 R2
H
Then, If it were only a firebird issue, all of us would have the problem.
If some of us has the problem, may be an incompatibility between FB, OS and
hardware.
Perhaps, if we share information about our environments, the common origin of
the problem would arise.
Jesus Angel Garcia Zarco
Coint
Hello Jesus Garcia,
> Then, If it were only a firebird issue, all of us would have the problem.
> If some of us has the problem, may be an incompatibility between FB, OS and
> hardware.
> Perhaps, if we share information about our environments, the common origin of
> the problem would arise.
44 matches
Mail list logo