SharePoint 2019 OnPrem, get data from Custom SQL Server database

Question

Hi All,

I'm using SharePoint 2019 OnPrem and data is in SP lists. There are total 10 lists. Out of that 5-6 lists has very large number of rows. We are creating reports from this data & showing on SharePoint Modern Pages.

As SP is not good for large databases & here the data is large in size, I'm thinking if database can be moved outside of SharePoint & we can still fetch it & use for visualization?

One option I'm thinking of is hosting data in Azure SQL Server & connect using BCS.

Can you suggest me if there is any better option?
Thank you in advance.

Thanks,
Sanjay

Answer 1

@Sanjay Adsure ,

We can use SharePoint Server together with Remote BLOB Storage (RBS) and SQL Server to optimize database storage resources.

RBS can be helpful to move BLOB data out of the SQL Server database, and onto commodity or content addressable storage.

Before using it, remember to understand the benefits and costs of using RBS, such as if you want to store fewer large BLOBs (256 KB or larger) for read-intensive or read-only access,RBS is a good solution, if you want to store many small BLOBs (256 KB or less) for write-intensive acces,RBS costs will outweigh the benefits :

https://learn.microsoft.com/en-us/sharepoint/administration/rbs-planning

---

If an Answer is helpful, please click "Accept Answer" and upvote it.

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.