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









MS Sql Server LazyDBA home page