Books
in black and white
Main menu
Share a book About us Home
Books
Biology Business Chemistry Computers Culture Economics Fiction Games Guide History Management Mathematical Medicine Mental Fitnes Physics Psychology Scince Sport Technics
Ads

Teradata RDBMS Database Administration - NCR

NCR Teradata RDBMS Database Administration - NCR , 2004. - 616 p.
Download (direct link): teradatadatabaseadmin2004.pdf
Previous << 1 .. 169 170 171 172 173 174 < 175 > 176 177 178 179 180 181 .. 218 >> Next


Managing I/O with Cylinder Read

This Cylinder Read field .

Reports the

Svpr_FileFcrDeniedCache

number of times that a cylinder read request was denied because a cylinder slot was not available at the time of the cylinder read request.

(The sum of Svpr_FileFcrDeniedThresh and Svpr_FileFcrDeniedCache yields the total number of rejected cylinder read requests.)

Svpr_FileFcrBlocksRead

total number of data blocks that were loaded with cylinder reads.

Svpr_FileFcrBlocksDeniedThresh

total number of data blocks that were not loaded with cylinder reads because the cylinder read requests did not meet the threshold criteria (linked to FileFcrDeniedThresh).

Svpr_FileFcrBlocksDeniedCache

total number of data blocks that were not loaded with cylinder reads because the cylinder read requests were submitted at times when cylinder slots were not available (linked to FileFcrDeniedCache).

15 - 2

Teradata RDBMS Database Administration Chapter 15: Tools for Managing Resources

Managing Resources with Priority Scheduler

Managing Resources with Priority Scheduler

Every session logs on to Teradata RDBMS with a certain priority, which then is inherited by all transactions originating from that session. This priority dictates how much CPU resource and processing time can be allocated to each query, thus effectively controlling query completion time.

Prioritization is active in all Teradata systems at all times. Teradata RDBMS itself automatically moves internal jobs into different priority levels, especially when a quick boost to one activity is critical to overall throughput.

Priority Scheduler is a resource management facility that controls system resource allocations based on a blueprint that you construct to satisfy your site-specific requirements.

With Priority Scheduler, you can define a prioritized system scheduling strategy that allows you to:

Balance resource usage by groups of sessions and utilities

Authorize users for access to prioritized levels of service based on the priority information carried in the user account string

Dynamically alter the priority of a user or (with profiles) user group

Regulate access to AMP worker tasks (AWTs)

Dynamically modify parameters that define your scheduling strategy, plus:

Record these parameters as profiles

Automatically change the profiles at scheduled times

Set CPU usage limits at a variety of levels

The parameters available for defining your scheduling strategy include:

A prioritized weighting system

A set of scheduling policies

Values for adjusting those weights and policies, based on:

Resource consumption by query or by session

Time of day

These capabilities allow you to control your workload flow.

Implementation Utilities and Tools

Depending on the functions you want to perform, the utilities, tools, and information sources for implementing Priority Scheduler include:.

15 - 10 Teradata RDBMS Database Administration

Chapter 15: Tools for Managing Resources

Managing Resources with Priority Scheduler

IF you want to . THEN use . For more information, see ...
establish and modify Resource Partitions, Performance Groups, Performance Periods, and other scheduler parameters one of the following: schmon command-line utility xschmon GUI utility (on UNIX) Priority Scheduler Administrator (PSA) facility of Teradata Manager In Teradata RDBMS Utilities: - "Priority Scheduler" - "schmon Utility" (Windows 2000) - "xchmon Utility" (UNIX) man page for xschmon (UNIX) "Priority Scheduler Administrator (PSA)" on page 15-11 "Priority Scheduler Administrator (PSA)" in Teradata Manager User Guide
Easily define the Priority Scheduler profile parameters Generate schmon scripts to implement the profiles. the PSA facility.
analyze various weighting systems offline with a spreadsheet application the Priority Scheduler Simulator (pss.xls) on a Windows 2000 platform.
assign users to Performance Groups CREATE/MODIFY USER and/or CREATE MODIFY PROFILE statements "CREATE USER Statement" on page 5-3 "Implementing Profiles" on page 5-17 "Defining Accounts" on page 5-20 Teradata RDBMS SQL Reference, Volume 4
control query processing based on account priority One of the various facilities to dynamically raise or lower the priority of an active session Teradata Dynamic Query Manager (TDQM) facility, to restrict unqualifying queries and set up rules of submission for qualifying queries "Changing the Performance Group of a Running Job" on page 5-23 "Scheduling Workloads with Teradata Dynamic Query Manager (TDQM)" on page 15-12
collect performance data for near-real-time monitoring of your scheduling strategy Performance Monitor API MONITOR requests Teradata Performance Monitor "PM/API Dynamic Data" on page D-6 "Teradata Performance Monitor" on page D-8

15 - 10

Teradata RDBMS Database Administration Chapter 15: Tools for Managing Resources
Previous << 1 .. 169 170 171 172 173 174 < 175 > 176 177 178 179 180 181 .. 218 >> Next