SharePoint Storage Management: Optimize Your Microsoft 365 Tenant

SharePoint Storage Management: The Complete Enterprise Guide

SharePoint Online storage is a shared, finite resource across your Microsoft 365 tenant. When storage runs low, site creation fails, file uploads are blocked, and productivity grinds to a halt. Effective storage management is not optional for organizations with more than a few hundred users.

This guide covers storage allocation, monitoring, optimization, archiving, and capacity planning based on our experience managing SharePoint tenants for organizations with 500 to 50,000 users.

---

Understanding SharePoint Storage Allocation

How Storage Is Calculated

Your total SharePoint Online storage pool is calculated as a base of 1 TB plus 10 GB per licensed user plus any additional storage you have purchased. An organization with 500 licensed users gets 1,024 GB base plus 5,000 GB from user allocations, totaling approximately 5.9 TB.

This is a shared pool. Individual sites draw from this pool, not from per-user allocations. A single site could consume the entire pool if quotas are not configured.

OneDrive vs SharePoint Storage

OneDrive for Business has its own storage allocation separate from the SharePoint pool. Default OneDrive storage is 1 TB per user and can be increased to 5 TB by administrators. OneDrive storage does not count against your SharePoint pool. However, OneDrive content does count against the overall Microsoft 365 storage for your tenant.

Site-Level Quotas

Each SharePoint site can draw up to 25 TB from the tenant pool by default. You can set custom quotas per site to prevent any single site from consuming disproportionate storage. We recommend setting quotas for all sites, not relying on the 25 TB default.

```powershell

# Set a 50 GB quota on a site

Set-SPOSite -Identity https://contoso.sharepoint.com/sites/Marketing -StorageQuota 51200 -StorageQuotaWarningLevel 46080

# View storage for all sites sorted by usage

Get-SPOSite -Limit All | Select-Object Url, StorageUsageCurrent, StorageQuota | Sort-Object StorageUsageCurrent -Descending | Format-Table -AutoSize

```

---

Monitoring Storage Usage

SharePoint Admin Center Dashboard

The Admin Center home page displays total tenant storage, used storage, and a trend graph. Navigate to Active sites and add the Storage used column to see per-site consumption. Sort by this column to identify your largest sites.

PowerShell Reporting

For detailed analysis, use PowerShell to generate storage reports.

```powershell

# Export comprehensive storage report

Get-SPOSite -Limit All | Select-Object Url, Title, StorageUsageCurrent, StorageQuota, @{N='PercentUsed';E={[math]::Round(($_.StorageUsageCurrent / $_.StorageQuota) * 100, 1)}} | Sort-Object StorageUsageCurrent -Descending | Export-Csv "StorageReport.csv" -NoTypeInformation

# Find sites over 80 percent capacity

Get-SPOSite -Limit All | Where-Object { $_.StorageQuota -gt 0 -and ($_.StorageUsageCurrent / $_.StorageQuota) -gt 0.8 } | Select-Object Url, StorageUsageCurrent, StorageQuota

```

Microsoft 365 Usage Reports

The Microsoft 365 admin center provides usage reports under Reports then Usage. The SharePoint site usage report shows storage trends over 7, 30, 90, or 180 days. Use this to identify growth patterns and forecast when you will need additional storage.

Automated Alerts

Configure storage threshold alerts to notify administrators before sites reach capacity. Set warning thresholds at 80 percent and critical thresholds at 90 percent of the site quota.

---

Storage Optimization Strategies

Version History Management

Version history is the single largest contributor to storage bloat in most SharePoint tenants. A 10 MB PowerPoint file with 200 versions consumes 2 GB of storage. Multiply this across thousands of files and the impact is enormous.

Recommended version limits:

• Standard document libraries: 100 major versions
• Compliance-sensitive libraries: 500 major versions (or as required by retention policy)
• Collaboration libraries with frequent edits: 50 major versions

```powershell

# Set version limits for a specific library

Set-PnPList -Identity "Documents" -MajorVersions 100

# Enable automatic version trim for the tenant (2026 feature)

Set-SPOTenant -EnableAutoExpirationVersionTrim $true

```

Microsoft introduced automatic version history trimming in 2024. When enabled, SharePoint automatically deletes older versions beyond the configured limit, recovering storage without manual intervention. We recommend enabling this feature for all tenants.

Large File Identification and Cleanup

Identify files consuming the most storage in each site. Large media files (videos, design files, CAD drawings) are common culprits.

```powershell

# Find files over 100 MB in a site

$items = Get-PnPListItem -List "Documents" -PageSize 1000 | Where-Object { $_["File_x0020_Size"] -gt 104857600 }

$items | Select-Object @{N='FileName';E={$_["FileLeafRef"]}}, @{N='SizeMB';E={[math]::Round($_["File_x0020_Size"]/1MB, 2)}} | Sort-Object SizeMB -Descending

```

