Workload management in a multi-client data warehouse

Viewpoint
Teradata Employee

Workload management in a multi-client data warehouse

Hi,

In a multi-client data warehouse the clients insist on ensuring the percentage of CPU granted to them.

Put it simply: Client A has e.g. 60% CPU and Client B 40%.

Each client should have 2 WDs defined: one for tactical, one for non-tactical.

What is the best way to do this with viewpoint V14.00/SLES10?

How to divide tactical resource partition e.g. into 2 parts: one (60%) for client A, one (40%) for client B?

4 REPLIES
Enthusiast

Re: Workload management in a multi-client data warehouse

Unless you go to SLS 11 there is no absolute priority. Meaning a bad SQL running on PBOX can consume more than what it should have in 30 seconds interval. its all relative. You should try with Two Tatical AG with Higher one has altleast 8 times Relative weight then the lower but again its all relative.For absolute Fare share priorities you will have to go with TD 14 and SLS 11

HTH

Thanks

Abhijit

Teradata Employee

Re: Workload management in a multi-client data warehouse

"Guaranteed" resource percentages are challenging in really any situation for a number of reasons. As mentioned, a main theme of Teradata workload management strategies is "relative" percentages as the architecture constantly adjusts based on the percentages in plan, the constant change in the amount of work, as well as diversity of work on the system. There is also system overhead that needs to be considered. Hard limits can be considered but  should have a justified reason for doing so as this can leave unused resources on the table. The SLES11 implementation with Virtual Partitions may be considered but hard limits on those won't be available right away. I'd suggest getting with the associated Teradata PS group that has excellent implementation experience to review your needs and suggest how best to accomplish what you are after now and potentially in the future. 

Teradata Employee

Re: Workload management in a multi-client data warehouse

thanks for all replies!

is the issue relative percentage in TD workload management being clarified in more detail somewhere (orange books,...)

Teradata Employee

Re: Workload management in a multi-client data warehouse

TASM or Priority Scheduler documentation / orange books explain how prioritization of work on the system will be managed. It is important to get the right documentation based on the Teradata DB version and operating system release (SLES10 / SLES11).