What does these values (b60010eb08b2) mean under the resource column for a
KEY type when one runs sp_lock ?Hassan
It's a hashed value of the key which is locked. There is no way to reverse
engineer to determine the value of the key.
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:e$Lt0gWDEHA.2908@.TK2MSFTNGP09.phx.gbl...
> What does these values (b60010eb08b2) mean under the resource column for a
> KEY type when one runs sp_lock ?
>|||Kalen,
I was going over through your e book on Locking and Blocking and was
confused on the % threshold before the lock escalates.
On page 46 , you said 40% and on page 40, you mentioned 3%. Am i not
following something here ? Please clarify
thanks
"Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
news:eXhmYnXDEHA.712@.tk2msftngp13.phx.gbl...
> Hassan
> It's a hashed value of the key which is locked. There is no way to reverse
> engineer to determine the value of the key.
> --
> HTH
> --
> Kalen Delaney
> SQL Server MVP
> www.SolidQualityLearning.com
>
> "Hassan" <fatima_ja@.hotmail.com> wrote in message
> news:e$Lt0gWDEHA.2908@.TK2MSFTNGP09.phx.gbl...
a
>|||i also wanna reverse the key value by hashed value ,
because i wanna know the keys locked !
>--Original Message--
>Hassan
>It's a hashed value of the key which is locked. There is
no way to reverse
>engineer to determine the value of the key.
>--
>HTH
>--
>Kalen Delaney
>SQL Server MVP
>www.SolidQualityLearning.com
>
>"Hassan" <fatima_ja@.hotmail.com> wrote in message
>news:e$Lt0gWDEHA.2908@.TK2MSFTNGP09.phx.gbl...
resource column for a
>
>.
>|||Not doable... sorry
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"rainbow" <anonymous@.discussions.microsoft.com> wrote in message
news:b6bd01c40d8e$1df948d0$a001280a@.phx.gbl...
> i also wanna reverse the key value by hashed value ,
> because i wanna know the keys locked !
>
> no way to reverse
> resource column for a|||Hi Hassan
If you read the entries sentences again, you'll see they see two separate
things. On page 40, it says 3% of memory, on page 46, it says 40% of buffer
pool.
The 40% figure is much more exact. (The 3% figure is just one that a dev
tossed at me when I asked when lock esacation occurs, and he said it was
related to the total memory used, something like 3%. So on page 40 I did say
ABOUT 3%.)
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:uDT$S8XDEHA.3348@.TK2MSFTNGP11.phx.gbl...
> Kalen,
> I was going over through your e book on Locking and Blocking and was
> confused on the % threshold before the lock escalates.
> On page 46 , you said 40% and on page 40, you mentioned 3%. Am i not
> following something here ? Please clarify
> thanks
> "Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
> news:eXhmYnXDEHA.712@.tk2msftngp13.phx.gbl...
reverse
for
> a
>
No comments:
Post a Comment