SharePoint Page Storage Limits: Maximizing capacities

When it comes to storing data and creating webpages, SharePoint is a robust and versatile platform. However, one question that often comes up is: "What is the SharePoint page storage limit?" Understanding these limits is crucial for efficient data management and to avoid unexpected storage issues. Let's delve into the details of SharePoint's page storage limits.

SharePoint's storage capacity is not a one-size-fits-all affair. The storage limits depend on the type of SharePoint deployment and the specific services used.

SharePoint Online Storage Limits

In SharePoint Online, Microsoft provides a generous amount of storage, with the limit dependant on the type of license. For most plans, the limit is unlimited, meaning users can store as much data as they need within their subscription.

However, while the storage is 'unlimited', Microsoft does place a cap on the maximum file size that can be uploaded or synced to SharePoint. This cap is currently 250GB per file.

Team Sites and Communication Sites

For Team sites and Communication sites, each site collection has a soft limit of 25TB. This means that if a site collection reaches this limit, it doesn't stop working, but you won't be able to create new items. To manage storage efficiently, Microsoft recommends keeping site collections below 1TB.

Additionally, there's a hard limit of 5,000 lists and libraries per site collection, with individual list and library item limits set at 30 million per site collection. For fields, the limit is 500,000 column sites per site collection, and 15 levels of data per list item.

OneDrive for Business

OneDrive for Business, which is integrated with SharePoint, has a personal storage limit of 25TB but can be increased upon request. Each file uploaded should not exceed 250GB.

Moreover, files uploaded to OneDrive sync with the SharePoint library, and the combined storage limit for OneDrive and SharePoint is 25TB.

SharePoint Server On-Premises Storage Limits

For on-premises deployments, SharePoint uses SQL Server and Windows File System for storage. The total data size is calculated as the sum of the database size and the file system data size.

Database Level Limits

At the database level in SQL Server, the maximum table size depends on various factors such as workload, disk space, and the specific SQL Server edition. In a SharePoint context, it's recommended to keep tables below 200GB. However, keep in mind that Microsoft does not specify a physical limit for the data length in a row.

For the total database size, Microsoft recommends keeping it below 4TB. This is because supporting larger databases may require specialized hardware, higher SQL Server licensing levels, and additional administrative effort.

File System Level Limits

The file system level storage limit is determined by the operating system and the volume that holds the SharePoint content database. In an Exchange Server, for instance, the file system supports up to 16TB per file, with file system support up to 18EB total.

The exact amount of content that can be stored in SharePoint is determined by the combined storage limits of the SQL Server databases (database and log file) and the file system. Efficient data management, including regular clean-up and archival, is essential to stay within these limits.

Understanding the SharePoint storage limits helps in planning your data migration and content management strategies. Microsoft's document 'SharePoint Online Limits and Default’ provides a comprehensive overview of these limits. By staying informed and adhering to best practices, companies can ensure their SharePoint deployments remain efficient and secure.