|
-
Does the query use the same plan before and after you experience the slowdown? If not, maybe your data skews your stats to the point where it changes your plan. (Although I don't think a re-start would fix the problem if that was the case)
If so, it almost sounds like your db_block_buffers is too small...
What does statspack say?
(sounds like your server is more like 5x7 than 24x7)
Last edited by marist89; 12-07-2002 at 12:34 PM.
Jeff Hunter
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote