Archives of the TeradataForum
Message Posted: Fri, 23 Jul 2004 @ 14:20:21 GMT
| Subj: || || What would cause explains to slow down? |
| From: || || Anomy Anom |
<-- Anonymously Posted: Friday, July 23, 2004 10:19 -->
Hope this is not considered a RTFM question because I have not seen this addressed there. My question is: Even when our system is busy
usually an explain or help stats takes only a second or two....lately during peak times I have explains taking up to one minute and help stats
that long or longer. What bottleneck would this represent? CPU? AWT's? Memory? I'm just not sure...but knowing this may be helpful in
understanding issues that our system may have.
We are on v2r5.1. Thanks in advance.