Archives of the TeradataForum

Message Posted: Wed, 02 Sep 2009 @ 14:23:40 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

<-- Anonymously Posted: Wednesday, September 02, 2009 10:13 -->

1 How do we know that a query got demoted due to query miles stones? i mean if it gets demoted to next allocation group with lower priority, is there any place it stores this info other than the totalcputime in dbqlogtbl? I need to keep track of how many quesries getting demoted due to query milestones.

2) Is weight assigned to allocation group in Priority scheduler impacts the IO allocation also?

3) what exactly schmonnode table will contain?

Thanks

	<Prev	Next>		<<First	<Prev	Next>	Last>>