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 with 4GB RAM 32bit is 6 times faster that multi
CPU Xeon server.
Every core was 100% busy when executing SQL statements.
...
I don't believe that I am the only one having these problems.
This is a known problem with 64 bit versions of all Windows products.
The problem is that 64bit build want to use up to 1TB of RAM (ie. all
available) for file cache purposes.
You need to look the Dynamic Windows Cache service from Microsoft.
Sean