Sql Profiler Locking Interpretation 1

[gdub]

Hi

Sorry if this is cross posting but I put it in the programmers section before and in retrospect is probably more appropriate here.

I am running SQL Profiler to see what locking is going on in an application server environment. I am particularly interested in seeing whether the locks are at row / page or table level. The only column I can see that might provide that info is ObjectID. But I don't know how to interpret whether an ObjectID is a row or a page. Could anyone give me some advice of how to gleam this info from the profiler output?

Thanks
Glyn

 

[jgoodman00]

Yup, under data columns select Mode & Binary data. Binary data gives you the lock object, & Mode gives the lock type...

James Goodman MCSE, MCDBA

http://www.angelfire.com/sports/f1pictures

 

[gdub]

Thanks for the reply. Do you know how to convert the binary data reference into an indication of what the object is?

 

[jgoodman00]

Yup, the binary data is displayed in plain text in the lower pane of SQL profiler...



James Goodman MCSE, MCDBA

http://www.angelfire.com/sports/f1pictures

 

[gdub]

Ah I see. Thanks very much. One last question. When saving this to a file or a table is there any way to get that info stored so when it is being reviewed I can see what the binary data represented?

 

[jgoodman00]

Unfortunately, it would appear that decoding the binary output is almost impossible outside of Profiler. A number of newgroup users have asked the same question & I am yet to see a satisfactory answer...



James Goodman MCSE, MCDBA

http://www.angelfire.com/sports/f1pictures

 

[gdub]

Still that's something I can work with. Thanks very much for your help.

 

[jgoodman00]

In profiler:
For events select Lock Acquired, Lock Released, & Lock Deadlock.

For data-columns select Mode & Binary data.

This should give you the spid, lock type & the lock mode...

James Goodman MCSE, MCDBA

http://www.angelfire.com/sports/f1pictures