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.
Thursday, March 29, 2012
Database storage limitations in sql server
Labels:
database,
limitations,
microsoft,
mysql,
oracle,
perforamcne,
server,
sql,
sqlserver,
storage
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment