![]() |
Have you ever found yourself confused when setting up classification criteria for a new workload in Teradata? You’re not alone. This posting discusses the main principles at work when it comes to combining different classification criteria. It also provides some general tips to help you do effective, clean, predictable classification, whether on your workloads, your throttles or your filters.
12 Apr 2016
| 3 comments
,
|
![]() |
You may want to skip over this posting. Unless you’re curious about some of the more obscure workload classification conventions used by TASM and TIWM.
13 Nov 2015
| 3 comments
,
|
![]() |
As of Teradata Database 14.10.05 and 15.00.03, a simplified approach to determining which workload will support session management and parsing has been adopted This posting describes this more straightforward approach which will be used starting in these 14.10 and 15.0 releases, and going forward in all future releases. An earlier posting titled: “A Closer Look at How to Setup a Parsing-Only Workload” explains how session and parsing workload assignment takes place prior to this more simplified approach. If you are on an earlier release, please see that posting from December 2014.
19 Jan 2015
| 13 comments
,
|
![]() |
TASM gives customers the ability to manage Teradata resource usage and performance on platforms executing diverse types of work.
11 Dec 2014
,
|
![]() |
How to find the SLGs associated with workloads in Teradata Viewpoint?Is there any tdwm/system table that provides the same info?
23 Aug 2014
| 1 comment
,
|
![]() |
We are using TASM and Teradata 14.10 DB version.User is assigned to profile and profile is mapped to workload. A single profile can be mapped to more than one workload.Based on query creteria, it will get qualified to run in a
05 Aug 2014
| 3 comments
,
|
![]() |
We have TASM setup to demote user queries from USERS-SHORT to USERS-MEDIUM and then USERS-LONG, after some CPU seconds consumed threshold. We are seeing a number of queries get sent to our USERS_SHORT workload, only to be demoted to USERS_MEDIUM and then USERS_LONG.
23 Jan 2014
| 3 comments
,
|
![]() |
Workload Designer has been updated to make it easier to understand and configure how resources are assigned to workloads. TASM 14.0 onwards SLES 11 uses a new method of workload resource allocation that is intended to simplify the process conceptually and procedurally. This post describes the new workload resource allocation user interfaces and how they can be used to perform some basic resource allocation.
18 Sep 2013
| 2 comments
,
|
![]() |
We have implemented a 'Penalty Box' workload within TASM for queries that are demoted after reaching specific exception criteria with the idea that they go into a workload which has a low CPU allocation.
14 May 2013
| 2 comments
,
|
![]() |
Is there a way to record Production SQL queries and workloads so that they can be replayed in another environment?
09 Nov 2012
| 4 comments
,
|
![]() |
In our shop we have Teradata with DBQL & TASM implementation.
Yesterday I extracted some data from DBQL for analysis that consists queries performance metrics along with work load and final workload definition for the a user.
21 Mar 2012
| 5 comments
,
|
![]() |
If you are a TASM user, there is an option that springs up when you create a workload, labeled Enforcement Priority. The option name sounds a little more intimidating than it actually is.
23 Jan 2012
| 16 comments
,
|
![]() |
This session provides an overview and demonstration of the TASM portlets and TASM feature functionalities.
19 Aug 2010
,
|
![]() |
TDWM is working and TASM is enabled on the system. I can see WDID in the DBQLogTbl however the OpeEnvId and SysConId are null. How can this be possible?
10 Mar 2010
| 1 comment
,
|