Hi, I have been using SAS for over a year with an on-premise Server-based solution with roughly 10 users. From my experience so far, the I/O has been the bottleneck when it comes to multiple queries. For a new project I am playing with the idea to set it up as a cloud solution. The options I see so far are:
• Amazon Redshift (Data Warehouse) + Amazon EC2 for the SAS virtual server
• SAS Cloud Analytics + Amazon Redshift (Data Warehouse)
• maybe others?
My questions so far:
• For a set-up of 10 SAS users what are the options for building a cloud SAS solution for analytics and information marts?
• What should be considered when calculating the costs? Is there a calculator that does rough estimates based on users, data size, expected queries?
• What are the differences in performance for on premise vs in the cloud?
• What are the differences in terms of pricing?
At what point does it make sense to have an on-premise solution?
Thank you in advance!