Re: [firebird-support] Bad performance of Firebird in Windows Server 2012

2016-01-01 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] 
31.12.2015 23:05, Eduardo guse...@gmail.com [firebird-support] wrote:
> Disk caching should be disabled in order to use the drive with SQL Server.


   Anybody can mix up disk cache and OS cache.


-- 
   WBR, SD.

Re: [firebird-support] Bad performance of Firebird in Windows Server 2012

2016-01-01 Thread Eduardo guse...@gmail.com [firebird-support] 

I am not an expert in these subjects. I am just learning. :-)

But that's just what I understood. They recommend to disable disk write 
cache when installing SQL Server because of the potential risk of data 
loss and they also talk about enhanced caching controller systems which 
provide cache with less risk.


In my opinion it´s not easy to say if cache is good or bad. If you don´t 
have an "enhanced caching controller", then what is better? To enable or 
to disable disk cache?


Cache is very good for performance. But may be bad if "something" 
happens and there is data loss. It depends on the probability of this 
"something" to happen.


I've been using Firebird for many years in many servers with disk cache 
enabled and I don´t remember having problems.


I was just wondering if the difference in performance with disk cache 
enabled or disabled is similar in others RDBMS.


 Mensaje original ----
*Asunto: *Re: [firebird-support] Bad performance of Firebird in Windows 
Server 2012
*De: *Alexey Kovyazin a...@ib-aid.com [firebird-support] 
<firebird-support@yahoogroups.com>

*Para: *firebird-support@yahoogroups.com
*Fecha: *31/12/2015 21:54


Eduardo,

Did you read this?
"Enhanced caching controller systems disable on-disk cache and provide 
a functional battery-backed caching solution."


The idea of this article that battery-backed cache solutions should be 
used, instead of drives with simple cache.
It does not tell that cache is bad, just highlights the potential risk 
of data loss if caching without BBU is used.


So, essentially you need to buy advanced disk controller and properly 
setup it - that's true.


Regards,
Alexey Kovyazin
IBSurgeon



There is an interesting (and quite long) article about SQL Server and 
disk cache in MS site.


https://support.microsoft.com/en-us/kb/234656

They talk about "enhanced caching controllers" and they say things 
like the following:


  * /- SQL Server installations are targeted at systems that provide
caching controllers. These controllers disable the on-disk caches
and provide stable media caches to satisfy SQL Server I/O
requirements./
  * /- Your SQL Server installation depends on the controller's
ability to disable the on-disk cache and to provide a stable I/O
cache./
  * /- Note: If you have any question about the caching status of
your disk drive, contact the manufacturer and obtain the
appropriate utility or jumper settings to disable write caching
operations./

You even can see a list of different HD drive types (IDE, ATA, SATA, 
SCSI) with instructions to disable disk cache. In any of them you 
will see the following phrase:


  * /- Disk caching should be disabled in order to use the drive with
SQL Server./


---- Mensaje original ----
*Asunto: *Re: [firebird-support] Bad performance of Firebird in 
Windows Server 2012
*De: *Alexey Kovyazin a...@ib-aid.com [firebird-support] 
<firebird-support@yahoogroups.com>

*Para: *firebird-support@yahoogroups.com
*Fecha: *31/12/2015 15:22


Hi Eduardo,

Can you please give links to these articles?

Regards,
Alexey Kovyazin
IBSurgeon




I searched in Google and found that, for instance, MS suggests not 
to install SQL Server in a domain controller, but for security 
reasons. In some articles, MS even recommends to disable disk write 
cache when installing SQL Server.


I searched information about others RDBMS and generally they 
recommend to disable disk write cache to ensure database integrity. 
This seems reasonably. That´s why I am surprised about the 
difference in performance.


Regards

Eduardo





<https://www.avast.com/sig-email?utm_medium=email_source=link_campaign=sig-email_content=emailclient> 
	Este correo electrónico se ha enviado desde un equipo libre de virus 
y protegido por Avast.
www.avast.com 
<https://www.avast.com/sig-email?utm_medium=email_source=link_campaign=sig-email_content=emailclient> 










