find database the use most cpu in a given time 
Author Message
 find database the use most cpu in a given time

I have a db2 server with several databases on a NT server.
I regulary monitor cpu activity of this server.

Windows NT Task manager give me the process that use most of the cpu,
but id'like to know which database use the cpu

I do not want to monitor each database to find the good one.

is there an easy way to find it ?

I tried perfmon but didnt find a good counter.

Any help appreciated


Tue, 10 Aug 2004 01:43:34 GMT
 [ 1 post ] 

 Relevant Pages 

1. Find out what statement uses the cpu?

2. extproc using too much CPU time

3. SQL Server 4.21a uses almost 100% CPU time

4. select varchar uses incredible amount of CPU time ?

5. Using CONVERT for datetime with a time NULL gives error

6. Count of queries in a given time using the profiler 20000

7. Find all objects in all databases owned by a given user

8. cpu time VS. elapsed time

9. how to find if any users are connected to a given database

10. tkprof cpu time > elapsed time

11. Elpased Time < CPU Time

12. Adjust server time to local time for given location ( Timezone )

Powered by phpBB® Forum Software