0 - 5 of 5 tags for threshold

This session focuses on statistics enhancements in Teradata Database 14.10, particularly the new threshold functionality, skipping statistics, and downgrade to sampling.

In the System Health Portal, the System is showing in degraded mode.On cliking the icon, I can see the different Health metrics.One of them is AWT usage , which is showing in red.How do I check what is the threshold value for AWT  utilization,exceeding which the system goes to degraded state in the Viewpoint portel?

An earlier blog post focused on simple steps to get started using the Teradata 14.10 Automated Statistics Management (AutoStats) feature.  One of the new capabilities that AutoStats relies on when it streamlines statistics collection is the new “Threshold” option.  Threshold applies some intelligence about when statistics actually need to be re-collected, allowing the optimizer to skip some recollections.  

Although you will probably want to begin relying on AutoStats when you get to 14.10, you don’t have to be using AutoStats to take advantage of threshold, as the two features are independent from one another.  This post will give you a simple explanation of what the threshold feature is, what default threshold activity you can expect when you get on 14.10, and what the options having to do with threshold do for you.  And you’ll get some suggestions on how you can get acquainted with threshold a step at a time.  

On Viewpoint Query Monitor's Top Sessions Graph of the Summary view, two metrics are represented:  one by the length of the bar and the other by the color or shading of the bar.  The user chooses a metric left of the graph.  How is that metric displayed (length of bar or color/shading)?  What is the other metric?

As the Product Manager for Viewpoint, I have the distinct pleasure of discussing, presenting, and demonstrating the extensive feature content to account teams, partners, and customers. My thanks goes out to the Viewpoint Engineering team in providing lots for me to talk about ... And learn.