I have read that the memory allocated for locks is finite. I wanted to know
what that finite number is and in which compartment of the SQL Server memory
portion does it reside in..BPool or MemToLeave ? Also what about user
connection info ..where is that stored ?Both lock memory and user connection memory come from the buffer pool.
--
Ryan Stonecipher
Microsoft Sql Server Storage Engine, DBCC
This posting is provided "AS IS" with no warranties, and confers no rights.
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:OXrSsnLBFHA.3588@.TK2MSFTNGP11.phx.gbl...
>I have read that the memory allocated for locks is finite. I wanted to know
> what that finite number is and in which compartment of the SQL Server
> memory
> portion does it reside in..BPool or MemToLeave ? Also what about user
> connection info ..where is that stored ?
>|||And whats the finite amount of memory allocated for locks ?
"Ryan Stonecipher [MSFT]" <ryanston@.microsoft.com> wrote in message
news:ePRsJ9QBFHA.608@.TK2MSFTNGP15.phx.gbl...
> Both lock memory and user connection memory come from the buffer pool.
> --
> Ryan Stonecipher
> Microsoft Sql Server Storage Engine, DBCC
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Hassan" <fatima_ja@.hotmail.com> wrote in message
> news:OXrSsnLBFHA.3588@.TK2MSFTNGP11.phx.gbl...
> >I have read that the memory allocated for locks is finite. I wanted to
know
> > what that finite number is and in which compartment of the SQL Server
> > memory
> > portion does it reside in..BPool or MemToLeave ? Also what about user
> > connection info ..where is that stored ?
> >
> >
>|||It is a moving value based on a percentage of buffer pool resources. I
wouldn't be concerned with the actual value, as it could change from release
to release. "Inside SQL Server 2000" has a good chapter on lock manager
internals.
--
Ryan Stonecipher
Microsoft Sql Server Storage Engine, DBCC
This posting is provided "AS IS" with no warranties, and confers no rights.
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:OKHfoARBFHA.3592@.TK2MSFTNGP11.phx.gbl...
> And whats the finite amount of memory allocated for locks ?
> "Ryan Stonecipher [MSFT]" <ryanston@.microsoft.com> wrote in message
> news:ePRsJ9QBFHA.608@.TK2MSFTNGP15.phx.gbl...
>> Both lock memory and user connection memory come from the buffer pool.
>> --
>> Ryan Stonecipher
>> Microsoft Sql Server Storage Engine, DBCC
>> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>> "Hassan" <fatima_ja@.hotmail.com> wrote in message
>> news:OXrSsnLBFHA.3588@.TK2MSFTNGP11.phx.gbl...
>> >I have read that the memory allocated for locks is finite. I wanted to
> know
>> > what that finite number is and in which compartment of the SQL Server
>> > memory
>> > portion does it reside in..BPool or MemToLeave ? Also what about user
>> > connection info ..where is that stored ?
>> >
>> >
>>
>
No comments:
Post a Comment