SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Dynamic Partitioning and Dynamic Indexing


Dynamic Partitioning and Dynamic Indexing

Author
Message
Raghavendra Narayana
Raghavendra Narayana
SSC Rookie
SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)SSC Rookie (43 reputation)

Group: General Forum Members
Points: 43 Visits: 1
Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/nraghavendra/3210.asp



Adrian Hains
Adrian Hains
SSC Veteran
SSC Veteran (252 reputation)SSC Veteran (252 reputation)SSC Veteran (252 reputation)SSC Veteran (252 reputation)SSC Veteran (252 reputation)SSC Veteran (252 reputation)SSC Veteran (252 reputation)SSC Veteran (252 reputation)

Group: General Forum Members
Points: 252 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
noeld
noeld
SSCoach
SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)

Group: General Forum Members
Points: 16174 Visits: 2048
This a very "risky" proposition which I would doubt most people would dive into.


* Noel
Mahesh Sawaiker
Mahesh Sawaiker
Forum Newbie
Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)

Group: General Forum Members
Points: 6 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 BigGrin

But over all must say it made some interesting reading and the concept still holds.
dma333
dma333
SSC Veteran
SSC Veteran (212 reputation)SSC Veteran (212 reputation)SSC Veteran (212 reputation)SSC Veteran (212 reputation)SSC Veteran (212 reputation)SSC Veteran (212 reputation)SSC Veteran (212 reputation)SSC Veteran (212 reputation)

Group: General Forum Members
Points: 212 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!



Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search