We’re architecting our MOSS production environment and trying to determine how large the disk drives should be for our data servers. We’ll be connecting to a SAN for all of the databases but I’m trying to determine how much space I need for local file storage on the SQL server itself. I’d really like to use 15k drives but I’m limited to about 100 GB of storage with the preferred vendor.
Do you think I would need more than 100GB of local SQL server storage for a single farm MOSS implementation, 17-20 content databases/site collections, ~1 million documents, 400 concurrent users and 10-15k item-level hits per day? I'm having a hard time even determining what is actually stored on a local SQL server HDD when it's connected to a SAN for interactions with the databases.