Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ratheeshknair
Posting Yak Master
129 Posts |
 Posted - 2008-08-17 : 23:31:26
|
| Hi Experts, Is it possible to partition tables in a database??If so will it help in improving the performance???TIARKNAIR |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-08-17 : 23:36:54
|
| Possible in sql2k5 enterprise edition, but not necessary to improve performance just by partition table. |
 |
|
|
ratheeshknair
Posting Yak Master
129 Posts |
Posted - 2008-08-18 : 00:11:19
|
| Thanks For the reply ... The database contains tables having more than 10 million records.I thought it would be helpful in increasing performance if we divide tables under different partition.Can you please tell how the partition is made???RKNAIR |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-08-18 : 00:15:19
|
| http://weblogs.sqlteam.com/dmauri/archive/2005/07/18/7147.aspx |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-08-18 : 07:58:11
|
| No need of Partition for 10 million records. Just put right index and update stats and Maintain index . |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-08-18 : 08:44:45
|
Why do you write "No need for partition for 10 million records"?If the partitioning gains only 200 ms for each query against the table, and there's about 500,000 queries per day against this table, you will gain 27.7 CPU hours every day!
E 12°55'05.25"N 56°04'39.16" |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-08-18 : 12:47:33
|
| Correct. It is good if it is growing heavily. Have you considered the administrative overhead of implementing table partitioning and associated index? |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
|
Lamprey
Master Smack Fu Yak Hacker
4614 Posts |
Posted - 2008-08-18 : 13:22:43
|
| What version of SQL are you using? You can use partitioned views in 2000 and partioned tables in 2005-8. If you look up "partition" or "partitioning" in BOL that should help get you started. |
|
|
|
|
|
|
Table partitioning