Home Page Icon
Home Page
Table of Contents for
Back Cover
Close
Back Cover
by Tom Coffing, Carling Nolan
Teradata Database Administration – TASM and Viewpoint
Cover Page
Title Page
Copyright Page
About Tom Coffing
About Carling Nolan
Contents
Chapter 1 - Viewpoint
Database Administration (DBA) on Teradata
Viewpoint
Logging into Viewpoint
The First Time you Login to Viewpoint
The Add Content Menu for Monitoring
The Add Content Menu for TASM
The Add Content Menu for Tools
The Add Content Menu for Trend Reporting
Adding your First Content
How the Page Looks after you Add your First Content
Adding Additional Pages
The Fundamentals of Viewpoint Pages and Portals
Adding Multiple Portals to a Single Page
All Portals to their Individual Tab
Portlet Controls
The Rewind Control
Query Monitor Overview
Query Monitor Details View
Query Monitor Actions
My Queries
Calendar
Calendar Details
Add an Event to the Calendar
Getting a Weekly View
System Health
System Health Drilldown
System Health Preferences
ALERT
Setting up an ALERT Configuration
Setting up an ALERT Configuration Continued
SQL Scratchpad
SQL Scratchpad Query Results
SQL Scratchpad Object Loader
Space Usage
Space Usage Preferences
Investigating Space to See Dynamic Reports
Space by Vproc (AMP)
How to Obtain a Detailed View of Space
Detailed View of Space
Adding PERM Space to a Database or User
External Content
Lock Viewer
Lock Viewer Lets you Configure your View
Canary Queries
Multiple Systems Need Multiple Canary Query Portlets
What Canary Queries Measure
Remote Console
Capacity Heatmap
Capacity Heatmap Preferences
Capacity Heatmap Example
Metrics Analysis
My Queries
My Queries Preferences
Today's Statistics Using System Metrics
Today's Statistics Using Query Metrics
Today's Statistics Using Performance Metrics
Today's Statistics Preferences for System Metrics
Today's Statistics Preferences for Query Metrics
Today's Statistics Preferences for Performance Metrics
Today's Statistics Preferences for Sampling Intervals
Chapter 2 - TASM
Three Levels of Workload Management
Pre-execution, Query Execution, and Post-execution
What is TASM?
Query Management Compared to Workload Management
What is the Secret Sauce for Query Management?
The Life of a Query
What is a Workload?
Workload Examples
There are Four Types of Query Rules
Common Sense Examples of Filters and Throttles
Performance Period Examples
The Scoop on Object Throttles
Load Utility Throttles
Creating Workloads
When Creating Workloads the “who” is your Foundation
After the “who” Comes the “where”
After the “who” and the “where” Comes the “what”
Exception Actions
When and How Teradata Checks for Exceptions
DBC.TDWMExceptionLog
Teradata Workload Analyzer
Teradata Workload Analyzer
Pre-execution, Query Execution, and Post-execution
Why Use Priority Scheduler?
The Concept of a Resource Partition
Resource Partitions
The Clever Idea behind Resource Partitioning
The Brilliant Idea behind Resource Partitioning
The Concept of Resource Partitions and Weights?
The Concept of a Workload in a Resource Partition
Calculating your CPU Percentage 1
Answers to Calculating your CPU Percentage 1
Calculating your CPU Percentage 2
Answers to Calculating your CPU Percentage 2
Calculating your CPU Percentage 3
Answers to Calculating your CPU Percentage 3
Calculating your CPU Percentage 4
Answers to Calculating your CPU Percentage 4
Calculating your CPU Percentage 5
Answers to Calculating your CPU Percentage 5
Calculating your CPU Percentage 6
Answers to Calculating your CPU Percentage 6
Calculating your CPU Percentage 7
Answers to Calculating your CPU Percentage 7
Calculating your CPU Percentage 8
Answers to Calculating your CPU Percentage 8
Calculating your CPU Percentage 9
Answers to Calculating your CPU Percentage 9
Calculating your CPU Percentage 10
Answers to Calculating your CPU Percentage 10
Calculating your CPU Percentage 11
Answers to Calculating your CPU Percentage 11
Calculating your CPU Percentage 12
Answers to Calculating your CPU Percentage 12
Calculating your CPU Percentage 13
Answers to Calculating your CPU Percentage 13
Chapter 3 – Designing and Implementing Workloads
How to Configure Priority Scheduler
Workload Designer
The Three Areas of the Workload Designer
How the Area of Workload Designer are Used
How to Create a Ruleset
The First Step to Creating a Ruleset
Returning to the Workload Designer Main Screen
A Basic Ruleset in the Working Area
Editing a Ruleset
The States
States – Adding Another Planned Environment
Editing the Name of the NewEnv Planned Environment
Changing the Planned Environment Name to a Good Name
Adding a New State
A New State is Born
Editing the Default State Name of newState
We Now have a New State named DayState
Drag a State (DayState) to a Planned Environment (WorkDay)
Drag a State (DayState) to a Planned Environment (WorkDay)
Do not Forget to Hit Save
We Now Need to Create a Planned Event
Create a Planned Event to Define the Timeframes
The Planned Event Screen
Your Event is Now in the Available Events Tab
Drag and Drop your Event to your Planned Environment
You have a Timeframe for the Planned Environment DayState
Creating a Degraded Condition with our Normal Condition
Creating a Degraded Condition with our Normal Condition
Editing your New Condition to Become a Degraded Condition
Edit Health Conditions Screen
Our New Edited Health Condition Named Degraded
We Now have a New Degraded Condition
Don't Forget to Now Hit the Save Button
Let's Define our Degraded Health when CPU hits 100%
The Available Events Screen
The Create Event Screen
The Available Events Screen Now Shows our Event
After we Drag and Drop the Event into the Degraded Events
Drag the Base State to the Degraded/Always Environment
Our Default of BASE is Set in the Degraded Environment
Let's Create a New State for our Degraded Workday
Let's Create a New State for our Degraded Workday
Let's Create a New State for our Degraded Workday
Drag the New state DayDegraded to our Planned Environment
Hit Save to Keep your Changes
Limiting the Sessions
When you First Come to the Sessions Screen
Query Session Limit – The General Tab
Creating a Session Limit for the WorkDay when DayDegraded
Creating a Session Limit for the WorkDay when DayDegraded
A Successful Creation of a Session Limit on DayDegraded
Creating Filters
When you First Come to the Filters Screen
Creating a New Filter – The General Tab
Creating a New Filter – The Classification Tab
Edit Query Characteristics Criteria
Creating a New Filter – The General Tab
Edit the Filter for the WorkDay when DayDegraded
Creating a New Filter – The Classification Tab
Utilizing Throttles
Throttles – The Throttles Tab
Throttles – New Throttles Tab
Throttles – New Throttles Tab
Edit the Throttle for the WorkDay when DayDegraded
Throttles – New Throttles Tab
Throttles – The Throttles Tab
Let's Go Back and Activate our Rule Set
To Prepare for Activation, Move the Ruleset to the Ready
The Ruleset is in the Ready and Now we can Activate
The Ruleset is in the Ready and Now we can Activate
When you First Come to the Workloads Screen
Workloads – New Workload General Tab
Workloads – New Workload Classification Tab
Edit the Request Source Criteria
Workloads – New Workload Classification Tab
Workloads – Throttles in a Workload
Edit the DayDegraded Settings
Workloads – Throttles are Now Set for the State DayDegraded
Workloads – Service Level Goals
Service Level Goals for the WorkDay
Workloads – Service Level Goals
Workloads – Exceptions
Workloads – The Exceptions Screen
Workloads – The New Exceptions Screen
Chapter 4 – Top SQL Commands Cheat Sheet
Select All Columns from a Table and Sort
Select Specific Columns and Limiting the Rows
Changing your Default Database
Keywords that Describe you
Select Top Rows in a Rank Order
A Sample Number of Rows
Getting a Sample Percentage of Rows
Find Information about a Database
Find Information about a Table
Using Aggregates
Performing a Join
Performing a Join using ANSI Syntax
Using Date, Time and Timestamp
Using Date Functions
Using the System Calendar
Using the System Calendar in a Query
Formatting Data
Using Rank
Using a Derived Table
Using a Subquery
Correlated Subquery
Using Substring
Basic CASE Statement
Advanced CASE Statement
Using an Access Lock in your SQL
Collect Statistics
Creating a Volatile Table with a Primary Index
Creating a Volatile Table that is Partitioned (PPI)
Creating a Volatile Table that is Deleted after the Query
Finding the Typical Rows per Value for Specific Column
Finding out how much Space you have
How much Space you have Per AMP
Finding your Space
Finding Space Skew in Tables in a Database
Finding the Number of Rows per AMP for a Column
Finding Account Information
Ordered Analytics
Back Cover
Search in book...
Toggle Font Controls
Playlists
Add To
Create new playlist
Name your new playlist
Playlist description (optional)
Cancel
Create playlist
Sign In
Email address
Password
Forgot Password?
Create account
Login
or
Continue with Facebook
Continue with Google
Sign Up
Full Name
Email address
Confirm Email Address
Password
Login
Create account
or
Continue with Facebook
Continue with Google
Prev
Previous Chapter
Chapter 4 – Top SQL Commands Cheat Sheet
Add Highlight
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click
here
login for view all page.
Day Mode
Cloud Mode
Night Mode
Reset