SQL Server Performance Forum – Threads Archive
SQL SERVER Installation – Recommendations pleaseHI All, There is some fundamental doubts, which needs to be cleared for my new server setup. I have production database of 129782.38 MB (Drive H : ) Datasize : 115576 MB
(Drive F : ) Logsize : 2321 MB ( Simple Recovery Model )
(Drive I : ) Indexsize : 11885 MB. (Indexes are all clustered.) ——————————————————————– We find the server life is over and Disk space is another limitation. Now we are planning for new 2 node clustered Server, which may help us for DR. The reason why we kept the recovery model as ‘simple’ is, my log was grwoing in high volume, we set the model as ‘simple’ around one year back. Anyone can help me or guide me how about the disk arrangements if I go for ‘full’ recovery model. In new scenario, space and any RAID level can be used, its not going to be a constraint, organization is ready to invest in that. so hardware is not going to be an issue.
Secondly, I want to check how much will be my log size if I change the model into ‘full’, now I can not do that, coz, lack of space availability. Any tool/s to check the possible size. (for ref: approx 80000 records are accumulating in a day and 150 MB of data – captured through ‘sp_spaceused’ ) -Johnson
Hi Johnson,<br />please refer following thread in this regards :<br /><br /><a href=’http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=2761&SearchTerms=hardwareupgrade,’ target=’_blank’ title=’http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=2761&SearchTerms=hardwareupgrade,'<a target="_blank" href=http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=2761&SearchTerms=hardwareupgrade>http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=2761&SearchTerms=hardwareupgrade</a>,</a><br /><br />[<img src=’/community/emoticons/emotion-1.gif’ alt=’‘ />]<br />Regards<br /><br />Hemantgiri S. Goswami<br />[email protected]<br />"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri Goswami<br />
Transaction log files must be optimized for sequential I/O and must be secured against a single point of failure. Accordingly, RAID 1 (mirroring) is recommended for transaction logs. If you can schedule transaction logs every 5 mins or so, the transaction log size will be taken care easily. Satya SKJ
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.