Design of database server - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Design of database server

Author

Topic

kotrs
Starting Member

1 Post

Posted - 2009-11-25 : 16:44:32

Hi,
I need help with design of database server.
Platform : MS SQL 2000 SE
OS : Windows server 2003 x32 or x64
Size of database: 10GB
Number of clients: 30
Dedicated for ERP system

1. I have MS SQL 2000 SE - support only 2GB RAM - Is it enough?
2. What raid configuration?
3. How many disks?
4. Is the effective two disk array, one for OS and LDF file and one for MDF file?

Thank

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2009-11-29 : 09:05:38

My standard is to split :
1)OS
2)Data files
3)Logs files
4)tempdb

Jack Vamvas
--------------------
http://www.ITjobfeed.com (IT jobs)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources