SQL Server查询数据性能

Select * from sysprocesses where  blocked<>0 exec sp_lock  Status = 'WAIT';select object_name(882102183) KEY: 5:72057594048675840 (5a029f2c1da5) 288   select * from dbo.sysobjects where id = '298'    dbcc inputbuffer(295);      set transaction isolation level  read committed  set implicit_transactions off ;select * from plan_three_four_zero;