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.

  • Please provide a lot more background information such as the current pain points, budget restraints, current methods being looked at and so fourth. Unfortunately with the data provided this question will be closed very soon. Federation is just 1 of many solutions out there and you might be just grasping at straws at the moment. – Ali Razeghi Apr 9 '15 at 20:08

As you are using SQL Server 2014, you could have a look at In-memory OLTP tables (nee Hekaton). They are suitable to write-intensive applications and there is a published pattern called Shock Absorber. Start here.

Not the answer you're looking for? Browse other questions tagged or ask your own question.