Move large files to Azure Blob Storage, Stream for video content, or dedicated file storage services. SharePoint is optimized for documents, not large binary files.

Recycle Bin Management

Deleted items consume storage for up to 93 days in the recycle bin (first stage 93 days, second stage shares the 93-day window). During high-volume cleanup operations, empty the recycle bin to immediately reclaim storage.

```powershell

# Clear second-stage recycle bin for a site

Clear-PnPRecycleBinItem -SecondStageOnly -Force

# Clear all recycle bin items

Clear-PnPRecycleBinItem -All -Force

```

Orphaned and Stale Content

Content that no one accesses wastes storage and clutters search results. Identify stale content using the Last Modified date and file activity reports.

Stale content criteria:

• Not modified in 24 or more months
• No views in 12 or more months
• No active permissions (orphaned)
• Owner has left the organization

Run quarterly stale content reports and work with site owners to archive or delete unused content.

---

Content Archiving Strategies

Microsoft 365 Archive

Microsoft 365 Archive (released in 2024) provides a cold storage tier for SharePoint content at a fraction of the standard storage cost. Archived sites are read-only and searchable, but content access has higher latency.

Use Microsoft 365 Archive for sites that must be retained for compliance but are rarely accessed, completed project sites, former employee content, and historical records older than two years.

Retention Policies

Use Microsoft Purview retention policies to automatically manage content lifecycle. Configure policies that retain content for the required period (for example 7 years for financial records), then automatically delete it when the retention period expires. This prevents indefinite storage growth for compliance content.

Azure Blob Storage for Large Files

For organizations that store large files in SharePoint (engineering drawings, video production, medical imaging), move these to Azure Blob Storage with SharePoint links or custom integrations. Azure Blob Storage is significantly cheaper than SharePoint storage for large binary files.

---

Purchasing Additional Storage

When optimization is not sufficient, you can purchase additional SharePoint storage from Microsoft. Additional storage is sold in 1 GB increments at approximately 0.20 dollars per GB per month. For 1 TB of additional storage, expect roughly 200 dollars per month or 2,400 dollars per year.

Before purchasing, exhaust all optimization strategies. In our experience, most organizations can recover 20 to 40 percent of their consumed storage through version history optimization, recycle bin cleanup, and stale content archiving.

---

Capacity Planning

Growth Forecasting

Track monthly storage growth over 6 to 12 months to establish a trend line. Forecast when you will reach capacity based on current growth rates. Common growth drivers include new project sites, onboarding new departments, migration of on-premises content, increased adoption of SharePoint for collaboration, and integration with Power Automate generating stored outputs.

Budget Planning

Include storage costs in your annual Microsoft 365 budget. Plan for 15 to 25 percent annual growth in storage consumption. Factor in the cost of additional storage purchases versus the cost of optimization efforts.

---

Frequently Asked Questions

What happens when SharePoint storage is full?

Users cannot upload new files, create new sites, or save changes to existing files. Email-enabled libraries stop accepting incoming messages. This is a critical outage that affects all users in the tenant.

Does Teams file storage count against SharePoint storage?

Yes. Every Teams channel stores its files in a SharePoint document library. Teams file storage is part of the SharePoint storage pool.

Can I move storage between SharePoint and OneDrive?

No. SharePoint and OneDrive have separate storage pools. You cannot reallocate storage from one pool to the other.

How do I identify which sites are growing fastest?

Run the PowerShell storage report weekly and compare results over time. The Microsoft 365 usage reports also show growth trends per site over configurable time periods.

---

For help optimizing your SharePoint storage and implementing a capacity management strategy, [contact our team](/contact) for a storage audit. We identify quick wins that typically recover 20 to 40 percent of consumed storage within 30 days. Learn more about our [SharePoint administration services](/services).

Storage Management Automation

Automated Reporting with Power Automate

Create scheduled Power Automate flows that generate weekly storage reports and deliver them to administrators via Teams or email. The flow queries the SharePoint admin API for site storage data, formats it into an HTML table, and sends it to designated recipients. This ensures storage visibility without manual effort.

Proactive Alerts

Configure Azure Monitor alerts that trigger when tenant storage crosses defined thresholds. Set alerts at 70 percent (planning threshold), 80 percent (action threshold), and 90 percent (critical threshold). Each threshold triggers increasingly urgent notifications to the appropriate team.

Storage Chargeback Models

For large enterprises, implement a storage chargeback model where departments pay for the storage they consume. Track storage per department using site metadata and generate monthly chargeback reports. This creates financial accountability that naturally limits unnecessary storage consumption.