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 3 2001
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
"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
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. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
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...
|
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?
|
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
|
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)
|
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...
| |
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: 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?
|
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;
|
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
|
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,...
|
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...
| |
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: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
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...
| |