Archives of the TeradataForum
Message Posted: Thu, 06 Dec 2001 @ 12:59:57 GMT
| Subj: || || Teradata Priorities |
| From: || || Tony Howe |
I have a resource/CPU usage question and just how does Teradata allocate it as to who gets how much and how can one query suck up all or
a lot of resources when every USER logging on has the same priority?? I other words, all of the USER on our system are given a priority of
$M. So to me that means they all should get equal time and resources to run their queries, but occasionally it appears that one user gets
in there with a big/intensive query and appears to be the only one getting any time and resources. As soon as I dynamically change his
priority to $L, then the other queries out there take off and running.
The weight for the four default priorities are $L = 5, $M= 10, $H = 20 and $R = 40, I haven't change any of these settings since the
server was brought in. I am looking at this Priority Scheduler stuff that everyone talks about because I am about to add a second
application to our 5250 and each application is worried about the other not fairly sharing the system. But if everyone has a $M priority
why doesn't everyone get equal time/resources? Why do I have to even think about using this complicated Priority Scheduler stuff??? I'm
not getting it???