I am sure there are a few guides on the internet for this.
But this is my .02cents.
These are things I always ask for when a server is being built/bought.
Disk, if possible (i mean if they have it in their Datacenter) get the db
onto a fibre channel SAN, something like EMC.
CPU, big cache... as big as possible, at least 1mb per CPU.
I'm not sure, but is it possible to 'Pin' a table the likes of what you
are talking about? Might be worth a try.
__________________________________________
Anthony Hand
DBA | Systems Integration
Aon Risk Services Australia Ltd
Ph: +61 2 9253 7516
Fax: +61 2 92537952
"Fang, Elaine"
<Elaine.[Email Address Removed] To: "LazyDBA.com Discussion" <[Email Address Removed]
.com> cc:
bcc:
25/11/2003 09:30 Subject: high insertion data performance
AM
Hi list,
I am working on the a software (for call center) which only needs 2 tables
in the database. However, they expect 1-2 million rows being inserted to
one of the tables over 8 hours period of time (so it will be about 3-6
million per day as the call center opens 24x7) and at least the same amount
of data being written to the other table if not more. Each table has about
12 columns, and the total row width is about 500 bytes. They haven't
decided how many days to retain the data in the table, but I wish the
number of rows won't exceed 100 Million. Plus there will be at least a few
indexes being put on each of the tables. There will be no update on the
tables, but old records will be purged from the table regularly (based on a
datetime field). The tables will be mainly used for running some reports.
Here is the question --
In worse case scenario, there will be 6 million rows inserted to that
table, which translates to about 70 records per second. What kind of
hardware will I need to ensure such thing happen? Plus, what else do I need
to consider? And if you also have such a heavy insertion to your table, can
you share your haredware config and thoughts on this?
Very much appreciated!
Elaine
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Get today's cartoon: http://www.LazyDBA.com
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed] "The information contained in this email and any attached files
is strictly private and confidential. This email should be
read by the intended addressee only. If the recipient of this
message is not the intended addressee, please call Aon Risk
Services Australia, Aon Consulting, Aon Re Australia Ltd and
other associated Aon Companies on +61 2 92537000 and promptly
delete this email and any attachments.
The intended recipient of this email may only use, reproduce,
disclose or distribute the information contained in this email
and any attached files with Aon's permission. If you are not
the intended addressee, you are strictly prohibited from using,
reproducing, disclosing or distributing the information
contained in this email and any attached files.
Aon advises that this email and any attached files should be
scanned to detect viruses. Aon accepts no liability for loss
or damage (whether caused by negligence or not) resulting from
the use of any attached files."
MS Sql Server LazyDBA home page