-
Hello,
I am having really bad performance problems in my database. At times the tellers are waiting up to a minute for a page to turn. In looking at waits I observed the following output:
Total Total Time Avg
Waits Timeouts Waited % of Wait
Event Name (in 1000s) (in 1000s) (in Hours) Concern (Secs)
-------------------------- ----------- ----------- ----------- ------- -------
parallel query dequeue wait 1,756.12 1,756.09 980.53 87.97 2.01
This was the top wait event by far. What does this event mean? My largest table in the database has a degree of 4 for paraellel query. Thank you!!
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
|