473,706 Members | 2,430 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Hardware configuration help for MS SQL server

This is what one of the tables looks like - they are all similar and there
are about 60 different tables:

CREATE TABLE SalesData1(
smalldatetime TimeStamp,
varchar(8) CustomerID,
numeric S1,
numeric S2,
numeric S3,
numeric S4,
numeric X
)

I'm not sure on the data types, S1 thru S4 are actually float values with
two decimal places. X is an unsigned long value.

Anyway, the bigger question is what do we need at *minimum* for hard drives
and RAM, if we are using SQL 7.0* under these circumstances:

1. Inserting up to 600,000 records every 10 minutes
2. Updating up to 70,000 records every 10 minutes

We can use BCP for inserting the data. There are many different tables with
an average of 10,000 records being inserted into each one every 10 minutes.

I nearly ordered a couple servers with dual 400GB SATA hard drives using
RAID1, but someone told me that with only 2 drives - it would cause SQL
server to work harder. So do we need a whole bunch of smaller 40GB drives??
Should they be SATA drives?

Could one server with dual Xeon CPUs do this, or do we need more than one
server?
And would 2GB of RAM be sufficient?

All I know is that we will be inserting 600k records, updating 70k records,
and reading 500,000 every 10 minutes.

Do I need to provide more info on anything specifically?

We should have an SQL consultant helping us in the near future - I'm just
trying to get a head start with the hardware. Our budget is small, in fact I
may have to build the servers myself out of spare parts and things on sale
at Fry's :)

Thanks for your help. I will provide more info if needed.

*Can't afford to upgrade to SQL 2000
Jul 27 '05 #1
3 2004
Stu
I highly recommend that you check out Kevin Kline's article Bare Metal
Tuning in SQL Server Magazine. He gives a step-by-step breakdown of
how changes in ahrdware affect performance; granted, it's written from
a SQL 2000 perspective, but it might give you some ideas.

http://www.windowsitpro.com/Article/...6492.html?Ad=1

Note that the article requires a subscription, but it's a great
investment.

Stu

Jul 27 '05 #2
"Stu" <st************ **@gmail.com> wrote in message
news:11******** **************@ f14g2000cwb.goo glegroups.com.. .
I highly recommend that you check out Kevin Kline's article Bare Metal
Tuning in SQL Server Magazine. He gives a step-by-step breakdown of
how changes in ahrdware affect performance; granted, it's written from
a SQL 2000 perspective, but it might give you some ideas.

http://www.windowsitpro.com/Article/...6492.html?Ad=1

Note that the article requires a subscription, but it's a great
investment.

Stu


Based on that article, how does this look (if I understand correctly):

Dual 64bit AMD processors, 4GB fast RAM.

Drive C: is 20GB SATA drive using FAT32 without RAID. The OS goes here.

Drive E: is 40GB total storage RAID 1 (two 80GB SATA drives) with NTFS. SQL
program files and logs go on here.

Drive F: to Q: are 40GB drives using NTFS and RAID 5. Data storage goes
here.

Thanks
Jul 27 '05 #3
Stu
Actually one thing he mentioned in his presentation was that AMD
Opterons actually performed worse than 32-bit XEON processors, although
he didn't mention it in his article. XEON processors act like dual
standard CPU, so two XEON's = 4 virtual processors.

If you have RAID 5, then you wouldn't have logical drives F through Q;
it would just show up as F. Be sure that you're using hardware RAID,
and not software-based RAID.

Other than that, it looks good. Get the biggest processors you can; fo
that much data, you'll need it.

Jul 28 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
2048
by: Lorax | last post by:
I'm on the IS team of a medium-sized non-profit with international reach. We're trying to make some decisions regarding our Web server and database server as we expand our web site to have more dynamic content. Currently the database server houses all data pertinent to the organization (membership data, events, products, etc) in one database (~2.2 GB) as well as the web site content in a separate database (~40 MB). The web site pulls from...
3
3533
by: Peter | last post by:
If I want to build a web services application (not web application), what is the hardware requirement ? Does anyone have the experience?
2
1419
by: ramankalia | last post by:
Hi, I need to provide SQL server for 100 or 50 VB clients. Please suggest the configuration for the above. thanks
9
933
by: kbd | last post by:
Hello: I know that hardware requirements are dependent upon many factors. However I need a sanity check on this configuration. First the purpose of the database. - database will be used to support a risk analysis group in a small financial firm. - there will be daily "bulk" loads to the database - as well as updates via GUIs (JSP or java programs)
0
1320
by: Jerad Rose | last post by:
I'm looking for information as to what considerations I should make when configuring an ASP.NET web server. I realize that a lot of factors need to be considered, but I'm just looking for a good starting point. Right now, I have a Windows 2000 (IIS 5) web server (P4 2.8 GHz, 1GB RAM, 80GB SATA HD) that is used to host an ASP site, which gets hit by 400-500 simultaneous users during peak hours (according to perfmon's Current Anonymous...
2
2652
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.
110
10603
by: alf | last post by:
Hi, is it possible that due to OS crash or mysql itself crash or some e.g. SCSI failure to lose all the data stored in the table (let's say million of 1KB rows). In other words what is the worst case scenario for MyISAM backend? Also is it possible to not to lose data but get them corrupted?
6
4554
by: Steve Mowbray | last post by:
Hi I am using SerialPort component to send raw binary files to a remote device with RTS/CTS handshaking - the remote device has a small receive buffer and is slow so needs to be hardware flow controlled to prevent the PC sending too much data per second. Here is my attempt at setting the hardware handshake operation: serialPort1->Handshake = System::IO::Ports::Handshake::RequestToSend; serialPort1->RtsEnable = true;
8
3521
by: Sid B | last post by:
(apologies for the cross-post) Hi, I am new to my company and have been asked to recommend a new redundancy / backup plan for our online server. I've talked to the other folks in the company and they have been describing an usual feature of the server wherein if we try to install ANY new hardware like a new harddisk, the system automatically formats everything. (apparently this "resetting feature" kicks in even if we add more RAM
0
8781
marktang
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...
0
8697
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9156
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
6615
isladogs
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...
0
5939
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();...
0
4453
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...
0
4709
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3149
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
3
2095
bsmnconsultancy
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...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.