---
El software de antivirus Avast ha analizado este correo electrónico en busca de 
virus.
https://www.avast.com/antivirus

Re: [firebird-support] Bad performance of Firebird in Windows Server 2012

2015-12-31 Thread Louis Van Alphen lo...@nucleo.co.za [firebird-support] 
What about virtual environments? If one vm on host is pdc and other vm is db 
server?

Sent from my iPhone

> On 31 Dec 2015, at 2:39, "'Carlos H. Cantu' lis...@warmboot.com.br 
> [firebird-support]"  wrote:
> 
> 
> 
> I know, but that's impossible to do on that server. So the only solution I 
> found so far is to install the application in another computer.
> 
> But anyway I would like to understand why this is necessary in Firebird. It 
> would be great if anybody knows the answers to my questions of my previous 
> message.
> 
> 
> Why do you think the problem only happens with Firebird? Use Google and you 
> will find documents from Microsoft telling to not install MSSQL Server in PDC 
> machines. As I said before, any write intensive application (like RDBMS) will 
> suffer with no cache.
>

Re: [firebird-support] Bad performance of Firebird in Windows Server 2012

2015-12-31 Thread Alexey Kovyazin a...@ib-aid.com [firebird-support] 

Hi Eduardo,

Can you please give links to these articles?

Regards,
Alexey Kovyazin
IBSurgeon




I searched in Google and found that, for instance, MS suggests not to 
install SQL Server in a domain controller, but for security reasons. 
In some articles, MS even recommends to disable disk write cache when 
installing SQL Server.


I searched information about others RDBMS and generally they recommend 
to disable disk write cache to ensure database integrity. This seems 
reasonably. That´s why I am surprised about the difference in performance.


Regards

Eduardo

Re: [firebird-support] Bad performance of Firebird in Windows Server 2012

2015-12-31 Thread Eduardo guse...@gmail.com [firebird-support] 
It seems a good idea but I am not the one who configure the server in 
this case and I am not sure if they would like to do that. But, if they 
do that, can I enable disk cache in a VM that is phisically in the same 
disk as another VM which is PDC? The disk cache belongs to the VM or the 
physical disk?


Regards

Eduardo

 Mensaje original 
*Asunto: *Re: [firebird-support] Bad performance of Firebird in Windows 
Server 2012
*De: *Louis Van Alphen lo...@nucleo.co.za [firebird-support] 
<firebird-support@yahoogroups.com>

*Para: *firebird-support@yahoogroups.com <firebird-support@yahoogroups.com>
*Fecha: *31/12/2015 10:01
What about virtual environments? If one vm on host is pdc and other vm 
is db server?


Sent from my iPhone

On 31 Dec 2015, at 2:39, "'Carlos H. Cantu' lis...@warmboot.com.br 
<mailto:lis...@warmboot.com.br> [firebird-support]" 
<firebird-support@yahoogroups.com 
<mailto:firebird-support@yahoogroups.com>> wrote:




	I know, but that's impossible to do on that server. So the only 
solution I found so far is to install the application in another 
computer.


But anyway I would like to understand why this is necessary in 
Firebird. It would be great if anybody knows the answers to my 
questions of my previous message.




Why do you think the problem only happens with Firebird? Use Google 
and you will find documents from Microsoft telling to not install 
MSSQL Server in PDC machines. As I said before, any write intensive 
application (like RDBMS) will suffer with no cache.








---
El software de antivirus Avast ha analizado este correo electrónico en busca de 
virus.
https://www.avast.com/antivirus

Re: [firebird-support] Bad performance of Firebird in Windows Server 2012

2015-12-31 Thread Eduardo guse...@gmail.com [firebird-support] 
There is an interesting (and quite long) article about SQL Server and 
disk cache in MS site.


https://support.microsoft.com/en-us/kb/234656

