Board index » DB2
All times are UTC
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
Antony
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 )
find database the use most cpu in a given time