I hope to find supportive information regarding, using 4 gig of RAM on a 32Bit Windows(XP Pro) system. I think the IT of my company is really trying to challenge or just insulting my intelligence with their responses.
To state my problem:
Our testing units have to almost run realtime and bring the right performance with loading Call by reference Nodes at a decent speed. Since the system is running pretty preformance hungry processes like Microsoft Sql Server Express 2005 which takes around 570MB of RAM and LabVIEW uses with the loaded test almost 160MB of RAM, plus the virus scanner the IT(very critical while running a test!). Sad to say the specs on the computer are P(R)4 3Ghz with 1Gig RAM.
Well I've requested then at the IT an upgrade to 4 gig per unit, to improve the performance for the SQL and LabVIEW to reduce the overhead calling the Reference. It was fully clear on my side that XP will not complete will be able to use the full resources of 4 gig, approximatley 3.2 to 3.5 gig allocatable by the OS, since the BIOS, Graphic Cards and so on will take up some of the RAM. But come on! RAM doesn't cost that much anymore these days!
The response IT returned was:"XP just supports 2 gig", , to be honest I almost cried for laughing after I've heard this one. So I've send them the link from Microsoft
Which says :
The major differentiator between 32-bit and 64-bit Windows is in memory support. Currently, 32-bit Windows is capable of supporting up to 4 GB of system memory, with up to 2 GB of dedicated memory per process. Windows XP 64-Bit Edition will currently support up to 16 GB of RAM, with the potential to support up to 16 TB of virtual memory as hardware capabilities and memory sizes grow.
The responds to this from the IT in the evening was:
"Mircosoft advices for business use a maximum of 3gig of Ram"
Has anybody heard from such a statement from Microsoft?
Since I've always received very valuable information in this forum, I hope to get supportive informations or links for upgrading to 4 gig or tell me if I am just wrong and possible reason for not upgrading to 4 gig. Eventually I want to switch to linux so all RAM can be allocated.
Thank you in advance,
I do not see why you can not have the SQL server on another machine and tie it in that way. If you are using the same disk drive, you are probably limited to about 25 to 100 transaction per second (limitation of the disk drive). If you are using ethernet connection, unless you are using really large transactions, you could use dedicated ethernet connection or better yet 1 Gbit ethernet connection.
Another point, SQL server is resource hog and potentially slow your real time response down.
I think the 3.5 Gbyte is when you switch on PAE. But it does nothing for your process. It still limited to 2 Gbytes. It allows the machine to use more memory so that more process can stay in memory. You can possibly work around it by having a multiprocessor machine.