I now suspect that it is in fact only 32 bit SQL, however I'd like to verify this.
While reinstalling SQL on the new Windows installation, I went to another of our DB servers to verify a couple of settings.
Once you click on the "Download" button, you will be prompted to select the files you need.
If you need more advanced database features, you can upgrade SQL Server Express seamlessly to more sophisticated editions of SQL Server.
I suspect that AWE has not been configured at all, and therefore the server will be significantly under-utilised (remembering that the OS is 64 bit) if SQL is simply using a downloads 32bit address space.
If I do the same checks on a confirmed 64 bit installation, it does give back the expected 64 bit readings, which can only prove that this server in question is only running in 32 bit.
Microsoft SQL Server 2005 Express Edition (SQL Server Express) is a free, easy-to-use, lightweight version of SQL Server 2005.
For more information about SQL Server Express, including other editions and downloadable components now available, see the.
I apologise that this question is a little vague/lost; I'm no SQL expert, just trying to get a handle on what's going on here.
Task manager reports about 3.5GB memory usage for sqlservr.
Designed for easy deployment and rapid prototyping, SQL Server Express is available at no cost, and you are free to redistribute it with applications.
Now, that being the case, the question arises about how much memory this '32 bit' install can use.
Xp_msver shows Platform as NT INTEL X86.
Here's some details: The OS is definitely 64 bit.
It is ideal for embedded application clients, light Web applications, and local data stores.
I suspect we may mac just have to configure AWE correctly and let it be for the time being (Unless this is a bad idea?).
It is fast and easy to learn, allowing you to quickly develop and deploy dynamic data-driven applications.
Despite this, it does seem to be running out of the x86 program files folder.
SELECT @VERSION shows Microsoft SQL Server 2005 - (Intel X86).
Note: There are multiple files available for this download.