Storage technology to store attachments for a online web appliction

Question

Hi,

I want to choose Azure solution to store documents (attachment). These are attachments linked to cases in salesforce.
Right now we are storing these as blob data in SQL server, each file size can be max 5 MB and total data is between 500GB-1TB. On usages side we would like to fetch these objects for a online web application, first we show user list of attachments available for a case and when user clicks on a file we download that for user.

Total size of SQL database is 75 GB. Adding attachments makes it a huge database, may not be right approach.

What is recommended approach in such scenario and where can I read more about scenario based comparison on azure storage services?

Answer 1

Hi Vipin,

Not sure what type of blob storage you are using but Premium will provide you efficient and fast response in your scenario though bit pricey than the current standard Genv2 but will do the job in terms of quick response times for high resolution files etc. storage-blob-block-blob-premium

Hope this helps.
JS

==
Please Accept the answer if the information helped you. This will help us and others in the community as well.

Answer 2

@Vipin Sharma Welcome to Microsoft Q&A Forum, Thank you for posting your query here!

Refer to the below mentioned articles which give detailed information based on your requirement.

Learn how to use Azure Storage, Azure SQL Database, Azure Cosmos DB, or a combination of Azure resources for a performant solution in your business scenario.

This topic compares options for data storage for big data solutions—specifically, data storage for bulk data ingestion and batch processing, as opposed to analytical data stores or real-time streaming ingestion: https://learn.microsoft.com/en-us/azure/architecture/data-guide/technology-choices/data-storage

Storage capabilities are critical for supporting workloads and services that are hosted in the cloud. As you prepare for your cloud adoption, review this information to plan for your storage needs: Review your storage options

If you have any additional questions or need further clarification, please let me know.

----------

Please do not forget to and “up-vote” wherever the information provided helps you, this can be beneficial to other community members.