| How to find the loading session [message #178391] |
Wed, 21 June 2006 00:02  |
akudba
Messages: 2
Registered: July 2005
|
Junior Member |
|
|
How do I find the session that is putting a high load on the database?
Yes, I can look at the top session by CPU, Memory or I/O and analyze the data from the performance overview but doing all that I still cannot pinpoint the loading session.
Looking at the server utilization as a basic measure, the ntilization varies inthe range of 20-70% on average. At times the utilization goes to 100% and stays there for minutes and sometimes fluctuates between 95-100%. I believe that some query etc runs during these times and causes these issues but so far I have been unable to find the query/session that is causing the high loading and purge it so that the other 400 users do not suffer and also once identified I can then tune it.
Will appreciate any help I can get.
Thx
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
