Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Interpreting Profiler Locking info

Status
Not open for further replies.
gdub

gdub

Technical User
Nov 8, 2001
10
0
0
GB
Hi.

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
 
Status
Not open for further replies.

Similar threads

malaygal
  • Locked
  • Question
Locking row from a view
Replies
1
Views
37
NoCoolHandle
NoCoolHandle
EM1107
  • Locked
  • Question
Help finding a way to show my information on one row 3
Replies
11
Views
38
dhookom
dhookom
bmacbmac
  • Locked
  • Question
select xp_cmdshell 'DIR' info plus additional data on the same results row?
Replies
6
Views
86
bmacbmac
bmacbmac
bmacbmac
  • Locked
  • Question
How to hashbytes SQL information for one record spanning multiple rows 1
Replies
5
Views
80
Olaf Doschke
Olaf Doschke
Cpreston
  • Locked
  • Question
Adding an Alias column with standard information 1
Replies
3
Views
43
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top