Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 10 Dec 1999 @ 04:19:59 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

Subj:   Re: Problems with CPU Usage
From:   Bill Grenwelge

What type of system are you running on? 5100, 5150,5200, 4300? And what type of processors do you have in it? Are you running at 90% CPU capacity at all times, and has this been normal for your system for some time? Or is this occuring only during certain periods of the day?

You may want to look at the workload being sent to the system and see if something can be done there to improve resource usage. There is a possiblity of having some very resource intensive queries that may be using up a large portion of your CPU. If you can't find any queries or jobs that are being resouce hogs then you may have very well just reached the capacity of your system. In that case, you will need to upgrade to a larger system. You can also look at the Resusage,Acctg, ampusage tables and get some more information on how the system is performing.

Hope this helps.

Bill Grenwelge
Teradata DBA @ Wal-Mart Stores, Inc.

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023