When i look i promon R&D, Activity: Performance Indicators, i see a high number of resource waits (it can be something like 378 over 10 sec). Does anyone have any suggestions about how i can find out whats waiting for resources and what resources it's waiting for?
Thanks,
Viktor
Take a look at ProTop:
http://www.greenfieldtech.com/articles/protop.shtml
It has a nice interactive resources waits screen (among many others).
Ok, I'll check it out.
Thanks
As Tom says, protop will be useful in finding out what is going on. However, this isn't really a very high value for resource waits and probably isn't causing problems. It is 38 per second, spread amongst all the users. If you have 10 users, it averages out to one wait every 264 milliseconds. Still, because that is an average it might be a problem if the durations are long enough or if all the waits happen for just a couple of users.
-gus