SQL SERVER – 2005 – Introduction to Partitioning

最新推荐文章于 2022-02-28 17:31:47 发布

aust_niuroutang

最新推荐文章于 2022-02-28 17:31:47 发布

阅读量449

点赞数

文章标签： sql server performance features database disk each

本文介绍了 SQL Server 2005 中的分区功能，这是一种将大型表和索引划分为多个较小、易于管理部分的方法。通过定义范围进行分区可以提高硬盘速度受限情况下的性能。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

original article: http://blog.sqlauthority.com/2008/01/24/sql-server-2005-introduction-to-partitioning/

Partitioning is the database process or method where very large tables and indexes are divided in multiple smaller and manageable parts. SQL Server 2005 allows to partition tables using defined ranges and also provides management features and tools to keep partition tables in optimal performance.

Tables are partition based on column which will be used for partitioning and the ranges associated to each partition. Example of this column will be incremental identity column, which can be partitioned in different ranges. Different ranges can be on different partitions, different partition can be on different filegroups, and different partition can be on different hard drive disk to improve performance.

Partitions can be set up very easily using schemes and functions as well can manage very easily humongous tables separate indexes for each partition. This will lead to high performance gain. Partitioning can increase performance when hard disk speed is performance bottleneck, if CPU or RAM is bottleneck partitioning will not help much.