Have a lot of customers -> which design should be chosen.

• rkisliak

  Grasshopper

  Points: 17

  More actions

  November 25, 2013 at 1:29 am

  #285527

  Hi to all, I have a task and I don't know how solve it 🙂

  So, we have a lot of customers who should use SQL server for their applications. Design is standard and simply:

  Customer -> Remote Desktop -> AppServer -> SQL Server

  So, now we plan create SQL cluster ('active/passive' or 'active/active/passive' btw which is preferred?) and we are don't know which design for this solution will be the best.

  For example we have 50 customers who wants to use DBE/Reporting/Analysis. What your offers about SQL design for solve this case?

  What I need to do with 'Reporting Services' and 'Analytics Service' for each customer?

  Should/can I install it to this cluster, or need to deploy it to another server?

  Which is the best variant for provide access to each customers DB/Reporting/Analytics?

  Thanks!