I am planning to build a server to be used as a SQL Server and web server.
Right now I can only use a single box for both.
I have read some threads were dual processors are having problems with some
parallel queries and the suggestions of having sql server use a single CPU.
My budget is limited so I am debating whether to get 2.6G dual xeon 533FSB
or dual P4 800FSB (DRR@ ram) or stick with a speedy single cpu.
If I get a dual cpu motherboard, is it a good idea to have 1 cpu used for
sql server and the other for everything else?
John Dalberg 5 2989
On Sun, 21 Nov 2004 07:14:17 -0800, John Dalberg wrote: I am planning to build a server to be used as a SQL Server and web server. Right now I can only use a single box for both.
I have read some threads were dual processors are having problems with some parallel queries and the suggestions of having sql server use a single CPU.
My budget is limited so I am debating whether to get 2.6G dual xeon 533FSB or dual P4 800FSB (DRR@ ram) or stick with a speedy single cpu. If I get a dual cpu motherboard, is it a good idea to have 1 cpu used for sql server and the other for everything else?
John Dalberg
I forgot to mention also what about AMD's Athlon since I can get faster
Athlons for the same amount of money for Intel CPUs? Are dual Athlon
motherboards a good choice for SQL Server?
John Dalberg
In article <u1************ *************** **@40tude.net>, jo*****@hotmail .com says... I am planning to build a server to be used as a SQL Server and web server. Right now I can only use a single box for both.
I have read some threads were dual processors are having problems with some parallel queries and the suggestions of having sql server use a single CPU.
My budget is limited so I am debating whether to get 2.6G dual xeon 533FSB or dual P4 800FSB (DRR@ ram) or stick with a speedy single cpu. If I get a dual cpu motherboard, is it a good idea to have 1 cpu used for sql server and the other for everything else?
John, you can't use Dual P4's any more, Intel fixed that after the P3.
If you want to build a cheap but fast SQL Server, assuming SQL 2000 or
higher, tape a look at the ASUS PC-DL Deluxe motherboard. I have about
30 of these running the following:
ASUS PC-DL Deluxe
Dua Xeon 2.4G (or faster) (make sure they are same lot/part)
2GB or 4GB of RAM (does not require ECC RAM)
It has onboard SATA and IDE, you can use a total of 6 drives between the
connectors without a problem.
The 2GB systems with Dual 250GB SATA drives, video, case, CD-ROM, etc...
are under $1900 each.
If you want a big box, like this:
PC-DL Deluxe
Dual Xeon 2.8ghz
2 x 80GB IDE (OS = 12GB, LOGS = 60GB)
6 x 250GB IDE (for DATA files)
Promise SX6000 Hardware IDE RAID Controller (hot swap IDE drives)
cheap video
Chenbro Server case with Dual 550W PSU's
and Windows 2003 Standard Server 5cal
This box runs about $4000
I run SQL 2000 on Dual P3 and Dual/Quad Xeon without any problems.
If you get a P4, get one that does Hyper-Threading, and use Server 2003
so that you get the most benefit from it.
As for Athlon, faster is a matter of what task is being performed and
how stable you want the system to be. When it comes to business systems
I use Intel CPU's only, but that's a personal preference and has never
cost me a job or stability.
--
-- sp*********@rro hio.com
(Remove 999 to reply to me)
John Dalberg (jo*****@hotmai l.com) writes: I am planning to build a server to be used as a SQL Server and web server. Right now I can only use a single box for both.
I have read some threads were dual processors are having problems with some parallel queries and the suggestions of having sql server use a single CPU.
My budget is limited so I am debating whether to get 2.6G dual xeon 533FSB or dual P4 800FSB (DRR@ ram) or stick with a speedy single cpu. If I get a dual cpu motherboard, is it a good idea to have 1 cpu used for sql server and the other for everything else?
Machine configurations is not my best game, but if you are going to have
both SQL Server and web server on the same box, I would definitely go for
two CPUs. (Or at least one CPU that is hyper-threaded.)
As for SQL Server and parallel queries, yes, there is a potential problem.
I have seen more than once, SQL Server being too optimistic about parallel
query plans, and taken a plan with poor performance. What we usually do,
when we run into these queries is to add the query hint OPTION (MAXDOP 1)
which turns of parallellism for that query.
A more definitive cure is to set the configuration option "Max degress of
parllellism" to 1. Note that this is not the same as confining SQL Server
to one CPU only, but that one single query can only take one processor. Two
users executing different queries can still get one CPU each.
Giving SQL Server only one CPU *may* be a good idea, if you expect the
web server and the rest to need substantial amount of resources. But you
could also get the effect that one processor is mainly idle, while the
other is working around the clock.
So my recommendation would be set "Max degrees of Parallelism" to 1 (Or
to 2, if you have two hyper-threaded CPUs), but let SQL Server use both
CPUs.
Finally, there may be a licensing issue. I vaguely recall that for some
editions that you pay a license per processor, but please check this with
Microsoft. Licensing is definitely not my best game.
--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se
Books Online for SQL Server SP3 at http://www.microsoft.com/sql/techinf...2000/books.asp
In article <Xn************ **********@127. 0.0.1>, es****@sommarsk og.se
says... Finally, there may be a licensing issue. I vaguely recall that for some editions that you pay a license per processor, but please check this with Microsoft. Licensing is definitely not my best game.
I was told by the MS People in the Great Lakes MS Office that HT CPU's
still count as 1 CPU for licensing.
One other thing, unless he's using SBS, I was also told that a Web
Server accessing a MS SQL Database, requires a CPU License on the
Database server for each physical CPU the SQL server is permitted to
use.
I have always licensed our SQL Servers in CPU mode when being accessed
by a web server using anonymous connections to the web server.
--
-- sp*********@rro hio.com
(Remove 999 to reply to me)
Erland Sommarskog wrote: John Dalberg (jo*****@hotmai l.com) writes: I am planning to build a server to be used as a SQL Server and web
server. Right now I can only use a single box for both. bo*********@rbc .com I have read some threads were dual processors are having problems
with some parallel queries and the suggestions of having sql server use
a single CPU.
My budget is limited so I am debating whether to get 2.6G dual xeon
533FSB or dual P4 800FSB (DRR@ ram) or stick with a speedy single cpu. If I get a dual cpu motherboard, is it a good idea to have 1 cpu
used for sql server and the other for everything else? Machine configurations is not my best game, but if you are going to
have both SQL Server and web server on the same box, I would definitely go
for two CPUs. (Or at least one CPU that is hyper-threaded.)
As for SQL Server and parallel queries, yes, there is a potential
problem. I have seen more than once, SQL Server being too optimistic about
parallel query plans, and taken a plan with poor performance. What we usually
do, when we run into these queries is to add the query hint OPTION
(MAXDOP 1) which turns of parallellism for that query.
A more definitive cure is to set the configuration option "Max
degress of parllellism" to 1. Note that this is not the same as confining SQL
Server to one CPU only, but that one single query can only take one
processor. Two users executing different queries can still get one CPU each.
Giving SQL Server only one CPU *may* be a good idea, if you expect
the web server and the rest to need substantial amount of resources. But
you could also get the effect that one processor is mainly idle, while
the other is working around the clock.
So my recommendation would be set "Max degrees of Parallelism" to 1
(Or to 2, if you have two hyper-threaded CPUs), but let SQL Server use
both CPUs.
Finally, there may be a licensing issue. I vaguely recall that for
some editions that you pay a license per processor, but please check this
with Microsoft. Licensing is definitely not my best game. -- Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se
Books Online for SQL Server SP3 at http://www.microsoft.com/sql/techinf...2000/books.asp This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Plymouth Acclaim |
last post by:
Hi guys,
We have a problem with Dual AMD64 Opteron/MySQL 4.0.18/Mandrake 10
for a very high volume site. We are evaluating the performance on our
new server AMD64 and it seems it's slow compared to Dual Xeon/MySQL
4.0.15/RedHat8 and Dual Xeon/MySQL 4.0.18/Mandrake 10.
And it seems there are zombie threads. 570 threads in 1 hour and we
didn't even use JDBC connection pooling at all. These threads are
supposed to be gone within 60...
|
by: Canneloni |
last post by:
Xeon hyperthreaded CPUs show up as two CPUs in the cpuinfo file.
So a dual Xeon machine appears as a quad processor.
In Windows, it's the same thing.
A dual Xeon will have 4 CPU charts showing in the Task Manager cpu chart.
Ok, then question.
|
by: alex4groups |
last post by:
Hi,
I've been creating a db application using MS Access and MSDE. Only two
of us are using the application, and the server and the app both run
great on my laptop (1.6 GHz Pentium M, 2GB RAM, W2KPro). Only problem
is when I take my laptop home, my coworker loses access to the server.
We recently purchased a dedicated server to run the db on at the
office. It's a 2.8 GHz Dual Xeon, 2GB RAM, running XPPro. We also
bought SQL Server,...
|
by: Goldrake |
last post by:
I really hope that somebody can help me to solve a problem....
I have an asp.net application that call word to make an automation for
generate a document (inserting various table and file in the document).
I tested the application on a desktop pc (P4 2.8Ghz, 512MB) with Win2k3Srv
installed and all run without problem.
The same application running on a Xeon P4 HT Dual Processor with 2GB Ram +
Win2000Srv, is tremendously slower. It...
|
by: John Gibson |
last post by:
Hi, all.
I need to upgrade my dual Xeon PostgreSQL engine.
Assuming similar memory and disk sub-systems, I am considering a Quad
Xeon system vs. a Dual Itanium for PostgreSQL. I believe that the
PostgreSQL code is written for 32 bit and not optimized for the 64 bit
Itanium cpu. That makes me think that the Xeon system would be a better
choice.
| |
by: Rocael Hernandez |
last post by:
Hello all,
I was wondering what's best for PG, since we have to
decide what will be the new server for our DB, that
will serve one or more websites.
Our actual configuration is a dual xeon 2.8ghz with
4Gb ram + scsi disks, and works fine, though some
intensive insert/update processes has taken it to 100%
cpu use.
|
by: Parv |
last post by:
Hi all
I am having a SQL Server database of arround 110GB and 250 Users. What
is best suited hardware requirements for handling of such a database. I
am having following requirements from the server:
1. Feeding purpose : On which continously feeding is done by average
200 users.
2. Reporting purpose : on which average hundred of repords are running
at a time.
|
by: Artie |
last post by:
Hi all,
I was wondering if I could get some experienced opinions on SQL hardware to
run an ERP app on SQL 2000. The app does not yet support SQL 2005. The ERP
app has 25 users and likely won't exceed 30 users for several years. All
traffic is on the LAN. The ERP clients basically submit SQL requests for
reads and writes. The app makes heavy use of temp tables, temp views but
not many stored procedures. The current size of the db is...
|
by: praveenhathwar |
last post by:
I ve developed an application. My client has two monitors for a single PC. He wants to display a video clip in the second monitor continuosly (Repeatedly) and when the application in runs in Primay Monitor he needs to see that display in the half of the screen of second monitor (only for a particular module).
For Example: A Video Clip of an Advertisement will be running in 2nd monitor. When the cashier runs the billing module, that...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |