Statement used most recently

All SQL 2000 related.

SQL Trace:

sp_trace_create
sp_trace_setevent
sp_trace_setfilter
exec sp_trace_setstatus 1, 0
exec sp_trace_setstatus 1, 2
SELECT * FROM ::fn_trace_getinfo(default)

Check table size and index usage:
sp_spaceused(tblname)
dbcc showcontig()  with tableresults
(2005:sys.dm_db_index_physical_stats)
dbcc show_statistics('ppcprogressivemsgarchive','PK_PPCProgressiveMsgArchive')

Check resouce:
dbcc traceon(3604)
dbcc page(7,1,232323) for 7:1:232323


Processes:

select * from master..processes
sp_who2
dbcc inputbuffer(spid)