I am studying about many databases lately and the one thing I can't get the hang of is how to scale a write intensive application in SQL Server, I'm talking about native features, not third party software. I read about Federated Databases that seems to be something close to this, but I'm not sure if it is the best way since it seems to me that is way more read focused than write focused. I make myself clear that it is just an hypothetical situation and I do not have precise information of budget and pain points, I'm just assuming that I have a write intensive application (let's say 30/70) and I diagnosed that the bottleneck is on the database because it doesn't have enough CPU power and I want to scale with more servers therefore making a cluster, something like Oracle RAC.
closed as unclear what you're asking by Paul White♦, RLF, Philᵀᴹ, Michael Green, Shanky Apr 10 '15 at 5:13
Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.