Archives of the TeradataForum
Message Posted: Thu, 26 Mar 2015 @ 23:16:19 GMT
I generally don't like telling someone to read the manual, but in this case, an in depth look at the Teradata administration documentation will net you pretty thorough information on Teradata's canary query functionality as well as some general design considerations you might want to keep in mind when developing/deploying canary queries.
Fundamentally what you are asking breaks down into two questions. What metrics are meaningful for your environment and what thresholds have meaning.
Both of these questions require factoring intimate knowledge of both the surrounding technical infrastructure in which your system operates as well as the actual business value being derived from the activity performed on your system to come up with meaningful answers on many levels.
Bottom line you need to figure out what is important to measure for your particular environment, collect/store the relevant metrics for analysis, then perform the necessary analysis to derive meaningful information.
Some of those metrics are likely be generated by designing/deploying suitable canary queries of one type of another but will also very likely include other sources of data that can be collected and analyzed to help build different pictures or views of how your system accommodates the workload it is asked to support...With enough of those pictures you may be able to tell a meaningful story. The point here is that canary queries are part of a larger overall performance management methodology/approach that should guide you in making some of these choices...
|Copyright 2016 - All Rights Reserved|
|Last Modified: 24 Jul 2020|