February 15, 2011 at 7:27 am
Hi ,
I am looking for information from SQL Server Architect Design perspective.
How much disk space required for Single standalone SQL Server 2008 and
how much disk space required for two node Cluster.
Example: If Database is 100 GB of size then Log(transactions logs) should be 1.5 to 2 % of database size, TembDB should of 2% of database size,
C and DSystem DatabaseTempDBlog files (ldf files)MSDTC Qurom Disk(Witness Disk)Disk Backups
Logical Drive Name
RAID Level
Disk Size
February 16, 2011 at 9:36 am
disk space depends on how fast it is growing
100 gb growing 10 gb a month needs one number and 100 gb growing 100 mb a month needs another
if you can afford it the tempdb goes on 1 mirrored drive
the logs on another mirrored drive
the data raid 10 but that could change if it is highly indexed
in that case partition the indexes to there own drive
February 17, 2011 at 2:01 am
Thanks,
I am not concerned for growth of Database. I am looking for initial propotion of disks like
If Database size will be 5 TB in 5 years then 10% of which is 500GB should be Logs drive size assuming average trasactions..something like rule of thumb
If Cluster configuration then 1GB for Witness disk,1GB for MSDTC and so on.
February 17, 2011 at 3:33 am
You cant do it like that.
Yes you can look up the requirements for an installation quorum\msdtc\system databases disks ect.
But you cannot define the requirements for database (user db's tempdb) size by 1 golden rule. You need to know what the application is doing, what the users are doing the initiale size, recovery models (backup strategy) ect
September 14, 2011 at 4:31 pm
Thanks for the information.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply