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.

Missing events in sql server 2005 profiler

I just opened sql server 2005 profiler for the first time and I only have 4
event categories and a total of 6 events!!!!!
I know this cant be right. Am I missing a configuration setting somewhere?
Did you try checking the checkbox labeled "Show all events"?
Aaron Bertrand
SQL Server MVP
http://www.sqlblog.com/
http://www.aspfaq.com/5006
"john conwell" <johnconwell@.discussions.microsoft.com> wrote in message
news:2A65EA21-4FFC-4FBF-99D7-471DA9793412@.microsoft.com...
>I just opened sql server 2005 profiler for the first time and I only have 4
> event categories and a total of 6 events!!!!!
> I know this cant be right. Am I missing a configuration setting
> somewhere?
|||I would, but the checkbox is disabled :-(
"Aaron Bertrand [SQL Server MVP]" wrote:

> Did you try checking the checkbox labeled "Show all events"?
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.sqlblog.com/
> http://www.aspfaq.com/5006
>
>
> "john conwell" <johnconwell@.discussions.microsoft.com> wrote in message
> news:2A65EA21-4FFC-4FBF-99D7-471DA9793412@.microsoft.com...
>
>
|||Nevermind...I was being silly. On a new trace the check box is enabled :-)
"Aaron Bertrand [SQL Server MVP]" wrote:

> Did you try checking the checkbox labeled "Show all events"?
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.sqlblog.com/
> http://www.aspfaq.com/5006
>
>
> "john conwell" <johnconwell@.discussions.microsoft.com> wrote in message
> news:2A65EA21-4FFC-4FBF-99D7-471DA9793412@.microsoft.com...
>
>