Monday, March 26, 2012

Mode column for Lock:Acquired event in profiler

Is there any article that have the list of available values and their explanations for MODE column of Lock:Acquired event in profiler?
Thanks.Hi Jeffrey
There seems to be a bug with the mode column not correctly reporting. If it
is working, you can find the values for lock mode in the docs for the
syslockinfo system table, for the column called req_mode.
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Jeffrey" <anonymous@.discussions.microsoft.com> wrote in message
news:486B0DF0-14AF-4B6D-85E3-7117600E28D0@.microsoft.com...
> Is there any article that have the list of available values and their
explanations for MODE column of Lock:Acquired event in profiler?
> Thanks.|||Thanks. I've looked at the syslocks table, seems the value there is different from the values shown by profiler tool itself.
Which one is more accurate? What the bug it is? Is there any article about this?
Thanks.|||Please use syslockinfo instead of syslocks. I have reported the bug, because
I discovered this inaccuracy in Profiler about a month ago, but I have not
gotten an actual bug number yet, and no one has written a KB article about
it.
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Jeffrey" <anonymous@.discussions.microsoft.com> wrote in message
news:37261015-1C15-4237-8E3B-80152DFF7E31@.microsoft.com...
> Thanks. I've looked at the syslocks table, seems the value there is
different from the values shown by profiler tool itself.
> Which one is more accurate? What the bug it is? Is there any article about
this?
> Thanks.|||Hmmm, very interesting...
BTW, where I can know the level of the lock, i.e., page level or row level, etc and the source id of the lock?
Thank you very much.|||Again, you need to correlate the info from Profiler documentation with the
syslockinfo documentation. The page describing "Locks Data Columns" in
Profiler, tells you that the binary data column represents the locked
resource, which is the row, page or table. The value in the column will
match something in syslockinfo.rsc_type
"Locks Data Columns" also tells you that ObjectID column in Profiler is
populated to tell you the object that the lock was taken on.
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Jeffrey" <anonymous@.discussions.microsoft.com> wrote in message
news:1DE6F8AB-B91A-4E2F-8FAC-377ECA4101EA@.microsoft.com...
> Hmmm, very interesting...
> BTW, where I can know the level of the lock, i.e., page level or row
level, etc and the source id of the lock?
> Thank you very much.

No comments:

Post a Comment