SQL Server Performance

SQL SERVER Installation - Recommendations please

Discussion in 'SQL Server Clustering' started by johnson_ef, Sep 16, 2005.

  1. johnson_ef Member

    HI 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


  2. ghemant Moderator

    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 />ghemant@gmail.com<br />"Humans don't have Caliber to PASS TIME , Time it self Pass or Fail Humans" - by Hemantgiri Goswami<br />
  3. satya Moderator

    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
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page