Thanks yes I agree..
I am trying to design a table partition.
I have identified the Partition Key (Date) and for creating the partition function - the range.
I am trying to understand how I could define the range best.
For this -
1. I have found out the Size Per Row for the table.
2. On teh basis of assumptions (from business) on the data growth in future, I am trying to find out the best range.
3. I am calculating the projected size in future for each month and trying to sum up the size for months grouped together for which I can create range. This grouping could be 30GB each or 40 GB each or 50 GB each etc etc..
For this I need help to understand how much of a per partition size would be OK for the server that has 1 TB RAM and 80 CPUs. This will help me define the range.