Performance improvement through table partitioning (comparison of table partitioning in SQL server 2008 (original) (raw)

Abstract

Increasing the size of the databases might face database administrators with performance issues. Most of the software vendors for DBMS products have included tools and techniques that help the database administrator to improve the performance of the database. In this article we will test one of the techniques used to enhance the database performance, named " table partitioning ". The test will be done on SQL Server, which is one of the most used database management systems. The article will show the steps to implement the table partitioning in SQL Server 2008 R2. A partitioned table with two partitions will be created to test the performance of queries on each partition. A data population process will be applied to the table in order to fill the partitions with differentiated amount of data. The largest partition will be called " archive " and the smaller one " current ". A comparison table storing the amount of time required to execute each of the queries will be created. Six tests for each query will be executed in order to provide accurate results. The comparison table will guide the interpretation process and will facilitate the conclusions.

Loading...

Loading Preview

Sorry, preview is currently unavailable. You can download the paper by clicking the button above.

References (4)

  1. SQL Server 2008 Query Performance Tuning Distilled , Grant Fritchey, Sajal Dan, Apress,2009
  2. Building a Data Warehouse with Examples in SQL Server, Vincent Rairardi, Apress, 2008
  3. Microsoft SQL Server 2008 New Features , Michael Otey, McGrawHills, 2008
  4. Microsoft SQL Server 2008 Relational Databases Design and Implementation, Louis Davidson, APress, 2008