Hi all,
I have spent literally days and days looking for a method to calculate/ size the Web Analytics SQL databases in SP2010.
I found the great whitepaper :
http://technet.microsoft.com/en-us/library/cc298801.aspx
for SQL db sizing and it does all databases EXCEPT the Web anlaytics dbs.
We know the number and size of documents, number of users, retention rates of docs, number of http hits per use per day etc etc.
Now I realise every installation is different, but for MS to basically avoid how to even just very roughly how to size these dbs is just very un-cool and frankly very slack.
If you could find some tool or a rough guideline on how to do this sizing, I think you should get an MVP just for that alone. As a DBA, I cant hand on heart go to our storage guys and tell them how mcuh disk we need until I get this question answered and its basically stopping a large SP2010 project for a very high profile system. I could just go "Ah stuff it, we'll just go 100 GB for staging and 200 Gb of reporting" – but thats just not cricket in my book. Do it properly or go the hell home.
Any help much appreciated. Please post back here when you find something.
I have also submitted a query at :
http://social.technet.microsoft.com/Forums/en/sharepoint2010general/thread/c3a217fe-7378-4264-a8a8-052bf36ad7b7
but I suspect it will be put in too hard basket.
Any thoughts much appreciated.
Cheers
Steve.
