September 7, 2005 at 9:24 am
Perfmon continually shows one of the four processors staying in the 90 to 95% utilization range, while the other three seem to average about 30 to 40%.
Granted, there are about 12 different databases on this cluster and with Profiler it points out that our biggest and most used database is what is causing the run up on that one CPU.
Is it wrong to think that the workload should be more spread out over the processors rather than just one getting punished?
Studdy
September 8, 2005 at 8:43 am
From my experience SQL 2000 does not balance itself evenly between the processors. Nor does Server 2003 balance itself well.
However if you are running on a 2003 platform and are running multiple SQL instances on the same server, you can manually balance the load by using WSRM. Once WSRM is installed you can allocate different processor(s) to a service and/or set a percentage of the processor(s) that you want each service to use. You can also use WSRM to limit the RAM each service can use. You can very the percentage and proceesor percent by the time of day. Therefore in the evening you can allocate more processors and ram to a service in order to do nightly batch processing.
Hope this helps.
September 8, 2005 at 9:20 am
You might be running into the issues of proportional fill. This is very well documented by Mat Stephen on his blog:
http://blogs.technet.com/mat_stephen/archive/2005/02/02/365370.aspx
Also, check and make sure that tempdb is not becoming a source of contention. If it is, then adding more files for tempdb will be a solution. There is a KB article by Microsoft on it that you can look up on MSDN.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply