Traceflag 1212 traces every lock request and release. This can produce a lot of output even for very simple queries.
1> set switch on 3604
2> set switch on 1212 with override
3> go
1> select name from sysobjects where id = 9
2> go
lock_do_logical shared intent db=1 obj=3 pg=0 row=0 ctx=0x0 suff=0 pspid=29 fileindex=106 (colnames.c@@/main/ase157x/asecarina/6 2013-06-16) lineno=5958 LOCK_GRANTED
lock_do_logical shared row db=1 obj=3 pg=40 row=16 ctx=0x0 suff=0 pspid=29 fileindex=50 (bt_getnext.c@@/main/ase157x/asecarina/2 2012-10-31) lineno=2811 LOCK_GRANTED
lock_release shared row db=1 obj=3 pg=40 row=16 splk=0x3ae100 ctx=0x0 suff=0 fileindex=50 (bt_getnext.c@@/main/ase157x/asecarina/2 2012-10-31) lineno=2811
lock_do_logical shared row db=1 obj=3 pg=40 row=16 ctx=0x0 suff=0 pspid=29 fileindex=50 (bt_getnext.c@@/main/ase157x/asecarina/2 2012-10-31) lineno=2811 LOCK_GRANTED
lock_do_logical shared row db=1 obj=3 pg=40 row=2 ctx=0x0 suff=0 pspid=29 fileindex=50 (bt_getnext.c@@/main/ase157x/asecarina/2 2012-10-31) lineno=2811 LOCK_GRANTED
lock_release shared row db=1 obj=3 pg=40 row=16 splk=0x3ae100 ctx=0x0 suff=0 fileindex=50 (bt_getnext.c@@/main/ase157x/asecarina/2 2012-10-31) lineno=2811
lock_release shared row db=1 obj=3 pg=40 row=2 splk=0x3ae100 ctx=0x0 suff=0 fileindex=50 (bt_getnext.c@@/main/ase157x/asecarina/2 2012-10-31) lineno=2811
lock_release shared intent db=1 obj=0 pg=3 row=0 splk=0x3ae0c0 ctx=0x0 suff=0 fileindex=106 (colnames.c@@/main/ase157x/asecarina/6 2013-06-16) lineno=5958
lock_do_logical shared intent db=1 obj=24 pg=0 row=0 ctx=0x0 suff=0 pspid=29 fileindex=699 (statsapi.c@@/main/ase157x/asecarina/7 2013-04-18) lineno=665 LOCK_GRANTED
lock_do_logical shared intent db=1 obj=3 pg=0 row=0 ctx=0x0 suff=0 pspid=29 fileindex=696 (statapi.cpp@@/main/ase157x/asecarina/2 2013-06-16) lineno=713 LOCK_GRANTED
lock_do_logical shared row db=1 obj=3 pg=40 row=16 ctx=0x0 suff=0 pspid=29 fileindex=50 (bt_getnext.c@@/main/ase157x/asecarina/2 2012-10-31) lineno=2811 LOCK_GRANTED
lock_do_logical shared row db=1 obj=3 pg=40 row=2 ctx=0x0 suff=0 pspid=29 fileindex=50 (bt_getnext.c@@/main/ase157x/asecarina/2 2012-10-31) lineno=2811 LOCK_GRANTED
lock_release shared row db=1 obj=3 pg=40 row=16 splk=0x3ae100 ctx=0x0 suff=0 fileindex=50 (bt_getnext.c@@/main/ase157x/asecarina/2 2012-10-31) lineno=2811
lock_do_logical shared row db=1 obj=3 pg=40 row=0 ctx=0x0 suff=0 pspid=29 fileindex=50 (bt_getnext.c@@/main/ase157x/asecarina/2 2012-10-31) lineno=2811 LOCK_GRANTED
lock_release shared row db=1 obj=3 pg=40 row=2 splk=0x3ae100 ctx=0x0 suff=0 fileindex=50 (bt_getnext.c@@/main/ase157x/asecarina/2 2012-10-31) lineno=2811
lock_do_logical shared row db=1 obj=3 pg=40 row=1 ctx=0x0 suff=0 pspid=29 fileindex=50 (bt_getnext.c@@/main/ase157x/asecarina/2 2012-10-31) lineno=2811 LOCK_GRANTED
lock_release shared row db=1 obj=3 pg=40 row=0 splk=0x3ae100 ctx=0x0 suff=0 fileindex=50 (bt_getnext.c@@/main/ase157x/asecarina/2 2012-10-31) lineno=2811
lock_do_logical shared row db=1 obj=3 pg=40 row=3 ctx=0x0 suff=0 pspid=29 fileindex=50 (bt_getnext.c@@/main/ase157x/asecarina/2 2012-10-31) lineno=2811 LOCK_GRANTED
lock_release shared row db=1 obj=3 pg=40 row=1 splk=0x3ae100 ctx=0x0 suff=0 fileindex=50 (bt_getnext.c@@/main/ase157x/asecarina/2 2012-10-31) lineno=2811
lock_do_logical shared row db=1 obj=3 pg=40 row=4 ctx=0x0 suff=0 pspid=29 fileindex=50 (bt_getnext.c@@/main/ase157x/asecarina/2 2012-10-31) lineno=2811 LOCK_GRANTED
lock_release shared row db=1 obj=3 pg=40 row=3 splk=0x3ae100 ctx=0x0 suff=0 fileindex=50 (bt_getnext.c@@/main/ase157x/asecarina/2 2012-10-31) lineno=2811
lock_do_logical shared row db=1 obj=3 pg=40 row=5 ctx=0x0 suff=0 pspid=29 fileindex=50 (bt_getnext.c@@/main/ase157x/asecarina/2 2012-10-31) lineno=2811 LOCK_GRANTED
lock_release shared row db=1 obj=3 pg=40 row=4 splk=0x3ae100 ctx=0x0 suff=0 fileindex=50 (bt_getnext.c@@/main/ase157x/asecarina/2 2012-10-31) lineno=2811
lock_do_logical shared row db=1 obj=3 pg=40 row=6 ctx=0x0 suff=0 pspid=29 fileindex=50 (bt_getnext.c@@/main/ase157x/asecarina/2 2012-10-31) lineno=2811 LOCK_GRANTED
lock_release shared row db=1 obj=3 pg=40 row=5 splk=0x3ae100 ctx=0x0 suff=0 fileindex=50 (bt_getnext.c@@/main/ase157x/asecarina/2 2012-10-31) lineno=2811
lock_do_logical shared row db=1 obj=3 pg=40 row=7 ctx=0x0 suff=0 pspid=29 fileindex=50 (bt_getnext.c@@/main/ase157x/asecarina/2 2012-10-31) lineno=2811 LOCK_GRANTED
lock_release shared row db=1 obj=3 pg=40 row=6 splk=0x3ae100 ctx=0x0 suff=0 fileindex=50 (bt_getnext.c@@/main/ase157x/asecarina/2 2012-10-31) lineno=2811
lock_do_logical shared row db=1 obj=3 pg=40 row=8 ctx=0x0 suff=0 pspid=29 fileindex=50 (bt_getnext.c@@/main/ase157x/asecarina/2 2012-10-31) lineno=2811 LOCK_GRANTED
lock_release shared row db=1 obj=3 pg=40 row=7 splk=0x3ae100 ctx=0x0 suff=0 fileindex=50 (bt_getnext.c@@/main/ase157x/asecarina/2 2012-10-31) lineno=2811
lock_do_logical shared row db=1 obj=3 pg=40 row=9 ctx=0x0 suff=0 pspid=29 fileindex=50 (bt_getnext.c@@/main/ase157x/asecarina/2 2012-10-31) lineno=2811 LOCK_GRANTED
lock_release shared row db=1 obj=3 pg=40 row=8 splk=0x3ae100 ctx=0x0 suff=0 fileindex=50 (bt_getnext.c@@/main/ase157x/asecarina/2 2012-10-31) lineno=2811
lock_do_logical shared row db=1 obj=3 pg=40 row=10 ctx=0x0 suff=0 pspid=29 fileindex=50 (bt_getnext.c@@/main/ase157x/asecarina/2 2012-10-31) lineno=2811 LOCK_GRANTED
lock_release shared row db=1 obj=3 pg=40 row=9 splk=0x3ae100 ctx=0x0 suff=0 fileindex=50 (bt_getnext.c@@/main/ase157x/asecarina/2 2012-10-31) lineno=2811
lock_do_logical shared row db=1 obj=3 pg=40 row=11 ctx=0x0 suff=0 pspid=29 fileindex=50 (bt_getnext.c@@/main/ase157x/asecarina/2 2012-10-31) lineno=2811 LOCK_GRANTED
lock_release shared row db=1 obj=3 pg=40 row=10 splk=0x3ae100 ctx=0x0 suff=0 fileindex=50 (bt_getnext.c@@/main/ase157x/asecarina/2 2012-10-31) lineno=2811
lock_do_logical shared row db=1 obj=3 pg=40 row=12 ctx=0x0 suff=0 pspid=29 fileindex=50 (bt_getnext.c@@/main/ase157x/asecarina/2 2012-10-31) lineno=2811 LOCK_GRANTED
lock_release shared row db=1 obj=3 pg=40 row=11 splk=0x3ae100 ctx=0x0 suff=0 fileindex=50 (bt_getnext.c@@/main/ase157x/asecarina/2 2012-10-31) lineno=2811
lock_do_logical shared row db=1 obj=3 pg=40 row=13 ctx=0x0 suff=0 pspid=29 fileindex=50 (bt_getnext.c@@/main/ase157x/asecarina/2 2012-10-31) lineno=2811 LOCK_GRANTED
lock_release shared row db=1 obj=3 pg=40 row=12 splk=0x3ae100 ctx=0x0 suff=0 fileindex=50 (bt_getnext.c@@/main/ase157x/asecarina/2 2012-10-31) lineno=2811
lock_do_logical shared row db=1 obj=3 pg=40 row=14 ctx=0x0 suff=0 pspid=29 fileindex=50 (bt_getnext.c@@/main/ase157x/asecarina/2 2012-10-31) lineno=2811 LOCK_GRANTED
lock_release shared row db=1 obj=3 pg=40 row=13 splk=0x3ae100 ctx=0x0 suff=0 fileindex=50 (bt_getnext.c@@/main/ase157x/asecarina/2 2012-10-31) lineno=2811
lock_do_logical shared row db=1 obj=3 pg=40 row=15 ctx=0x0 suff=0 pspid=29 fileindex=50 (bt_getnext.c@@/main/ase157x/asecarina/2 2012-10-31) lineno=2811 LOCK_GRANTED
lock_release shared row db=1 obj=3 pg=40 row=14 splk=0x3ae100 ctx=0x0 suff=0 fileindex=50 (bt_getnext.c@@/main/ase157x/asecarina/2 2012-10-31) lineno=2811
lock_do_logical shared row db=1 obj=3 pg=40 row=17 ctx=0x0 suff=0 pspid=29 fileindex=50 (bt_getnext.c@@/main/ase157x/asecarina/2 2012-10-31) lineno=2811 LOCK_GRANTED
lock_release shared row db=1 obj=3 pg=40 row=15 splk=0x3ae100 ctx=0x0 suff=0 fileindex=50 (bt_getnext.c@@/main/ase157x/asecarina/2 2012-10-31) lineno=2811
lock_do_logical shared row db=1 obj=3 pg=40 row=20 ctx=0x0 suff=0 pspid=29 fileindex=50 (bt_getnext.c@@/main/ase157x/asecarina/2 2012-10-31) lineno=2811 LOCK_GRANTED
lock_release shared row db=1 obj=3 pg=40 row=17 splk=0x3ae100 ctx=0x0 suff=0 fileindex=50 (bt_getnext.c@@/main/ase157x/asecarina/2 2012-10-31) lineno=2811
lock_do_logical shared row db=1 obj=3 pg=40 row=18 ctx=0x0 suff=0 pspid=29 fileindex=50 (bt_getnext.c@@/main/ase157x/asecarina/2 2012-10-31) lineno=2811 LOCK_GRANTED
lock_release shared row db=1 obj=3 pg=40 row=20 splk=0x3ae100 ctx=0x0 suff=0 fileindex=50 (bt_getnext.c@@/main/ase157x/asecarina/2 2012-10-31) lineno=2811
lock_do_logical shared row db=1 obj=3 pg=40 row=19 ctx=0x0 suff=0 pspid=29 fileindex=50 (bt_getnext.c@@/main/ase157x/asecarina/2 2012-10-31) lineno=2811 LOCK_GRANTED
lock_release shared row db=1 obj=3 pg=40 row=18 splk=0x3ae100 ctx=0x0 suff=0 fileindex=50 (bt_getnext.c@@/main/ase157x/asecarina/2 2012-10-31) lineno=2811
lock_do_logical shared row db=1 obj=3 pg=40 row=21 ctx=0x0 suff=0 pspid=29 fileindex=50 (bt_getnext.c@@/main/ase157x/asecarina/2 2012-10-31) lineno=2811 LOCK_GRANTED
lock_release shared row db=1 obj=3 pg=40 row=19 splk=0x3ae100 ctx=0x0 suff=0 fileindex=50 (bt_getnext.c@@/main/ase157x/asecarina/2 2012-10-31) lineno=2811
lock_do_logical shared row db=1 obj=3 pg=40 row=22 ctx=0x0 suff=0 pspid=29 fileindex=50 (bt_getnext.c@@/main/ase157x/asecarina/2 2012-10-31) lineno=2811 LOCK_GRANTED
lock_release shared row db=1 obj=3 pg=40 row=21 splk=0x3ae100 ctx=0x0 suff=0 fileindex=50 (bt_getnext.c@@/main/ase157x/asecarina/2 2012-10-31) lineno=2811
lock_do_logical shared row db=1 obj=3 pg=40 row=23 ctx=0x0 suff=0 pspid=29 fileindex=50 (bt_getnext.c@@/main/ase157x/asecarina/2 2012-10-31) lineno=2811 LOCK_GRANTED
lock_release shared row db=1 obj=3 pg=40 row=22 splk=0x3ae100 ctx=0x0 suff=0 fileindex=50 (bt_getnext.c@@/main/ase157x/asecarina/2 2012-10-31) lineno=2811
lock_do_logical shared row db=1 obj=3 pg=40 row=24 ctx=0x0 suff=0 pspid=29 fileindex=50 (bt_getnext.c@@/main/ase157x/asecarina/2 2012-10-31) lineno=2811 LOCK_GRANTED
lock_release shared row db=1 obj=3 pg=40 row=23 splk=0x3ae100 ctx=0x0 suff=0 fileindex=50 (bt_getnext.c@@/main/ase157x/asecarina/2 2012-10-31) lineno=2811
lock_do_logical shared row db=1 obj=3 pg=40 row=25 ctx=0x0 suff=0 pspid=29 fileindex=50 (bt_getnext.c@@/main/ase157x/asecarina/2 2012-10-31) lineno=2811 LOCK_GRANTED
lock_release shared row db=1 obj=3 pg=40 row=24 splk=0x3ae100 ctx=0x0 suff=0 fileindex=50 (bt_getnext.c@@/main/ase157x/asecarina/2 2012-10-31) lineno=2811
lock_release shared row db=1 obj=3 pg=40 row=25 splk=0x3ae100 ctx=0x0 suff=0 fileindex=50 (bt_getnext.c@@/main/ase157x/asecarina/2 2012-10-31) lineno=2811
lock_release shared intent db=1 obj=0 pg=3 row=0 splk=0x3ae0c0 ctx=0x0 suff=0 fileindex=696 (statapi.cpp@@/main/ase157x/asecarina/2 2013-06-16) lineno=713
lm_internal_ctxchain_release
shared intent obj=24 db=1 ctx=0x0 suff=0
lock_multiple shared intent db=1 obj=1 splk=0x3ae0c0 suff=0 fileindex=659 (seq_lock.c@@/main/ase157x/2 2011-11-28) lineno=1715 LOCK_GRANTED
lock_do_logical shared intent db=1 obj=21 pg=0 row=0 ctx=0x0 suff=0 pspid=29 fileindex=723 (sysattr.c@@/main/ase157x/asecarina/4 2013-06-04) lineno=214 LOCK_GRANTED
lock_release shared intent db=1 obj=0 pg=21 row=0 splk=0x3ae0c0 ctx=0x0 suff=0 fileindex=723 (sysattr.c@@/main/ase157x/asecarina/4 2013-06-04) lineno=214
lock_do_logical shared intent db=1 obj=1 pg=0 suff=0 pspid=29 fileindex=393 (lookup.c@@/main/ase157x/asecarina/18 2013-06-26) lineno=6744 LOCK_CACHED_NOTNEEDED
lock_do_logical shared row db=1 obj=1 pg=1 row=0 ctx=0x0 suff=0 pspid=29 fileindex=50 (bt_getnext.c@@/main/ase157x/asecarina/2 2012-10-31) lineno=2811 LOCK_GRANTED
lock_release shared row db=1 obj=1 pg=1 row=0 splk=0x3ae100 ctx=0x0 suff=0 fileindex=50 (bt_getnext.c@@/main/ase157x/asecarina/2 2012-10-31) lineno=2811
name
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------
sysprotects
lm_internal_ctxchain_release
shared intent obj=1 db=1 ctx=0x1 suff=0
(1 row affected)