Best choice for a small (~100Mb) relational database in Sharepoint?

Question

All - I'm working with a client and am interested in developing a business opportunity pipeline relational database. It will be modest (perhaps 10 tables, no more than 200 new customers/year). I would like to build it in their Sharepoint environment. Can someone point me down the appropriate rabbit hole to explore options? Thanks, John

Answer 1

Hi @John Younger ,

According to your description, the database with the size of ~100Mb is a little small to make a good performance.

There are some article for your reference to plan and configure the database in SharePoint:

https://learn.microsoft.com/en-us/sharepoint/technical-reference/database-types-and-descriptions

https://learn.microsoft.com/en-us/sharepoint/administration/storage-and-sql-server-capacity-planning-and-configuration

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.