Diagnosing Performance Problem?

I have a database server that has is acting very sluggish. Using the performance monitor, I can see that disk use is steadily at 100% usage.

The system is so overburdened that attempting to do even basic tasks (open folders, look in Enterprise Manager, get screen repaints) has become impractical.

Even if I could get to the Enterprise Manager "Process Info" display, what would I look for to tell me what is wrong?From a remote PC, use Profiler to monitor all queries with over say 1000 reads. Copy those queries out to Query Analyzer, and see if you can get some indexes on the underlying tables to speed them up.

Another thing to check is how much memory is in the box? SQL Server will default to taking all it wants, but if you have only 64MB in your box, then you are in for a world-o-hurt.|||Originally posted by MCrowley
From a remote PC, use Profiler to monitor all queries with over say 1000 reads.

How do I do this? What is Profiler?

thanks for the feedback!|||Originally posted by RogerWilco
How do I do this? What is Profiler?

thanks for the feedback!

Found it. This is definitely helping.

Thankfully, we just hired a real DBA who starts Thursday.

Thanks again!