stefanogalizia (5/13/2008)
HI all,thanks for responses. The db is not serving a web site but a massive SMS sending, we are a mobileVAS provider.
At the moment, to be honest, we are not experiencing performance problem but we want to have scalability in order to face growing traffic and we think the best way is "add a server to SUM the power" something like oracle RACK.
Here we go again with the scale out stuff. OP: there was very recently a long thread about this same topic. (http://www.sqlservercentral.com/Forums/Topic496864-360-1.aspx#bm498905)
Short answer: hire a pro to help you tune your database and database application. Lots cheaper and more effective way to improve performance.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service