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

[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

[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

[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] 


*Para: *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 
 [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.








---
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

[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] 


*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

[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] 


*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





 
	Este correo electrónico se ha enviado desde un equipo libre de virus 
y protegido por Avast.
www.avast.com