Support for 15,000 Partitions in SQL Server 2008 SP2 and SQL Server 2008 R2 SP1
Posted
on SQL Server Central
See other posts from SQL Server Central
Published on Thu, 09 Jun 2011 06:00:00 UT
Indexed on
2011/06/20
16:33 UTC
Read the original article
Hit count: 371
In SQL Server 2008 and SQL Server 2008 R2, the number of partitions on tables and indexes is limited to 1,000. This paper discusses how SQL Server 2008 SP2 and SQL Server 2008 R2 SP1 address this limitation by providing an option to increase the limit to 15,000 partitions. It describes how support for 15,000 partitions can be enabled and disabled on a database. It also talks about performance characteristics, certain limitations associated with this support, known issues, and their workarounds. This support is targeted to enterprise customers and ISVs with large-scale decision support or data warehouse requirements.
 |
The Future of SQL Server Monitoring Monitor wherever, whenever with Red Gate's SQL Monitor. See it live in action now.  |
© SQL Server Central or respective owner
