ankur_libra (4/26/2013)
Hi All,As per below link article:-
http://support.microsoft.com/kb/970070
Support for Locked Pages on SQL Server 2005 Standard Edition 64-bit systems was made available from
"Cumulative update package 4 for SQL Server 2005 Service Pack 3"
onwards.
Can anyone please let me know about the:-
1. Is Lock pages in memory availability on SQL Server 2005 Standard Edition 32-bit systems ?
Yes, by enabling AWE.
2. On which version (SP + CU) on 32 bit systems for SS 2005 Standard Edn 32 bit, support for locak pages in memory is available?
Since RTM as far as I know. Only the 64-bit editions had the shortfall since they do not respect the AWE flag, hence the addition of support via a Trace Flag in a later CU.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato