Performance Data Collection Recommendations for Major Upgrades

Blog
The best minds from Teradata, our partners, and customers blog about whatever takes their fancy.
Teradata Employee

Under Construction.

11 Comments
Good summarization Steve. and congratulations on your promotion!
Teradata Employee
Thanks Kim. And, while I did change jobs (moving from the PS Performance and Workload Management COE, to the Teradata Global Support Center), I have not been promoted. It is a good thought though.

As I re-read this, though, there is one important part missing which I may go add if I can edit this still.

For a Floorsweep, collecting all of this data prior to an upgrade is only going to be helpful if you MOVE that data over to the new system. So, ensure you add to your project plan that all of this information needs to be archived and restored to the new system to allow for before and after comparisons in all of the areas discussed above.

Thanks.
Enthusiast
What's the difference between IOBlks (dbc.resusagesps) and TotalIOCount(dbc.dbqlogtbl) ?

I'd like to compute the number of IO manipulate by TERADATA system every day.

Since TERADATA 12, we can activate the SPS resusage parameter and the table DBC.ResUsageSps give us this information : IOBlks is the number of IO block handles by the system in the interval of 600s.

If I sum on IOBlks with a date criteria , it's supposed to be the number of IO manipulate by TERADATA system in one day :
SELECT TheDate,
SUM (IOBlks) as IO
FROM dbc.ResusageSps
WHERE Thedate = '2011-05-23'
AND NodeID BETWEEN '108' AND '110'
GROUP BY 1 ;

TheDate IO
23/05/2011 1389965483

(We have 2 active nodes 108 and 109 , 110 is HSN node.)

I'd like now to verify this result with the TotalIOCount in dbc.dbqlogtbl
sel cast(starttime as date) as TheDate ,SUM(TotalIOCOUNT)
from metro.dbqlogtbl where
TheDate= '2011-05-23'
GROUP BY 1

TheDate Sum(TotalIOCount)
23/05/2011 3833749921

The sum of IOBlks in dbc.resusagesps and the sum of TotalIOCount in dbc.dbqlogtbl is completely different.
There is surely something wrong and I don't know what.

Can anyone help me to explain these difference ?

Thanks
Enthusiast
Hello Woody

You wrote:
" When using threshold logging, you can never log to the other tables. Therefore, you cannot capture full SQL, the explain or object data"

Understanding that article was written almost 2 years back , is this limit still exist Especially with TD 13 onwards.? Manuals do allow to do threshold with detailed logging. I haven't tried it yet , as our box is still on TD 12.
Teradata Employee

Screenshots are from Teradata Manager. How do you do the same when going from TD13 to TD13.10 and run Viewpoint? What things get automatically collected and how do you get the resusage information collected as part of the pre-upgrade preparations?

Teradata Employee

The screenshots are showing how to collect schmon data on pre-TD12 systems.  TD12 and later logs this data via resusageSPS.

Hi Woody,

I am currently working on project based on performance monitoring of Teradata through data visualization. Data is successfully being collected in DBQL tables but data is not being collected in ResUsage Tables as I have turned on RSS Table Logging using ctl utility as you explained above.

I am using Teradata 13 on Windows 7 OS. Note I am working on localhost and on single machine. Your help is required.

Hi Woody,

I am currently working on project based on performance monitoring of Teradata through data visualization. Data is successfully being collected in DBQL tables but data is not being collected in ResUsage Tables as I have turned on RSS Table Logging using ctl utility as you explained above.

I am using Teradata 13 on Windows 7 OS. Note I am working on localhost and on single machine. Your help is required.

Teradata Employee

adeelz92,

Please contact your Teradata site team to assist with this issue.

Thank you.

Enthusiast

Hi,

How can I see the history of database space using diskspace? 

I want to see last month's database size of databases in the system using PDCR. Please shed some light on this.

Thanks,

Dinesh

Teradata Employee

There is a table that PDCR maintains which contains this information.  Look in your PDCRINFO database for it.  Or, you can contact the team that installed PDCR for you for more specifics.