SharePoint Storage Limit Per Site in 2023

Microsoft SharePoint, a robust platform for document management and collaboration, often raises concerns about storage limits, especially at the site level. Understanding the storage capacity can help you manage resources effectively and make informed decisions about your SharePoint environment.

SharePoint storage limits can vary depending on your organization's specific plan and the version of SharePoint in use. However, a common misconception is that each site has a hard limit. In reality, SharePoint uses a more dynamic and flexible model, but let's break down the basics to understand how it works.

SharePoint Tenancy Storage Limits

In SharePoint Online and OneDrive for Business, storage is managed at the tenant level rather than the individual site level. This means each tenant has a total storage capacity that is shared across all its sites and users. For example, at the time of writing, the default storage limit for Microsoft 365 Business Premium is 1 terabyte (TB) of storage per user.

Even though storage is managed at the tenant level, there are still practical implications for individual sites. When a site nears its storage limit, administrators receive notifications, and it's crucial to understand these limits to manage storage effectively.

Default Site Collection Quota

Each site collection in SharePoint has a default storage quota. By default, this quota is set to unlimited, but your tenant administrator can configure it to have a specific limit. If a site collection exceeds its quota, you'll receive notifications, andnew content uploads will be blocked until you manually change the quota or free up space.

Understanding and managing site collection quotas can help you avoid unexpected storage limit issues. However, keep in mind that these quotas don't necessarily reflect the practical limits of your sites due to SharePoint's dynamic storage management.

Storage Used by Site Collections

SharePoint doesn't allocate storage space to individual site collections until it's actually used. This is an essential aspect of SharePoint's dynamic storage management. In other words, if you create a new site collection but don't use any storage within it, it won't count towards your tenant's total storage limit.

However, once you start using storage within a site collection, say by uploading files or creating lists and libraries, it will begin counting towards your tenant's total storage limit. This dynamic allocation means that while individual site collections don't have hard limits, overall storage usage at the tenant level is critical to monitor.

SharePoint On-Premises Storage Limits

For on-premises SharePoint deployments, storage limits can vary significantly depending on your configuration and available resources. Unlike SharePoint Online, on-premises environments use a different storage management model that's more closely tied to the physical servers and storage devices in your environment.

In on-premises SharePoint, the primary storage limits are typically determined by your database and file storage configurations. While these limits can vary widely, here are a few common factors to consider:

Database Storage Limits

SharePoint stores much of its data in SQL Server databases. The size of these databases is primarily limited by the storage capacity of your SQL Server instances. Therefore, the practical limits for SharePoint database storage depend on the size of your SQL Server disks and any quotas or limits configured within SQL Server.

In terms of real-world limits, a standard SQL Server instance using default configurations can typically support databases up to 1 terabyte (TB) in size. Larger databases are possible with specific configurations and enterprise-edition licenses, but they require careful planning and management.

File Storage Limits

SharePoint also stores files in libraries and document sets. These files are stored in Windows file shares, and their storage limits depend on the size of your file shares and any quotas configured at the file share or individual user level.

In terms of practical limits, the maximum file size that SharePoint can store is 250 gigabytes (GB). However, larger files can be divided into smaller chunks and stored using SharePoint's block blobs feature. Keep in mind that file size limits can also be influenced by other factors, such as the SharePoint configuration and your organization's network infrastructure.

In the ever-evolving landscape of SharePoint, understanding storage limits is crucial for effective management and planning. Regularly monitor your storage usage, and stay informed about updates and best practices from Microsoft to ensure you're getting the most out of your SharePoint environment. For on-premises deployments, consider engaging with experienced SharePoint professionals or consultants to help you navigate the complexities of storage management.