I have my tag history tables set to 1 month partitions, I checked last months table and it was over 10 million rows. It seems like the trending was starting to slow down towards the end of the month, so I am getting a little concerned. Should I consider a smaller partition size or is this ok?
I know more history stuff will be added in the future so if these tables have a max size/performance limit I’d like to try and curb it now. I’m using MSSQL 2005 (it will move to a clustered database in a few weeks to so that may improve performance)
Also, if I change from month partition to week partition or something like that how will it affect the tables that are already there in month partition? Will it ignore them or start over from scratch?