Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
misterraj
Yak Posting Veteran
94 Posts |
 Posted - 2010-08-02 : 01:10:33
|
| when i query in enterprise Mgr:select * from tablenameIt executs and executes, may be its locked.how to find out which process is holding it?thanks,Venkat. |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2010-08-02 : 01:25:01
|
sp_lock
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
misterraj
Yak Posting Veteran
94 Posts |
Posted - 2010-08-02 : 01:35:46
|
| sp_lock gives me some set of records, it gives me 85 records.how would i know which process is holding it?any particular query to filter out?/ how to decode the output of sp_lockthis is the output:spid dbid ObjId IndId Type Resource Mode Status51 4 0 0 DB S GRANT53 11 0 0 DB S GRANT54 17 0 0 DB S GRANT55 9 0 0 DB S GRANT56 7 0 0 DB S GRANT57 19 0 0 DB S GRANT58 13 0 0 DB S GRANT60 17 0 0 DB S GRANT61 17 0 0 DB S GRANT62 19 0 0 DB S GRANT63 13 0 0 DB S GRANT65 4 0 0 DB S GRANT66 17 0 0 DB S GRANT67 1 1115151018 0 TAB IS GRANT68 18 0 0 DB S GRANT68 18 0 0 APP 0:[ENVIRONNEXTTST_B]:(e4baf684) X GRANT69 18 0 0 DB S GRANT70 18 0 0 DB S GRANT70 18 0 0 APP 0:[ENVIRONNEXTTST_B]:(a58bed9d) X GRANT71 18 0 0 DB S GRANT72 18 0 0 DB S GRANT73 19 0 0 DB S GRANT73 19 0 0 APP 0:[TDDS_Session_Reg]:(5ef8e0fd) S GRANT74 19 0 0 APP 0:[TDDS_Session_Reg]:(5ef8e0fd) S GRANT74 19 0 0 DB S GRANT76 18 0 0 DB S GRANT77 19 0 0 DB S GRANT77 19 0 0 APP 0:[TDDS_Session_Reg]:(5ef8e0fd) S GRANT78 18 0 0 DB S GRANT79 19 0 0 DB S GRANT79 19 0 0 APP 0:[TDDS_Session_Reg]:(5ef8e0fd) S GRANT80 18 0 0 DB S GRANT81 19 0 0 DB S GRANT81 19 0 0 APP 0:[TDDS_Session_Reg]:(5ef8e0fd) S GRANT82 18 0 0 DB S GRANT83 16 0 0 DB S GRANT84 19 0 0 DB S GRANT84 19 0 0 APP 0:[TDDS_Session_Reg]:(5ef8e0fd) S GRANT85 19 0 0 APP 0:[ManageMessageRef]:(28c8c5ab) X GRANT85 19 0 0 DB S GRANT86 18 0 0 DB S GRANT87 19 0 0 DB S GRANT87 19 0 0 APP 0:[TDDS_Session_Reg]:(5ef8e0fd) S GRANT88 19 0 0 APP 0:[TDDS_Session_Reg]:(5ef8e0fd) S GRANT88 19 0 0 DB S GRANT89 19 0 0 DB S GRANT93 12 0 0 DB S GRANT94 13 0 0 DB S GRANT97 14 0 0 DB S GRANT98 14 0 0 DB S GRANT100 13 0 0 DB S GRANT101 13 0 0 DB S GRANT102 11 661577395 4 KEY (9e02b364b336) X GRANT102 11 357576312 0 TAB IX GRANT102 11 0 0 DB S GRANT102 11 661577395 4 PAG 1:100324 IX GRANT102 11 357576312 0 PAG 1:172363 IX GRANT102 11 661577395 0 PAG 1:87631 IX GRANT102 11 661577395 0 RID 1:87631:0 X GRANT102 11 661577395 3 KEY (4002e1fa4ac3) X GRANT102 11 661577395 0 RID 1:272598:0 X GRANT102 11 661577395 0 PAG 1:272598 IX GRANT102 11 357576312 5 PAG 1:277305 IX GRANT102 11 357576312 5 PAG 1:277304 IX GRANT102 11 661577395 0 RID 1:87631:3 X GRANT102 11 661577395 0 PAG 1:277427 X GRANT102 11 357576312 2 PAG 1:277408 IX GRANT102 11 357576312 3 PAG 1:127303 IX GRANT102 11 661577395 2 KEY (0c02dffc852b) X GRANT102 11 357576312 0 RID 1:172363:30 X GRANT102 11 357576312 4 KEY (4d00d13aa805) X GRANT102 11 661577395 0 TAB IX GRANT102 11 661577395 3 PAG 1:47752 IX GRANT102 11 357576312 4 PAG 1:175621 IX GRANT102 11 357576312 3 KEY (b50122285968) X GRANT102 11 357576312 5 KEY (9f02d7f78df1) X GRANT102 11 357576312 2 KEY (81011c2e9680) X GRANT102 11 661577395 2 PAG 1:97740 IX GRANT103 7 0 0 DB S GRANT105 13 0 0 DB S GRANT110 9 0 0 DB S GRANT112 9 0 0 DB S GRANT209 7 0 0 DB S GRANT244 11 0 0 DB S GRANT251 10 0 0 DB S GRANT271 11 0 0 DB S GRANT |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
|
misterraj
Yak Posting Veteran
94 Posts |
Posted - 2010-08-02 : 01:58:47
|
| There is no mention about the table on which process is holding to. I get the database information, but can it be funneled to 'table information' ? |
|
|
|
|
|
|
Executing query