They talk about "enhanced caching controllers" and they say things like 
the following:


 * /- SQL Server installations are targeted at systems that provide
   caching controllers. These controllers disable the on-disk caches
   and provide stable media caches to satisfy SQL Server I/O requirements./
 * /- Your SQL Server installation depends on the controller's ability
   to disable the on-disk cache and to provide a stable I/O cache./
 * /- Note: If you have any question about the caching status of your
   disk drive, contact the manufacturer and obtain the appropriate
   utility or jumper settings to disable write caching operations./

You even can see a list of different HD drive types (IDE, ATA, SATA, 
SCSI) with instructions to disable disk cache. In any of them you will 
see the following phrase:


 * /- Disk caching should be disabled in order to use the drive with
   SQL Server./


 Mensaje original 
*Asunto: *Re: [firebird-support] Bad performance of Firebird in Windows 
Server 2012
*De: *Alexey Kovyazin a...@ib-aid.com [firebird-support] 
<firebird-support@yahoogroups.com>

*Para: *firebird-support@yahoogroups.com
*Fecha: *31/12/2015 15:22


Hi Eduardo,

Can you please give links to these articles?

Regards,
Alexey Kovyazin
IBSurgeon




I searched in Google and found that, for instance, MS suggests not to 
install SQL Server in a domain controller, but for security reasons. 
In some articles, MS even recommends to disable disk write cache when 
installing SQL Server.


I searched information about others RDBMS and generally they 
recommend to disable disk write cache to ensure database integrity. 
This seems reasonably. That´s why I am surprised about the difference 
in performance.


Regards

Eduardo








---
El software de antivirus Avast ha analizado este correo electrónico en busca de 
virus.
https://www.avast.com/antivirus

Re: [firebird-support] Bad performance of Firebird in Windows Server 2012

2015-12-31 Thread Alexey Kovyazin a...@ib-aid.com [firebird-support] 

Eduardo,

Did you read this?
"Enhanced caching controller systems disable on-disk cache and provide a 
functional battery-backed caching solution."


The idea of this article that battery-backed cache solutions should be 
used, instead of drives with simple cache.
It does not tell that cache is bad, just highlights the potential risk 
of data loss if caching without BBU is used.


So, essentially you need to buy advanced disk controller and properly 
setup it - that's true.


Regards,
Alexey Kovyazin
IBSurgeon



There is an interesting (and quite long) article about SQL Server and 
disk cache in MS site.


https://support.microsoft.com/en-us/kb/234656

They talk about "enhanced caching controllers" and they say things 
like the following:


  * /- SQL Server installations are targeted at systems that provide
caching controllers. These controllers disable the on-disk caches
and provide stable media caches to satisfy SQL Server I/O
requirements./
  * /- Your SQL Server installation depends on the controller's
ability to disable the on-disk cache and to provide a stable I/O
cache./
  * /- Note: If you have any question about the caching status of your
disk drive, contact the manufacturer and obtain the appropriate
utility or jumper settings to disable write caching operations./

You even can see a list of different HD drive types (IDE, ATA, SATA, 
SCSI) with instructions to disable disk cache. In any of them you will 
see the following phrase:


  * /- Disk caching should be disabled in order to use the drive with
SQL Server./


 Mensaje original ----
*Asunto: *Re: [firebird-support] Bad performance of Firebird in 
Windows Server 2012
*De: *Alexey Kovyazin a...@ib-aid.com [firebird-support] 
<firebird-support@yahoogroups.com>

*Para: *firebird-support@yahoogroups.com
*Fecha: *31/12/2015 15:22


Hi Eduardo,

Can you please give links to these articles?

Regards,
Alexey Kovyazin
IBSurgeon




I searched in Google and found that, for instance, MS suggests not 
to install SQL Server in a domain controller, but for security 
reasons. In some articles, MS even recommends to disable disk write 
cache when installing SQL Server.


I searched information about others RDBMS and generally they 
recommend to disable disk write cache to ensure database integrity. 
This seems reasonably. That´s why I am surprised about the 
difference in performance.


Regards

Eduardo





<https://www.avast.com/sig-email?utm_medium=email_source=link_campaign=sig-email_content=emailclient> 
	Este correo electrónico se ha enviado desde un equipo libre de virus 
