|
Last month I talked about things that don’t honor a CPU limit, and explained what a CPU limit is. This month I’d like to look at CPU limits from a slightly different perspective—What happens when you define CPU limits at multiple levels? For example, you may already have a system level CPU limit on your platform, but now you’d like to use CPU limits on one or two of your resource partitions (RP) as well. Yes, you can do this. Read along with me while I explain to you what you can expect.
,
15 Mar 2010
|
|
|
This workshop provides an overview of Teradata's technology strategy.
,
19 Feb 2010
|
|
|
|
Data Warehouses often contain data in effect for a time period, denoted by Start and End dates within a row. With time-period data comes a set of frequently asked business questions. For example, of home, auto, and life insurance policies, for what ranges of time have my customers 1) had zero policies active, or 2) at least one active, or 3) multiple active? Solutions to business questions of this type are not obvious using SQL. However, this session will show how to solve this class of problems efficiently with SQL instead of using stored procedures or exporting to another tool. See unique ways to apply correlated subqueries and the Ordered Analytical Functions SUM(), ROW_NUMBER(), and MIN() to this class of problems.
,
08 Feb 2010
|
|
|
|
Over the past several releases Teradata has invested in features to support extending the database to enable Teradata’s parallel infrastructure to be applied to a broader problem space. This session will review the goals and drivers of this initiative. Included will be comparison to emerging parallel application frameworks. The session will highlight several successful production features and applications. An overview will be provided of the components comprising the extensibility framework with some insight into future directions. The session will conclude with some common implementation and management considerations and techniques.
,
08 Feb 2010
|
|
|
|
Maybe you want to ensure that your sandbox applications never use more than 2% of the total platform CPU. No problem! Put a CPU limit of 2% on them. Or maybe you’ve got some resource-intensive background work you want to ensure stays in the background. CPU limits are there for you. But if you plan to use CPU limits as part of your workload management scheme, be aware that there are some database operations that simply won’t obey the limits. So let’s take a look at what those special cases are and why they’re allowed to violate the rules.
,
04 Feb 2010
| 5 comments
|
|
|
|
Looking for an extra level of protection around your online, web, or interactive queries? Think about expediting the priority scheduler allocation group that they run in. In the past, expediting priority scheduler allocation groups that support tactical queries was one way to prevent out-of-AMP worker task conditions from slowing down those response-sensitive queries. But even if you never run out of AWTs, there are some less obvious reasons why expediting those allocation groups is a good, proactive idea.
,
04 Jan 2010
| 3 comments
|
|
|
|
This course was designed for Data Analysts and Business Users of the Teradata Data Warehouse. It covers data distribution, access, storage and Teradata terminology and how to use the Teradata Utility SQL Assistant to submit Structured Query Language (SQL) statements. This course offers practical, hands-on experience with retrieving and manipulating data with Teradata SQL using both ANSI standard conventions and Teradata extensions to the language.
,
21 Dec 2009
|
|
|
|
Offers training in advanced features & techniques used for retrieving & manipulating data with Teradata Structured Query Language (SQL) using both ANSI standard conventions & Teradata extensions to the language.
,
21 Dec 2009
|
|
|
|
Offers practical, hands-on experience with retrieving & manipulating data with Teradata Structured Query Language (SQL) using both ANSI standard conventions & Teradata extensions.
,
21 Dec 2009
|
|
|
|
Provides an overview of the Teradata Database architecture, as well as the features and benefits of the product. Teradata data distribution, access, storage and data protection methods are described. The suite of complementary load, access, and management utilities and tools are also covered, as well as Teradata Terminology.
,
21 Dec 2009
|
|
Tags |
|
1 - 10 of 20 tags for database
|