I am building a BI and an Analytical tool which will be analysing millions of records for each customer. I am trying to understand from a performance and scalability perspective whether I will be able to make this application a cloud based application using Azure?
I am planning to segregate each customer by their own Database but not what the capacity of the server would be etc… any guidance on how to select the correct architecture and infrastructure would be helpful.