y protegido por Avast.
www.avast.com 
<https://www.avast.com/sig-email?utm_medium=email_source=link_campaign=sig-email_content=emailclient>

Re: [firebird-support] Bad performance of Firebird in Windows Server 2012

2015-12-30 Thread fabianoas...@gmail.com [firebird-support] 
Eduardo. You problem only will be solved by turning on write cache if
possible or switching to a new cache write enabled server. Dot.
Do not change anything in your software.
Em 30/12/2015 12:15, "Eduardo guse...@gmail.com [firebird-support]" <
firebird-support@yahoogroups.com> escreveu:


>
>
> I read that disabling forced writes is not safe.
>
> But there is something that I really don´t understand.
>
> If I disable forced writes, then when I make commits, data goes to the RAM
> of the server and afterwards, in some moment, the data will be physically
> written to the database.
>
> If I enable disk write cache, then things happen the same way. So, what is
> the difference?
>
> From what I read, I think the difference is that with disk write cache,
> Windows manages when to physically write the data but, when disabling
> forced writes it is not guaranteed that Windows will physically write the
> data. Is this true?
>
> Another question. Why is so different the performance with disk write
> cache enabled or disabled? Is this something that happens in every RDBMS or
> is just a Firebird problem?
>
> Regards
>
> Eduardo
>
>  Mensaje original 
> *Asunto: *Re: [firebird-support] Bad performance of Firebird in Windows
> Server 2012
> *De: *Ann Harrison aharri...@ibphoenix.com [firebird-support]
> <firebird-support@yahoogroups.com> <firebird-support@yahoogroups.com>
> *Para: *firebird-support@yahoogroups.com
> <firebird-support@yahoogroups.com> <firebird-support@yahoogroups.com>
> *Fecha: *29/12/2015 17:26
>
>
> On Tue, Dec 29, 2015 at 2:44 PM, Macma mac...@wp.pl [firebird-support] <
> firebird-support@yahoogroups.com> wrote:
>
>>
>>
>> Do I have to change any configuration or the matter is that if I can´t
>> enable disk cache, there is nothing I can do to improve the performance?
>>
>> Try to disable force write on that database.
>>
>
> After you have a UPS installed and an aggressive backup schedule.
>
> Good luck,
>
> Ann
>
>
>
> <https://www.avast.com/sig-email?utm_medium=email_source=link_campaign=sig-email_content=emailclient>
>  Este
> correo electrónico se ha enviado desde un equipo libre de virus y protegido
> por Avast.
> www.avast.com
> <https://www.avast.com/sig-email?utm_medium=email_source=link_campaign=sig-email_content=emailclient>
>
>

RE: [firebird-support] Bad performance of Firebird in Windows Server 2012

2015-12-30 Thread Suporte TGA Rio Verde - GO suportetga...@outlook.com [firebird-support] 
Olha aqui já tivemos esse problema. Apenas liberamos as portas do firebird  no 
firewall do Windows server 2012 funcionou.
Libera as portas 3050 e 3051 tpc e udp, entrada e saída, tenho certeza que vai 
funcionar.

Desculpa mas não escrevo muito bem em inglês então escrevi em português mesmo.
  Adalton Batista (64) 3612-0066 / 3623-0646
 www.tgasistemasrv.com.br http://www.tgasistemas.com.br/

suportetga...@outlook.com
 ryle...@gmail.com mailto:ryle...@gmail.com

Re: [firebird-support] Bad performance of Firebird in Windows Server 2012

2015-12-30 Thread Eduardo guse...@gmail.com [firebird-support] 
Thank you for the link. I read it but they don´t ensure that in a second 
disk you can enable write cache. Anyway on this server there is only one 
disk.


 Mensaje original 
*Asunto: *Re: [firebird-support] Bad performance of Firebird in Windows 
Server 2012
*De: *'Leyne, Sean' s...@broadviewsoftware.com [firebird-support] 
<firebird-support@yahoogroups.com>

*Para: *firebird-support@yahoogroups.com <firebird-support@yahoogroups.com>
*Fecha: *30/12/2015 16:58




