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

Dynamic Partitioning and Dynamic Indexing Expand / Collapse
Author
Message
Posted Friday, August 24, 2007 2:11 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, March 25, 2004 5:05 AM
Points: 5, Visits: 1
Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/nraghavendra/3210.asp


Post #393784
Posted Wednesday, September 26, 2007 7:20 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Thursday, November 1, 2012 1:18 PM
Points: 110, Visits: 261
Along these same lines - anyone who is interested in optimizing their indexes based on live usage patterns should check out this blog entry from sqlcat on related dmv's:

http://blogs.msdn.com/sqlcat/archive/2006/02/13/531339.aspx



And you may want to play with this (unsupported) script from the sql query optimization team, it can automatically implement recommended index changes for your db:

http://blogs.msdn.com/queryoptteam/archive/2006/06/01/613516.aspx
Post #403006
Posted Wednesday, September 26, 2007 9:04 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Tuesday, September 16, 2014 5:47 AM
Points: 6,259, Visits: 2,029
This a very "risky" proposition which I would doubt most people would dive into.


* Noel
Post #403071
Posted Wednesday, September 26, 2007 9:59 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, December 22, 2010 1:58 AM
Points: 2, Visits: 10
Very interesting article indeed, few things I found that might actually hamper the performance considered for the solution in the share market scenario, your concept of implementation creates a scenario where there is one write(the common sproc) for every read, after thinking abt it for some time I thought that may be this can be just queued in some way(through another thread in the front end) and the more critical read executed. Another way it to have decision making channels that essentially dictate the way data is read, eg. stocks in news will be queried more... but then this is probably overshooting, another consideration is how long do the trends persist... you dont want to get into a situation where u r continuously re configuring ur partitions at a time when the trend no longer holds, more like how some people's hair styles are constantly behind the latest fashion :D
But over all must say it made some interesting reading and the concept still holds.
Post #403110
Posted Wednesday, September 26, 2007 11:43 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, July 20, 2010 8:22 AM
Points: 74, Visits: 27
Though I understand the concepts (which were presented eloquently), I would like to know more about how the table is actually used to dynamically recreate the partitions. Given the fact that you would probably only need to partition a table in the first place if it were quite large, would you actually let some process move your data around to repartition it without monitoring it?

I would also like to see some examples as to how you can dynamically add these partitions, since I plan on using a more predictable partitioning scheme (i.e. adding a new partition per quarter for a date-partitioned table). Can anyone provide such an example? Thanks!



Post #403151
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse