Hello!
I have installed SQL Server 2005 Standard Edition on 64 bit Windows 2003.
My question is if I can use more than 4 Gb Physical Memory?
Can I install another instance of SQL Server 2005 Standard Edition and use another 4 Gb Physical Memory for that instance?
Is the limitation of 4 Gb memory usage for the whole SQL Server or for each instance?
Hi Fari,
I am just curious as to why you would want multiple instances on one machine. Why dont you just have another database?|||
Hi!
It's "cheaper" to install another instance of sql server then buying another hardware and installing W2003! We are discussing differnt senarios. If buying another server is the only option, then thats the alternativ vi have to take.
|||What is the physical memory available/installed on this server?
One of the article refers:
For 32-bit installations, the use of address windowing extensions (AWE) memory has been improved so that SQL Server 2005 Standard Edition can use more than 3GB of RAM. Also, with 64-bit processors increasingly more prolific and affordable, the benefits of 64-bit server installations are becoming much more accessible. A 64-bit architecture provides significantly larger directly addressable memory space (compared to 32-bit) for all database operations, and eliminates the need for the AWE mechanism.
|||Hi!
We have 6 GB physical memory availabe on our 64- bit server.
I found in other places in books online that I can use as much memory as installed on the server and that I do not need to use AWE on the 64 bit server.
Is that true?
|||Yes if its a 64 bit then need not use AWE settings.
Check on SQL Server properties about the memory settings to see how much is allocated, also run SYSMON to capture the resource usage.
|||Thanks for your help!
No comments:
Post a Comment