> The other is the fact that PDC machine will always have write cache 
disabled.


It seems that this is not true for all disks attached to PDC server, 
only to boot/Windows drive.


https://social.technet.microsoft.com/Forums/windowsserver/en-US/16352eee-6bc6-4858-8642-12b2496d39ee/how-to-enable-write-caching-on-domain-controller?forum=winserverDS 




Sean






---
El software de antivirus Avast ha analizado este correo electrónico en busca de 
virus.
https://www.avast.com/antivirus

Re: [firebird-support] Bad performance of Firebird in Windows Server 2012

2015-12-30 Thread Eduardo guse...@gmail.com [firebird-support] 
I know, but that's impossible to do on that server. So the only solution 
I found so far is to install the application in another computer.


But anyway I would like to understand why this is necessary in Firebird. 
It would be great if anybody knows the answers to my questions of my 
previous message.


 Mensaje original 
*Asunto: *Re: [firebird-support] Bad performance of Firebird in Windows 
Server 2012
*De: *fabianoas...@gmail.com [firebird-support] 
<firebird-support@yahoogroups.com>

*Para: *firebird-support@yahoogroups.com
*Fecha: *30/12/2015 11:57


Eduardo. You problem only will be solved by turning on write cache if 
possible or switching to a new cache write enabled server. Dot.

Do not change anything in your software.

Em 30/12/2015 12:15, "Eduardo guse...@gmail.com 
<mailto:guse...@gmail.com> [firebird-support]" 
<firebird-support@yahoogroups.com 
<mailto:firebird-support@yahoogroups.com>> escreveu:


I read that disabling forced writes is not safe.

But there is something that I really don´t understand.

If I disable forced writes, then when I make commits, data goes to
the RAM of the server and afterwards, in some moment, the data
will be physically written to the database.

If I enable disk write cache, then things happen the same way. So,
what is the difference?

From what I read, I think the difference is that with disk write
cache, Windows manages when to physically write the data but, when
disabling forced writes it is not guaranteed that Windows will
physically write the data. Is this true?

Another question. Why is so different the performance with disk
write cache enabled or disabled? Is this something that happens in
every RDBMS or is just a Firebird problem?

Regards

Eduardo

 Mensaje original ----
    *Asunto: *Re: [firebird-support] Bad performance of Firebird in
Windows Server 2012
*De: *Ann Harrison aharri...@ibphoenix.com
<mailto:aharri...@ibphoenix.com> [firebird-support]
<firebird-support@yahoogroups.com>
<mailto:firebird-support@yahoogroups.com>
*Para: *firebird-support@yahoogroups.com
<mailto:firebird-support@yahoogroups.com>
<firebird-support@yahoogroups.com>
<mailto:firebird-support@yahoogroups.com>
*Fecha: *29/12/2015 17:26

On Tue, Dec 29, 2015 at 2:44 PM, Macma mac...@wp.pl
<mailto:mac...@wp.pl> [firebird-support]
<firebird-support@yahoogroups.com
<mailto:firebird-support@yahoogroups.com>> wrote:




Do I have to change any configuration or the matter is that
if I can´t enable disk cache, there is nothing I can do to
improve the performance?


Try to disable force write on that database.


After you have a UPS installed and an aggressive backup schedule.

Good luck,

Ann



<https://www.avast.com/sig-email?utm_medium=email_source=link_campaign=sig-email_content=emailclient>
Este correo electrónico se ha enviado desde un equipo libre de
virus y protegido por Avast.
www.avast.com

<https://www.avast.com/sig-email?utm_medium=email_source=link_campaign=sig-email_content=emailclient>







---
El software de antivirus Avast ha analizado este correo electrónico en busca de 
virus.
https://www.avast.com/antivirus

Re: [firebird-support] Bad performance of Firebird in Windows Server 2012

2015-12-30 Thread Eduardo guse...@gmail.com [firebird-support] 
No, this is not the solution. One of the firs things I do when I install 
my application is to create firewall rules for ports 3050 and 3051. In 
this case I even deactivate the firewall but nothing changed.


