Ask - performance on sql server 2000

Getting Started with Adobe After Effects - Part 6: Motion Blur


	Ask

Ask questions, discuss or help others by answering


	Ask a question


	Subscribe..

performance on sql server 2000

Apr 15 2011 12:00AM by mohammad

Hi Experts,

How to check the performance on Sql server 2000 and how to see the time taken to long running queries as we are see in the Sql server 2008 with the DMV's, and also how to see the index time taken in the Sql server 2000 please help me regarding this.

Thanks & Regards, Mohammad.Abid

Submitted under: Microsoft SQL Server · SQL Server 2000 · TSQL · ·

Previous: Delimited Data to Multiple COlumns
Next: Credentials can not be found

mohammad

260 · 1% · 168

1 Replies

Mohammad,

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.

http://support.microsoft.com/kb/822101

--Sankar Reddy

commented on Apr 16 2011 10:25AM

Sankar

113 · 1% · 454

Your Reply

Sign Up or Login to post a comment.