Dual processors?

One of my customers just plugged in a second processor on a sql server 2000
running on a dell (dual Xeon at 2G). Does the simple fact of plugging in a
second processor increase the speed of sql server standard on that machine?
I'm not sure its that simple.
Any insight would be appreciated.
BobSQL will use the second processor, provided the OS accepts and uses it.
Whether that speeds up SQL depends on what resource is limiting SQL
performance. If the system was running over 80% CPU usage, he will likely
see some noticable speed improvement. As has been said before in this
forum, you first have to identify the performance limiting factor(s) I.E.
the bottlenecks, in your system before you can determine whether adding
resource X will make it faster. This applies whether X is memory, RAM, disk
capacity/speed, CPU speed/count, or network bandwidth.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Bob" <bdufour@.sgiims.com> wrote in message
news:OASJaP0BGHA.1288@.TK2MSFTNGP09.phx.gbl...
> One of my customers just plugged in a second processor on a sql server
> 2000 running on a dell (dual Xeon at 2G). Does the simple fact of plugging
> in a second processor increase the speed of sql server standard on that
> machine? I'm not sure its that simple.
> Any insight would be appreciated.
> Bob
>|||On Thu, 22 Dec 2005 17:05:40 -0500, "Bob" <bdufour@.sgiims.com> wrote:
>One of my customers just plugged in a second processor on a sql server 2000
>running on a dell (dual Xeon at 2G). Does the simple fact of plugging in a
>second processor increase the speed of sql server standard on that machine?
>I'm not sure its that simple.
Did you say on the other thread that you are running Windows 2000?
Windows Server 2003 supports threads better and is probably better
overall for multiprocessor systems.
Josh|||Bob wrote:
> One of my customers just plugged in a second processor on a sql
> server 2000 running on a dell (dual Xeon at 2G). Does the simple fact
> of plugging in a second processor increase the speed of sql server
> standard on that machine? I'm not sure its that simple.
> Any insight would be appreciated.
> Bob
Not only should it increase speed, but it will require you puchase
another CPU license if you are using the CPU licensing model.
To be sure, check to make sure SQL Server is using both processors. You
can do this from the server properties in SQL EM.
David Gugick
Quest Software
www.imceda.com
www.quest.com