My english is not perfect, but I can´t write in portuguese!


 Mensaje original 
*Asunto: *Re: [firebird-support] Bad performance of Firebird in Windows 
Server 2012
*De: *Suporte TGA Rio Verde - GO suportetga...@outlook.com 
[firebird-support] <firebird-support@yahoogroups.com>

*Para: *firebird-support@yahoogroups.com
*Fecha: *30/12/2015 07:24
Olha aqui já tivemos esse problema. Apenas liberamos as portas do 
firebird no firewall do Windows server 2012 funcionou.
Libera as portas 3050 e 3051 tpc e udp, entrada e saída, tenho certeza 
que vai funcionar.


Desculpa mas não escrevo muito bem em inglês então escrevi em 
português mesmo.

*Adalton Batista*
(64) 3612-0066 / 3623-0646
*www.tgasistemasrv.com.br <http://www.tgasistemas.com.br/>*
suportetga...@outlook.com
ryle...@gmail.com <mailto:ryle...@gmail.com>






---
El software de antivirus Avast ha analizado este correo electrónico en busca de 
virus.
https://www.avast.com/antivirus

RE: [firebird-support] Bad performance of Firebird in Windows Server 2012

2015-12-30 Thread 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support] 


> The other is the fact that PDC machine will always have write cache disabled.

It seems that this is not true for all disks attached to PDC server, only to 
boot/Windows drive.

https://social.technet.microsoft.com/Forums/windowsserver/en-US/16352eee-6bc6-4858-8642-12b2496d39ee/how-to-enable-write-caching-on-domain-controller?forum=winserverDS


Sean

Re: [firebird-support] Bad performance of Firebird in Windows Server 2012

2015-12-30 Thread 'Carlos H. Cantu' lis...@warmboot.com.br [firebird-support]

Re: [firebird-support] Bad performance of Firebird in Windows Server 2012

2015-12-30 Thread Eduardo guse...@gmail.com [firebird-support] 

I read that disabling forced writes is not safe.

But there is something that I really don´t understand.

If I disable forced writes, then when I make commits, data goes to the 
RAM of the server and afterwards, in some moment, the data will be 
physically written to the database.


If I enable disk write cache, then things happen the same way. So, what 
is the difference?


From what I read, I think the difference is that with disk write cache, 
Windows manages when to physically write the data but, when disabling 
forced writes it is not guaranteed that Windows will physically write 
the data. Is this true?


Another question. Why is so different the performance with disk write 
cache enabled or disabled? Is this something that happens in every RDBMS 
or is just a Firebird problem?


Regards

Eduardo

 Mensaje original 
*Asunto: *Re: [firebird-support] Bad performance of Firebird in Windows 
Server 2012
*De: *Ann Harrison aharri...@ibphoenix.com [firebird-support] 
<firebird-support@yahoogroups.com>

*Para: *firebird-support@yahoogroups.com <firebird-support@yahoogroups.com>
*Fecha: *29/12/2015 17:26
On Tue, Dec 29, 2015 at 2:44 PM, Macma mac...@wp.pl 
<mailto:mac...@wp.pl> [firebird-support] 
<firebird-support@yahoogroups.com 
<mailto:firebird-support@yahoogroups.com>> wrote:





Do I have to change any configuration or the matter is that if I
can´t enable disk cache, there is nothing I can do to improve the
performance?


Try to disable force write on that database.


After you have a UPS installed and an aggressive backup schedule.

Good luck,

Ann





---
El software de antivirus Avast ha analizado este correo electrónico en busca de 
virus.
https://www.avast.com/antivirus

Re: [firebird-support] Bad performance of Firebird in Windows Server 2012

2015-12-29 Thread Macma mac...@wp.pl [firebird-support]

Re: [firebird-support] Bad performance of Firebird in Windows Server 2012

2015-12-29 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support] 
On Tue, Dec 29, 2015 at 2:44 PM, Macma mac...@wp.pl [firebird-support] <
firebird-support@yahoogroups.com> wrote:

