Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Partition Expand / Collapse
Author
Message
Posted Monday, July 19, 2010 2:47 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, February 21, 2013 3:14 AM
Points: 134, Visits: 425
Hi Friends,


I have a table with more than 30 million records .now i thought of partitioning the table on primary key please suggest me the approach.
Post #954650
Posted Monday, July 19, 2010 3:05 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, August 27, 2014 1:51 AM
Points: 1,262, Visits: 3,422
Many things to do and to prepare for the partitioning:

The first location and with all details about partitions is here: http://tinyurl.com/3xvo6zg

After that take a look the script here: http://tinyurl.com/2wlodhl

And please make a search about partition in the SQLServerCentral you will find many resources!
http://tinyurl.com/36hw6ke

Let us now something during the implementation!

Have a great day!
Dugi


============================================================
SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
http://www.sqlservercentral.com/articles/Best+Practices/61537/
Post #954653
Posted Monday, July 19, 2010 3:10 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, August 27, 2014 1:51 AM
Points: 1,262, Visits: 3,422
...Another nice resource about partition: http://bit.ly/aBD7EY

============================================================
SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
http://www.sqlservercentral.com/articles/Best+Practices/61537/
Post #954656
Posted Monday, July 19, 2010 6:20 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Tuesday, January 28, 2014 8:15 AM
Points: 3,068, Visits: 4,639
ningaraju.n (7/19/2010)
I have a table with more than 30 million records .now i thought of partitioning the table on primary key please suggest me the approach.


I usually ask myself a series of questions when the idea of partitioning a table pops-up on my mind, here are the basic ones:

1- Any particular reason to partition this table?
2- How many partitions?
3- What would be the partitioning key?
4- Would partitioning strategy help during archiving and purging of this table?
5- Would partitioning strategy improve performance? How and why?


_____________________________________
Pablo (Paul) Berzukov

Author of Understanding Database Administration available at Amazon and other bookstores.

Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Post #954764
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse