Browse by Tags

Address Windowing Extensions (AWE) requires the 'lock pages in memory' privilege which is not currently present in the access token of the process

Published 21 May 8 4:20 AM | SSQA.net

The main difference betwen 32 bit and 64 bit server is Memory, you may be aware about 'Lock Page in memory' privilege to be granted to the SQL Server service accout within 32 bit based servers. This is a operating system based privilege that is...

Filed under: sql server, best practices, 32 bit, 64 bit, configuration, service account, sp_configure, lock pages in memory

All about SQL Server with 32bit to 64bit cluster migration - steps to take care

Published 15 January 8 2:44 AM | SSQA.net

An interesting cross-post from SSP Blog - read thisblog for more information....( read more ) Read More...

Filed under: sql server, upgrade, best practices, environment, clustering, ssp, 32 bit, 64 bit, forum

How to find which types [32bit or 64bit] and versions of SQL Server can be installed?

Published 20 December 7 8:9 AM | SSQA.net

As there are more tools defaulted to 32 bit it is bit confusing for the software applications that will support X64 based installations. IN the same manner it is a common question out in the newsgroups referring to which types and versions of SQL Server...

Filed under: sql server, download, edition, x64, 32 bit, types, ia64

32bit vs 64 bit what other factors you need to consider?

Published 14 August 7 8:16 AM | SSQA.net

Is 64 bit means more memory? Yes, to be precise. Microsoft has been investing heavily on X64 bit and within couple of years there will be no more development on 32-bit applications, as per the recent road map. So within 32-bit application it is one of...

Filed under: sql server, performance, memory, server, windows, x64, system, hardware, 32 bit, 64 bit