About Carling Nolan
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
About Carling Nolan
Carling Nolan is a professional golfer who has played on the LPGA, Symetra Tour, and the Ladies European Tour. Carling played collegiate golf at The Ohio State University where she earned her BA in communications. She currently hosts the Fox Sports television series “Tee it up” where she has co-starred with Jimmy Hanlin for the past two years. In 2010, Carling participated on Golf Channel's TV series “The Big Break” where she took home the title.
Carling has extensive experience in television, film, editing, producing, and directing. In college, she was the lead journalist for CoachTressel.Com where she wrote articles and produced video for the Ohio State Football team.
Carling is responsible for the editing of CoffingDW books, website promotions, and she currently heads the video team where she produces CoffingDW videos.
Carling is a Cincinnati, OH native where she currently resides with her husband, John.
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.