 |
 |
Archives of the TeradataForum
Message Posted: Thu, 10 Dec 1999 @ 04:19:59 GMT
| 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.
| |
