Archives of the TeradataForum
Message Posted: Thu, 10 Dec 1999 @ 04:19:59 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|