0

Im starting to implement a Shared Platform that will host multiple BI/Reporting applications.

The platform is required to be as scalable as possible and im also thinking how to achieve Load Balancing using SQL Server without using multi instance failover clustering that was my first thought...

Im also checking the SQL Scalable Shared Databases, but if I end up with lets say 30 reporting application managing this could be a Nightmare (My thoughts).

Any recomendation from your experience or any interesting Article or Success case?

Thank you!

0

SSRS Farm, NLB, AlwaysOn/read-only replica

Built in functionality add SSRS report servers to an SSRS farm. Multiple reports will point back to a single reporting database. In You can load balance the access to reports using NLB--network load balancing. If the reporting database performance ever became an issue (doubtful but I suppose it's possible) you could use a diskless cluster to push your reports database out to an alternate server via ALWAYSON/read-only replica. So no matter where your reports were pointing, you'd have current data and not a stale copy.

In theory you could test this scenario out in Azure especially if you have an MSDN license--and get up to 150 dollars of Azure each month(just don't forget to turn it off when you're not using it--or your dollars will disappear quickly). Azure--SSRS/VMs check, load-balancing check, setting up diskless cluster/Always on check.

SSRS and NLB https://msdn.microsoft.com/en-us/library/ms159114.aspx

AlwaysOn read-only replicas https://msdn.microsoft.com/en-us/library/jj542414.aspx

  • The problem is that I'm not hosting SSRS databases, they are databases that will be used by different reporting tools as Microstrategy, BO and also QlikView or Tableau... So the load balancing and scalability should be achieved at Database Level. – J1mmy May 5 '16 at 21:12

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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