Thursday, March 29, 2012

Database storage limitations in sql server

Whats the limitations of data storage in sqlserver DB. How will be the perforamcne if i have database which will get a data of 400 GB per year and all the data should be there in the table the whole year and then it can be archived.according to ms you can continue to scale out and up if you use multiple servers clustered together with distributed partitioned views. more hardware. more sql liscenses. no problem. right.|||And the alternative is...? 32-way 32-bit cluster with a terabyte or 2 of RAM and the SAN of SAM. You gotta go up or out. I prefer out or both. I don't expect my software for free.

Read up on Google's technology. They can go out on 386 machines - discards. And as soon as people start discarding 1GHz machines, they'll switch to a real operating system.

No comments:

Post a Comment