Database Design

greenspun.com : LUSENET : SQL Server Database Administration : One Thread

Dear Sir,

We want a database which has to handle incoming data from 300 devices at the same time.Any number of web clients can query the DB .(Say approx 300 clients)

A single device should be able to support 1.2 million records per hour and 10000 records per 30 secs.

1.Whether it is feasible to have 300 databases (each per device) (or)

2.Storing more than one device data in same database but having seperate table for each device. (or)

3.Storing more than one device data in same database using single table differentiate by deviceid.

Can you let me know what will be the optimal server capacity to handle such a database

Pl. Reply based on follwing factors 1.Resources required 2.performance 3.Reliability

Regards

Deepa.S

-- Anonymous, October 29, 2001

Answers

Deepa,

I regret that such questions (on server sizing) cannot be effectively answered in a forum.

I suggest that you hire a consultant, meet face to face, show your database design and queries, and draw systems diagrams. Then let him or her do some experimenting before giving an answer.

In short, this question requires more communication and time than can be provided in a forum.

Good Luck,

Eric

-- Anonymous, October 30, 2001


Moderation questions? read the FAQ