SQL Server Performance

Do i use SQL 2005 Standard or Enterprise

Discussion in 'SQL Server 2005 Performance Tuning for Hardware' started by waqar, Oct 29, 2007.

  1. waqar Member

    Hi,
    Recently we have purchased
    1x DELL 6950 - 2xDual core optron with 4XGB RAM - 4x146-15k SAS

    3x MD 1000 - 15x146k-15k SAS with 3 x PERC 5/e.
    Now i want to configure my database (200GB), this database have 30 tables and almost 10 tables have 80Million to 1 billion records each.

    I am planning to create 6 RAID 5 (7x8 disk combination), i have more read than writes.
    How i can split my data over 6 controllers, if i use enterprise i can use table partition base on each record but cost will be to high (due to enterprise license).
    Is there any option i can achieve my scenario using standard version?
    Any help or direction to relevant thread will be appreciated.

  2. techbabu303 New Member

  3. thomas New Member

    Std Edition does not have a RAM limit in 2005 so you should be ok with that. Is it 64-bit or 32?
  4. waqar Member

    I am using Windows 2003 server Standard x64 and SQL SERVER 2005 Standard x64.
    I will read article on creating partition table, by end of this week i am going to setup my servers and storage. Do i need to keep any thing in mind while preparing server and SANs?


  5. dineshasanka Moderator

Share This Page