I have a project with a 2TB database ( 450.000.000 rows). I need to provide to the project a solution that gives FailOver and load Balacing, what do you recommend? We are going to use a NetApp Filer for the Data Files and for the File System of the Project.
I read that SQL Clustering does not provide load balacing. If I cannnot have this feature and I have to go only to the FailOver what Server ( I presume that the key feature here is memory) would you recomend. We are adding 1.000.000 rows a day. Once the rows is inserted we are doing a lot of updates to that row for about 1 week then the row get static. Because of this I am thinking in some kind of history table or database or something like that.
I am open to the Os servers implementation, I was thinking of a windows 2008 server with cluster but this depend of the database solution