August 17, 2008 at 9:30 pm
Hi Experts,
Is it possible to partition tables in a database??If so will it help in improving the performance???
TIA
August 18, 2008 at 12:46 am
It can... it's up to your setup and what you are trying to accomplish with it. There is a whitepaper that might give you some more insight about it http://msdn.microsoft.com/en-us/library/ms345146.aspx
August 18, 2008 at 2:00 am
Is it possible to partition tables in a database??If so will it help in improving the performance???
Yes.
Yes, providing you implement the right partitioning strategy.
Partitioning strategy should target at least one of the following:
1- Help query performance by hitting a single partition or a limited set of partitions each time some critical query runs.
2- Help purge strategy.
_____________________________________
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.August 18, 2008 at 2:37 am
Is it possible to partition tables in a database??If so will it help in improving the performance???
partitioning ?
- Think parallel IO
- limited scan (partition scan) if needed
- alligned indexes (i.e. if an index is created without specifing a hosting filegroup, the index will be created using the target partition schema of the table. This make also the alligned index to be subject of parallel operations, ..)
- read only / read write partitions for your table
- sliding windows (if set up correct !)
- partial rebuild at partition level
- backup / restore facilities
First read the white paper until you get it profoundly.
Then set up a test / playground db using partitioning.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply