how to tell resources used by individual databases

I'm running SQL Server 2000 on Windows 2003. There are many databases
on this server and sometimes the processors are running very high
where sqlserver.exe is the process doing it. How can I tell the
resources used by each database at a given point in time?
Hi
Run SQL Profiler to see what queries are being executed and thier
statistics. This gives you a good idea as to what is causing your high
utilization.
Regards
Mike
"Joe" wrote:

> I'm running SQL Server 2000 on Windows 2003. There are many databases
> on this server and sometimes the processors are running very high
> where sqlserver.exe is the process doing it. How can I tell the
> resources used by each database at a given point in time?
>
sql