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 (
WHERE THEDATE = DATE
GROUP BY 1,2)DT;
Subramanian kaushik Gurumorthy
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.
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.
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.