Database

turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

06-11-2015
11:52 PM

06-11-2015
11:52 PM

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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

06-13-2015
04:46 AM

06-13-2015
04:46 AM

Hi Anyone Would be able to help me out here .

Thanks in advance for your help.

regards,

Subramanian kaushik Gurumoorthy

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

06-15-2015
07:41 AM

06-15-2015
07:41 AM

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

Thanks,

Dinesh

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

06-21-2015
04:02 AM

06-21-2015
04:02 AM

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.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

02-24-2016
01:34 PM

02-24-2016
01:34 PM

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