Wednesday, March 28, 2012

Lock resources in Bpool ??

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...
know[vbcol=seagreen]
>|||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...
> rights.
> know
>

No comments:

Post a Comment