Hi,
I'm ussually just told what I will be working with, but today I was asked to
choose the hardware myself.
First off, it's a small company, so a $10,000 server is not an option. But
also, a $500 box isn't going to cut it either.
Basically, I am builing a web app which generates from 10-100 million
records per calculation (yes, that's the spec). I'm using SQLServer 2000
(possibly 2005 if my employer wants to risk it), and ASP.NET. The
calculations are all done in stored procedures.
Comments, suggestions, and URLs are much appreciated.
Thanks in advance,
John 6 1281 (possibly 2005 if my employer wants to risk it),
huh ??? well barnes and nobles thought it was good enough + 2 years ago
when it was still in early Beta so risk wich risk ? ,,,,,
Well first tip use a seperate Web and SQL server this is much better
scalable
for business servers i would go for the poweredge series of DELL maybe two
2850 `s ?? one with 2 gb ( for the webserver ) and the other one with as
much memory as fits in the budget for the sql database
regards
Michel Posseth
"John" <pl*@dontspamme.com> wrote in message
news:eo**************@TK2MSFTNGP11.phx.gbl... Hi,
I'm ussually just told what I will be working with, but today I was asked to choose the hardware myself.
First off, it's a small company, so a $10,000 server is not an option. But also, a $500 box isn't going to cut it either.
Basically, I am builing a web app which generates from 10-100 million records per calculation (yes, that's the spec). I'm using SQLServer 2000 (possibly 2005 if my employer wants to risk it), and ASP.NET. The calculations are all done in stored procedures.
Comments, suggestions, and URLs are much appreciated.
Thanks in advance, John
Your not going to get a one line answer, as database sizing and web server
sizing are entirely different things and you've not hinted at whether you
expect different servers, raid clusters, resilience, failover, SAN/NAS
storage, lots of web traffic - only that you expect the database to be quite
busy. You've neitehr said if your 100 mill records are 1 bit large, or 1
meg each split across many tables, 1 user per hour or 100,000 per second -
and of course it all counts.
This is not a simple job, and if I was you I would be going back to whoever
asked you to chose the hardware and tell them you need to speak to the
hardware vendor, as they can normally help you make some initial estimates
and suggest appropriate hardware. Dont be fooled by your company being
small, for a high performance database you will easily spent $10,000.
A bit of light reading to get you started http://www.sql-server-performance.co...e_planning.asp
--
Regards
John Timney
ASP.NET MVP
Microsoft Regional Director
"John" <pl*@dontspamme.com> wrote in message
news:eo**************@TK2MSFTNGP11.phx.gbl... Hi,
I'm ussually just told what I will be working with, but today I was asked to choose the hardware myself.
First off, it's a small company, so a $10,000 server is not an option. But also, a $500 box isn't going to cut it either.
Basically, I am builing a web app which generates from 10-100 million records per calculation (yes, that's the spec). I'm using SQLServer 2000 (possibly 2005 if my employer wants to risk it), and ASP.NET. The calculations are all done in stored procedures.
Comments, suggestions, and URLs are much appreciated.
Thanks in advance, John
"John Timney ( MVP )" <ti*****@despammed.com> wrote in message
news:uZ**************@TK2MSFTNGP15.phx.gbl... Your not going to get a one line answer, as database sizing and web server sizing are entirely different things and you've not hinted at whether you expect different servers, raid clusters, resilience, failover, SAN/NAS storage, lots of web traffic - only that you expect the database to be quite busy. You've neitehr said if your 100 mill records are 1 bit large, or 1 meg each split across many tables, 1 user per hour or 100,000 per second - and of course it all counts.
This is not a simple job, and if I was you I would be going back to whoever asked you to chose the hardware and tell them you need to speak to the hardware vendor, as they can normally help you make some initial estimates and suggest appropriate hardware. Dont be fooled by your company being small, for a high performance database you will easily spent $10,000.
A bit of light reading to get you started http://www.sql-server-performance.co...e_planning.asp
-- Regards
Thanks, I will look at the URL.
BTW-There will probably be about 10 users, who will all together, probably
run less than 20 different scenarios per week. So not a lot of load. And
the records will be over 4 tables.
Thanks again,
John
My 2 cents:
1. By the fastest disk you can find.
2. A single processor will obviously be slower than 2, 4, etc. This
factors out to exponentially slower calculations.
3. $10,000 isn't even nearly adequate unless your willing to wait, and
wait, and wait, and wait......
4. Given the limited information you've provided I'd assume a 4 processor
machine with 4 GB of ram would still be painfully slow.
5. I agree with waiting on SQL 2005. Let everyone else experiment for 6
months. Microsoft has done their due dilligence but I'd wager there are
things out there waiting to nail people. I'm already seeing things in the
news groups about why things aren't working (Security is enable by default),
patches bringing servers down (Saw that one today in the setup newsgroup),
etc.
"John" wrote: Hi,
I'm ussually just told what I will be working with, but today I was asked to choose the hardware myself.
First off, it's a small company, so a $10,000 server is not an option. But also, a $500 box isn't going to cut it either.
Basically, I am builing a web app which generates from 10-100 million records per calculation (yes, that's the spec). I'm using SQLServer 2000 (possibly 2005 if my employer wants to risk it), and ASP.NET. The calculations are all done in stored procedures.
Comments, suggestions, and URLs are much appreciated.
Thanks in advance, John
"John" <pl*@dontspamme.com> wrote in message
news:eo**************@TK2MSFTNGP11.phx.gbl... Hi,
.... Comments, suggestions, and URLs are much appreciated.
Hi,
One of the partners has decided to go with hosted server.
Thanks again for the input.
John
The choices remain the same, whether you host it yourself or not. You will
still need to identify the correct specifications of the hardware you
require to manage the transaction quantity you will generate.
--
Regards
John Timney
ASP.NET MVP
Microsoft Regional Director
"John" <pl*@dontspamme.com> wrote in message
news:eR**************@TK2MSFTNGP10.phx.gbl... "John" <pl*@dontspamme.com> wrote in message news:eo**************@TK2MSFTNGP11.phx.gbl... Hi, ... Comments, suggestions, and URLs are much appreciated.
Hi,
One of the partners has decided to go with hosted server.
Thanks again for the input. John
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Brian Murphy |
last post by:
<?php
/*
I need your help. I'd be very thankfull if write me this script.I
need a script that displays a list of categories and subcategories
like this:
<select name="category">
<option...
|
by: Fred Ma |
last post by:
Hello,
This is not a troll posting, and I've refrained from
asking because I've seen similar threads get all
nitter-nattery. But I really want to make a decision
on how best to invest my time....
|
by: brian |
last post by:
I am working with a 3rd party credit card company that is using Python
version 2.2.2. They are using the httplib module to post data to my
server which is a dedicated server with no firewall or any...
|
by: Andrew Rawnsley |
last post by:
Anyone out there using beta 2 in production situations? Comments on
stability? I am rolling out a project in the next 4 weeks, and really
don't want to go though an upgrade soon after its released...
|
by: HotRod |
last post by:
I am new to this so please go easy. We currently have some students doing
some work on some web based tracking documents for us. They are currently
using VB .net to develop what we requested....
|
by: Derrick |
last post by:
Hello all;
This is going to be a bit long...sorry...
I am about to start out on a small scale client/server type system.
The server will collect data from various sources (custom hardware over...
|
by: hansBKK |
last post by:
Upfront disclaimer - I am a relative newbie, just starting out learning
about PHP, mostly by researching, installing and playing with different
scripts. I am looking for a host that will provide...
|
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...
|
by: ibeehbk |
last post by:
Hi. I have a form made in xhtml. I test via vbscript to make sure none of the fields are empty and properly formatted (ie email). All the regular fields work. However, I have two drop down menus...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
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,...
|
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...
|
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...
| |