You don't the fancy DMV's in SQL Server 2000 and Server side trace is your best friend to find out long running queries. I don't understand your comment on index time taken. Can you elaborate a bit on that? You can also use some information from sysprocesses and look at wait statistics.
commented on Apr 16 2011 10:25AM