Tperf calculation for my system

Database
Enthusiast

Tperf calculation for my system

Hi,

Good morning.

We have a 5650H system for which I want tyo understanf onm how to calculate the TPERF value.

Browsing over all the posts, I came to know that we can calculate the TPERF using the below query

When calculated, I got a value of 18k but as per my understanding having 5100M as 1.0 , I thought I would be getting some value ranging from 1-100.

Kindly do correct if there were any mistakes in the query

LOCK ROW FOR ACCESS
SEL MAX(TPERF)/1000 FROM (
SELECT
THEDATE,
THETIME,
SUM(CPUUEXEC) CPUUEXEC,
SUM(CPUUSERV) CPUUSERV,
SUM(CPUIOWAIT) CPUIOWAIT,
SUM(CPUIDLE) CPUIDLE,
(SUM(CPUUEXEC)+SUM(CPUUSERV)+SUM(CPUIOWAIT)+SUM(CPUIDLE)) TPERF
FROM DBC.RESUSAGESPMA
WHERE THEDATE = DATE
GROUP BY 1,2)DT;

regards,

Subramanian kaushik Gurumorthy

4 REPLIES
Enthusiast

Re: Tperf calculation for my system

Hi Anyone Would be able to help me out here .

Thanks in advance for your help.

regards,

Subramanian kaushik Gurumoorthy

Enthusiast

Re: Tperf calculation for my system

Kaushik,

There is a TPERF rating for every Teradata Systems. By using that TPERF rating for your system, you can able to calculate the required TPERF. Even I don't have much idea on this, but below 2 links might help you.

http://teradatadba.blogspot.com/2010/07/tperf-per-user.html

https://developer.teradata.com/blog/carrie/2010/11/converting-cpu-seconds-old-node-type-to-new-node-...

Thanks,

Dinesh

Enthusiast

Re: Tperf calculation for my system

Hi Dinesh,

Thanks for your response, but it does not answer my question as I want to know how TPERF is being calculated and want ton understand if it matches the value of my system.

Re: Tperf calculation for my system

Teradata Tperf isn't a number that can be calculated, it's assiged to each node generation based on tests that have been executed against the node generations hardware.  Adding a link that I came across today looking for the tperf numbers for older generation hardware.

http://apps.teradata.com//TDMO/v07n03/Tech2Tech/AppliedSolutions/TeradataPlatform.aspx