question

vladif86 avatar image
vladif86 asked

The SQL server partitions management tools

Hi ALL, We are looking for an third party tools/open source for creation/deletion/merging partitions in the SQL server 2008 and further. It must be able to get as an parameter partition size, the partitions quantity, tables, how long ahead and to create the partitions according to these parameters. The tool has to be simple for a configuration (not by a DBA only) Thank you in adavnce , Vladi Feigin
sql-server-2008
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Magnus Ahlkvist avatar image
Magnus Ahlkvist answered
My first reaction is: Are you really sure that you want to play with partitions without really knowing what's going on? I'd say partitioning is an advanced task and I wouldn't want anyone without advanced SQL Server skills to configure them for my databases. Therefore I strongly recommend NOT using any 3rd party tool that simplifies these tasks too much. A rule of thumb: If you can't write and/or understand T-SQL scripts for an advanced task, you probably shouldn't perform it :) I don't know what you mean with "How long ahead"? Are you looking for a tool that you setup with parameters, and that will partition your tables automagically as soon as you reach a specific threshold? I haven't seen or heard of such tool. But I think you could be a little more specific about your requirements, I might have misunderstood the whole thing. I think the best way to be clear about your question is to give example scenarios.
2 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Cyborg avatar image Cyborg commented ·
+1, I agree with you Magnus!
0 Likes 0 ·
vladif86 avatar image vladif86 commented ·
Thanks for the answer. I'd like to add some clarifications (sorry for misleading you): We want to build a job, which will be responsible for creating partitions , automatically with the options to configure it via simple UI. In the configuration a user will be able to define : number of partitions in advance, size, tables , etc... Hope I'm clearer now Vladi
0 Likes 0 ·
Cyborg avatar image
Cyborg answered
As @Magnus said partitioning is an advanced concept. It is not the job of poor man, DBA and developer needs to work together on it. The one who is implementing partition should have the knowledge about the data distribution, File group and Disk structure. Moreover why you need to assign this task to non DBAs? Check out this free tool, [SQL Server Partition Management][1] from CodePlex. [1]: http://sqlpartitionmgmt.codeplex.com
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.