Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 291
  • Last Modified:

dual processor server not utilizing the 2nd server

when i look at the task manager on my server it shows the 1st cpu graph at about 50% and the 2nd graph at about 10%. is there a way to load balance the workload?

Jason
0
jasonfarmer
Asked:
jasonfarmer
  • 3
  • 3
  • 2
2 Solutions
 
Lee W, MVPTechnology and Business Process AdvisorCommented:
Did you look at the processes to see WHAT was using the CPUs?

If an application is multi-threaded, it can take advantage of two CPUs.  If it is NOT multi-threaded, then it cannot take advantage of multiple CPUs and the CPU the OS schedules it on is the CPU that will be used.
0
 
jasonfarmerAuthor Commented:
the sql server that comes with act 2005
0
 
Lee W, MVPTechnology and Business Process AdvisorCommented:
What SQL Server is it?  Is it MSDE?  I believe MSDE is locked to using 1 CPU only - it's the free version is not going to give you advanced performance and multi-threading for nothing... Microsoft is not that kind.
0
Fill in the form and get your FREE NFR key NOW!

Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

 
TheCleanerCommented:
I think you're just running into limitation of SMP:

http://en.wikipedia.org/wiki/Symmetric_multiprocessing

It can load balance to an extent, but I don't think you'll notice it unless you really are taxing the system.

You'll probably see that CPU0 does most of the interrupts, etc.

As far as a way to get true load balancing out of them...I don't know that one.
0
 
Lee W, MVPTechnology and Business Process AdvisorCommented:
Most multithreaded applications in Windows WILL be ROUGHLY load balanced.  A single continuous thread will not.  

If the system is NOT a true SMP system, but rather a HyperThreaded system, for example, then that could EASILY show the two CPUs off balance.  HyperThreading (as it was once explained to me by an intel rep), seperates the CPU into two processors - one integer, one floating point.  Then while the integer portion is busy, the floating point can run another operation instead of having it process ONE or THE OTHER, it processes BOTH.  If the application is integer intensive, then the floating point unit may remain largely idle.  Task Manager will view each as a seperate processor but not necessarily identify which is which.
0
 
jasonfarmerAuthor Commented:
its not a hyper threaded system. its a dual P3 1GHz system.
0
 
TheCleanerCommented:
http://www.oreilly.com/catalog/w2kperf/chapter/ch05.html

^^ see there if you want a decent explanation of how SMP works with Windows (pretty much the same in 2003).

I think you aren't going to find a good way to achieve a 50/50 balance (unless you went to a Linux kernel, lol).  If you knew the processes (use Process Explorer from www.sysinternals.com or task manager) you could set the Processor Affinity thus restricting a process to a certain processor, although you may open even more worms with that idea.

Unless CPU0 is running at 90-100% and the other one is sitting still at 10% under heavy loads, I wouldn't be too concerned.  Even if you could achieve a 50/50 split, I can't see that being any faster than a 70/30 split overall, since only one proc can still access system memory at a time on your system.
0
 
TheCleanerCommented:
Thanks for the points!
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

  • 3
  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now