Connection contexts and Lock Resources..

Is this stored in the buffer pool in SQL 2000 ? And if so, does it extend to
the AWE if need be as well or is it just limited to non AWE memory.
Thank you..Hassan
Yes , locks 'mean' memory. Can you elaborate about AWE question?
"Hassan" <Hassan@.hotmail.com> wrote in message
news:%23wVbbIiMHHA.960@.TK2MSFTNGP04.phx.gbl...
> Is this stored in the buffer pool in SQL 2000 ? And if so, does it extend
> to the AWE if need be as well or is it just limited to non AWE memory.
> Thank you..
>|||The ONLY thing that can live in memory above 2GB (or 3GB if /3GB is set) on
a 32 bit machine is data that is cached in the data buffer pool.
Andrew J. Kelly SQL MVP
"Hassan" <Hassan@.hotmail.com> wrote in message
news:%23wVbbIiMHHA.960@.TK2MSFTNGP04.phx.gbl...
> Is this stored in the buffer pool in SQL 2000 ? And if so, does it extend
> to the AWE if need be as well or is it just limited to non AWE memory.
> Thank you..
>|||Thanks Andrew
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:eMcjfBoMHHA.992@.TK2MSFTNGP06.phx.gbl...
> The ONLY thing that can live in memory above 2GB (or 3GB if /3GB is set)
> on a 32 bit machine is data that is cached in the data buffer pool.
> --
> Andrew J. Kelly SQL MVP
> "Hassan" <Hassan@.hotmail.com> wrote in message
> news:%23wVbbIiMHHA.960@.TK2MSFTNGP04.phx.gbl...
>

Connection contexts and Lock Resources..

Is this stored in the buffer pool in SQL 2000 ? And if so, does it extend to
the AWE if need be as well or is it just limited to non AWE memory.
Thank you..
Hassan
Yes , locks 'mean' memory. Can you elaborate about AWE question?
"Hassan" <Hassan@.hotmail.com> wrote in message
news:%23wVbbIiMHHA.960@.TK2MSFTNGP04.phx.gbl...
> Is this stored in the buffer pool in SQL 2000 ? And if so, does it extend
> to the AWE if need be as well or is it just limited to non AWE memory.
> Thank you..
>
|||The ONLY thing that can live in memory above 2GB (or 3GB if /3GB is set) on
a 32 bit machine is data that is cached in the data buffer pool.
Andrew J. Kelly SQL MVP
"Hassan" <Hassan@.hotmail.com> wrote in message
news:%23wVbbIiMHHA.960@.TK2MSFTNGP04.phx.gbl...
> Is this stored in the buffer pool in SQL 2000 ? And if so, does it extend
> to the AWE if need be as well or is it just limited to non AWE memory.
> Thank you..
>
|||Thanks Andrew
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:eMcjfBoMHHA.992@.TK2MSFTNGP06.phx.gbl...
> The ONLY thing that can live in memory above 2GB (or 3GB if /3GB is set)
> on a 32 bit machine is data that is cached in the data buffer pool.
> --
> Andrew J. Kelly SQL MVP
> "Hassan" <Hassan@.hotmail.com> wrote in message
> news:%23wVbbIiMHHA.960@.TK2MSFTNGP04.phx.gbl...
>

Connection contexts and Lock Resources..

Is this stored in the buffer pool in SQL 2000 ? And if so, does it extend to
the AWE if need be as well or is it just limited to non AWE memory.
Thank you..Hassan
Yes , locks 'mean' memory. Can you elaborate about AWE question?
"Hassan" <Hassan@.hotmail.com> wrote in message
news:%23wVbbIiMHHA.960@.TK2MSFTNGP04.phx.gbl...
> Is this stored in the buffer pool in SQL 2000 ? And if so, does it extend
> to the AWE if need be as well or is it just limited to non AWE memory.
> Thank you..
>|||The ONLY thing that can live in memory above 2GB (or 3GB if /3GB is set) on
a 32 bit machine is data that is cached in the data buffer pool.
--
Andrew J. Kelly SQL MVP
"Hassan" <Hassan@.hotmail.com> wrote in message
news:%23wVbbIiMHHA.960@.TK2MSFTNGP04.phx.gbl...
> Is this stored in the buffer pool in SQL 2000 ? And if so, does it extend
> to the AWE if need be as well or is it just limited to non AWE memory.
> Thank you..
>|||Thanks Andrew
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:eMcjfBoMHHA.992@.TK2MSFTNGP06.phx.gbl...
> The ONLY thing that can live in memory above 2GB (or 3GB if /3GB is set)
> on a 32 bit machine is data that is cached in the data buffer pool.
> --
> Andrew J. Kelly SQL MVP
> "Hassan" <Hassan@.hotmail.com> wrote in message
> news:%23wVbbIiMHHA.960@.TK2MSFTNGP04.phx.gbl...
>> Is this stored in the buffer pool in SQL 2000 ? And if so, does it extend
>> to the AWE if need be as well or is it just limited to non AWE memory.
>> Thank you..
>