There is very excellent blog post by Kendra Little @brentozar.com

See if that could help.

http://www.brentozar.com/archive/2012/03/how-decide-if-should-use-table-partitioning/