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.
You have to create file groups and proportionatly fill them with data in Standard edition since it does support table partition. Reference: http://msdn2.microsoft.com/en-us/library/ms345146.aspx#sql2k5parti_topic6 Regards Sat
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?