General discussion

Locked

DATABASE SYSTEM

By tse ·
we are currently planning our database system. If we have 2 million data on our database system and that is increasing..what factors should we consider so that in the next 5 to 10 years we will have no problem in our querying. our plan is to make itby SQL server in MS win2k advanced server...do we need load balancers? more than one server and vault storage? does the network speed will affect the performance? thanks a lot

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

DATABASE SYSTEM

by True_Texan In reply to DATABASE SYSTEM

First, SQL Server would be my choice also. You don't mention what applications you will be running to access the data, but do take into account 1) the growth of the data, 2) at what intervals you can archive information, 3) peak periods when you need may need additional processing power (ie. end of month processing, end of year processing, etc.)

My suggestion would be to have whomever you select as a hardware vendor scale a system for you.

Load balancing will probably depend upon the applications you are running. Some applications lend themselves better to load balancing than others.

You also might look into a new storage technology call the Storage Area Network. It's a very cool technology that seems to work well once you get it running.

I would guess that you would want multiple servers. Anything else you run on the database server is only going to take CPU time from SQL.

In the case of using multiple server and a Storage Area Network, yes, network speed will drastically affect performance. But remember, the app servers and DB server can be set to talk to each other over a 1Gb network while they talk to everyone else over a 100Mb network.

These are just my thoughts, but I hope they help you out.

Collapse -

DATABASE SYSTEM

by tse In reply to DATABASE SYSTEM

Thank you very much

Collapse -

DATABASE SYSTEM

by tse In reply to DATABASE SYSTEM

This question was closed by the author

Back to Networks Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums