June 17, 2011 at 7:33 am
Have been looking at a Server with a high CPU usage. Indexes are not defragmented, the problem seems to be a couple of jobs that run every half an hour taking a long time to process.Unfortunately I have told I cannot touch the Underlying database or make any alterations to code/table.
Am being pushed for a CPU upgrade maybe mutiple processors, is this likely to make any difference or will this only make a difference for multi-threaded applications?
June 17, 2011 at 7:42 am
It is not a good solution to straightaway upgrade CPU. We need to collect more information regarding the queries or what exactly the job is doing. We need to try to tune this first before going for upgrade as there is no guarantee that this issue will not occur again.
M&M
June 17, 2011 at 7:51 am
We need to try to tune this first before going for upgrade as there is no guarantee that this issue will not occur again.
Given I have already stated that I have checked the indexes and I am not allowed to touch the base database. Can you give me a bit more of a clue how to "tune" the database as you say in this instance ?
June 17, 2011 at 8:01 am
MarvinTheAndriod (6/17/2011)
Have been looking at a Server with a high CPU usage. Indexes are not defragmented, the problem seems to be a couple of jobs that run every half an hour taking a long time to process.Unfortunately I have told I cannot touch the Underlying database or make any alterations to code/table.Am being pushed for a CPU upgrade maybe mutiple processors, is this likely to make any difference or will this only make a difference for multi-threaded applications?
How can somebody be tasked to take care of a performance issue and at the same time not allow such a person to implement changes?
Can you at least make recommendations?
Have you checked execution plan of offending queries? anything blatantly wrong on them?
Have you traced the offending queries looking at wait events?
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.June 17, 2011 at 8:07 am
How can somebody be tasked to take care of a performance issue and at the same time not allow such a person to implement changes? Politics
Can you at least make recommendations? Done
Have you checked execution plan of offending queries? anything blatantly wrong on them? No
Have you traced the offending queries looking at wait events? Yes[/quote]
Can anyone now answer my question ?
June 17, 2011 at 8:49 am
Am being pushed for a CPU upgrade maybe mutiple processors, is this likely to make any difference or will this only make a difference for multi-threaded applications?
Sorry, but there is not enough info to say for sure.
Adding more CPU may have no effect, or could even be counterproductive, especially if disk is the bottleneck.
High CPU can be but a symptom of another underlying issue. The first thing to do is find out the real bottleneck. What did those wait stats you took say?
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply