I am having some performance problems sporadicallly on my database.
The only indicators of problems activated by Quest Spotlight are latch waits and lock waits.
So far I have read that the real solution for this is to re-use sql code more effectively, but I need to find a solution as fast as possible. Changing the applicaion will take a lot of time and money.
Below is the line of statistics for the library cache:
Latch name Latches Gets/s % gets Sleeps/s % sleeps Sleep rate
library cache 54 2,887.29 27.53 1.20 100.00 0.04
Misses/s % misses Miss rate
1.53 88.46 0.05