>
>
> Do I have to change any configuration or the matter is that if I can´t
> enable disk cache, there is nothing I can do to improve the performance?
>
> Try to disable force write on that database.
>

After you have a UPS installed and an aggressive backup schedule.

Good luck,

Ann

Re: [firebird-support] Bad performance of Firebird in Windows Server 2012

2015-12-25 Thread Eduardo guse...@gmail.com [firebird-support] 

OK, thank you. I understand.

I tried deinstalling 2.1.4 and installing 2.1.7. But the performance was 
the same. Nothing improved! :-(


Do I have to change any configuration or the matter is that if I can´t 
enable disk cache, there is nothing I can do to improve the performance?


Regards

Eduardo

 Mensaje original 
*Asunto: *Re: [firebird-support] Bad performance of Firebird in Windows 
Server 2012
*De: *'Carlos H. Cantu' lis...@warmboot.com.br [firebird-support] 
<firebird-support@yahoogroups.com>
*Para: *Eduardo guse...@gmail.com [firebird-support] 
<firebird-support@yahoogroups.com>

*Fecha: *24/12/2015 14:50


One cache problem is the one mentioned in the article, fixed in 2.1.5, 
etc.


The other is the fact that PDC machine will always have write cache 
disabled.


Carlos
www.firebirdnews.org <http://www.firebirdnews.org>- 
www.FireBase.com.br <http://www.FireBase.com.br>






Carlos:

Thank you for your answer.

I suggested to not configure the server as a domain controller but the 
person who decide this didn´t want!


I already read the article you mention and there is where I found that 
apparently upgrading to 2.1.5 will solve the problem but I was not 
sure. So if I upgrade, the performance would be similar as if disk 
cache was enabled?


I don´t understand what do you mean saying "The cache problem you are 
referring to is another thing". Are there TWO cache problems? Which is 
THE OTHER? Please, can you explain me?


Regards

Eduardo

 Mensaje original ----
*Asunto: *Re: [firebird-support] Bad performance of Firebird in 
Windows Server 2012
*De: *'Carlos H. Cantu' lis...@warmboot.com.br 
<mailto:lis...@warmboot.com.br>[firebird-support] 
<firebird-support@yahoogroups.com> 
<mailto:firebird-support@yahoogroups.com>
*Para: *Eduardo guse...@gmail.com 
<mailto:guse...@gmail.com>[firebird-support] 
<firebird-support@yahoogroups.com> 
<mailto:firebird-support@yahoogroups.com>

*Fecha: *24/12/2015 12:47

Never use Firebird (or any RDBMS) in a PDC machine! Windows will 
always disable write disk cache in PDC, and it will be very bad for 
any write sensitive application, like databases (not only Firebird).


The cache problem you are referring to is another thing, and to solve 
this one, you need to upgrade to 2.1.5 (at last): 
http://dyemanov.blogspot.com.br/2012/03/firebird-vs-windows-file-system-caching.html 



Carlos
www.firebirdnews.org <http://www.firebirdnews.org>- 
www.FireBase.com.br <http://www.FireBase.com.br>







Hi guys:

I have an application developped in Delphi that uses Firebird 
Superserver 2.1.4.18393.


It is installed in a Windows network. During many years, the server 
had Windows Server 2003 and everything worked fine. Some time ago they 
changed it temporarily to another PC with Windows 8.1. Everything 
worked fine.


A few days ago they installed a new server with Windows Server 2012. 
My application is working, but it works very slow. It has a log file 
and I verified that the bad performance occurs in every data base 
access, when it opens a database, when it executes any SQL, etc.


I did a little research and found that, apparently, the problem is 
related with the disk cache. In the old servers, disk cache was 
enabled but in the new one with Windows Server 2012 it is disabled 
and, as the server is configured as a domain controller, as far as I 
know, it can´t be enabled.


I read some articles about problems similar to this one and apparently 
this is a problem related with Firebird. In some articles they said 
that since version 2.1.5 this is solved. ¿Is this true?


¿Updating to 2.1.5 will solve the problem?

¿Is there something I can do to solve this without updating?

Any suggestions will be welcome!

Regards

Eduardo

	Este correo electrónico se ha enviado desde un equipo libre de virus 
y protegido por Avast.
www.avast.com 
<https://www.avast.com/sig-email?utm_medium=email_source=link_campaign=sig-email_content=emailclient> 









	Este correo electrónico se ha enviado desde un equipo libre de virus 
y protegido por Avast.
www.avast.com 
<https://www.avast.com/sig-email?utm_medium=email_source=link_campaign=sig-email_content=emailclient> 











---
El software de antivirus Avast ha analizado este correo electrónico en busca de 
virus.
https://www.avast.com/antivirus

Re: [firebird-support] Bad performance of Firebird in Windows Server 2012

2015-12-24 Thread 'Carlos H. Cantu' lis...@warmboot.com.br [firebird-support]

Re: [firebird-support] Bad performance of Firebird in Windows Server 2012

2015-12-24 Thread Eduardo guse...@gmail.com [firebird-support] 

Carlos:

Thank you for your answer.

I suggested to not configure the server as a domain controller but the 
person who decide this didn´t want!


I already read the article you mention and there is where I found that 
apparently upgrading to 2.1.5 will solve the problem but I was not sure. 
So if I upgrade, the performance would be similar as if disk cache was 
enabled?


I don´t understand what do you mean saying "The cache problem you are 
referring to is another thing". Are there TWO cache problems? Which is 
THE OTHER? Please, can you explain me?


Regards

Eduardo

 Mensaje original 
*Asunto: *Re: [firebird-support] Bad performance of Firebird in Windows 
Server 2012
*De: *'Carlos H. Cantu' lis...@warmboot.com.br [firebird-support] 
<firebird-support@yahoogroups.com>
*Para: *Eduardo guse...@gmail.com [firebird-support] 
<firebird-support@yahoogroups.com>

*Fecha: *24/12/2015 12:47


Never use Firebird (or any RDBMS) in a PDC machine! Windows will 
always disable write disk cache in PDC, and it will be very bad for 
any write sensitive application, like databases (not only Firebird).


The cache problem you are referring to is another thing, and to solve 
this one, you need to upgrade to 2.1.5 (at last): 
http://dyemanov.blogspot.com.br/2012/03/firebird-vs-windows-file-system-caching.html 



Carlos
www.firebirdnews.org <http://www.firebirdnews.org>- 
www.FireBase.com.br <http://www.FireBase.com.br>






Hi guys:

I have an application developped in Delphi that uses Firebird 
Superserver 2.1.4.18393.


It is installed in a Windows network. During many years, the server 
had Windows Server 2003 and everything worked fine. Some time ago they 
changed it temporarily to another PC with Windows 8.1. Everything 
worked fine.


A few days ago they installed a new server with Windows Server 2012. 
My application is working, but it works very slow. It has a log file 
and I verified that the bad performance occurs in every data base 
access, when it opens a database, when it executes any SQL, etc.


I did a little research and found that, apparently, the problem is 
related with the disk cache. In the old servers, disk cache was 
enabled but in the new one with Windows Server 2012 it is disabled 
and, as the server is configured as a domain controller, as far as I 
know, it can´t be enabled.


I read some articles about problems similar to this one and apparently 
this is a problem related with Firebird. In some articles they said 
that since version 2.1.5 this is solved. ¿Is this true?


¿Updating to 2.1.5 will solve the problem?

¿Is there something I can do to solve this without updating?

Any suggestions will be welcome!

Regards

Eduardo

	Este correo electrónico se ha enviado desde un equipo libre de virus 
y protegido por Avast.
www.avast.com 
<https://www.avast.com/sig-email?utm_medium=email_source=link_campaign=sig-email_content=emailclient> 











---
El software de antivirus Avast ha analizado este correo electrónico en busca de 
virus.
https://www.avast.com/antivirus

Re: [firebird-support] Bad performance of Firebird in Windows Server 2012

2015-12-24 Thread 'Carlos H. Cantu' lis...@warmboot.com.br [firebird-support]