Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 03 Apr 2015 @ 13:07:38 GMT

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

Subj:   Re: Canary Queries - TO Analyze System response
From:   Sravan.Bodla

Hi Forum,

On a day during an hour, In VIEWPOINT my SYSTEM RESPONSE (CANARY RESPONSE) time shows quite bad (almost 50K mill sec - 50 seconds).

For example, On 28th March, 6PM to 7PM, Average Canary response time reached to 10K ms and the max hit was 50K ms.

But, when I look at the CPU BUSY from dbc.resusageSpma, during that particular hour, the cpu busy percentage was just 33% which is quite normal.

Also, when checked in CAPACITY HEAT MAP portal for various parameters like (PE cpu usage, system cpu usage, user cpu usage etc., ) I don't see anything abnormal during that hour. Verified the same form DBQL as well.

What could be the reason for BAD CANARY RESPONSE?

Your assistance on this would be highly appreciated.



  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 24 Jul 2020