Archives of the TeradataForum
Message Posted: Mon, 26 Jul 2010 @ 09:56:59 GMT
| Subj: || || Combining Object Throttles (User/Profile) & Workload Query Limits |
| From: || || Anomy Anom |
<-- Anonymously Posted: Monday, July 26, 2010 12:17 -->
We are looking at limiting the number of queries a given workload definition can have. In addition, we want to ensure, that no one group/user
has the ability to saturate a given workload definition; thus the potential need for object throttles at the user/profile level as well.
It's understood that queries may be delayed twice, once at the object level, and again at the workload definition level. Does anyone have any
practical experience combining these two throttles? Any best practice advice is appreciated.