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.
| Author |
Topic |
|
sqlteamhoush
Starting Member
8 Posts |
 Posted - 2009-08-25 : 07:25:26
|
| hello,(System MS SQL Serv 2005 EE)we have 3 applications which will need max 20 GB space in 3 different dbs. Performance is not an issue - the server runs in a VM-Ware machine.The applicatiosn have all together only 10 users and all of them will access the DB only once of twice a day. Mainly read access.What do you think about this partitioning:c:\15 GB : OS and SQL-Server Program Filesd:\40 GB : for the databasese:\20 GB : for the log filesAm I missing something here? Is 20GB way too much for log-files? Is there any rule of thumb for the relation of the size of db partition to the size of the log-files partition?You see, I'm a total beginner on this, so I would appreciate any help on this.thx alot,h. |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-08-25 : 09:51:43
|
| Give double that for the OS part. |
 |
|
|
sqlteamhoush
Starting Member
8 Posts |
Posted - 2009-08-26 : 06:35:44
|
| ok,but why do I need so much for c:\? |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-08-26 : 11:08:20
|
| because you'll run out of disk space later, after a few windows updates and sql patches.i usually allocate 33GB for OS partition |
|
|
|
|
|
|
Partitioning