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. <SL> This is a known problem with 64 bit versions of all Windows products. <SL> The problem is that 64bit build want to use up to 1TB of RAM (ie. all available) for file cache purposes. <SL> You need to look the Dynamic Windows Cache service from Microsoft. Sean
