Large sharepoint db

Question

We have TFS 2008 sp1. It was an upgrade from 2005. We have about 30 projects. I have forbidden anyone to use the team portal sites in tfs because I do not want documents spread over so many different sites.

However the backup size of my content db is over 1 gig. I know that tfs puts a certain amount of duplicate junk in each new site, but this seems out of order.

Sharepoint does not have the best tools for tracking diskusage and I have not identified any special exceptions.

Is this normal behaviour for TFS?

thanks
James

Answer 1

Hi James,

Thanks for reporting this issue.

I think this size is normal. I created 3 new team projects and the size of WSS_Content is about 200MB. TFS will largely increase the size of AllLinks and AllDocStreams table size. You can execute following commands in the SQL Management Studio:

Use WSS_Content;
Create Table #temp (
      table_name sysname , 
      row_count int, 
      reserved_size varchar(50), 
      data_size varchar(50), 
      index_size varchar(50), 
      unused_size varchar(50))

SET NOCOUNT ON
insert #temp exec sp_msforeachtable 'sp_spaceused ''?'''


Select TOP 10 * from #temp
Order by CAST(Replace(#temp.reserved_size, ' KB', '') as integer) desc
drop table #temp

It will list largest tables in the WSS_Content. Please check if their unused_size are also big.

If yes, you'd better check the KB at: http://support.microsoft.com/?id=924947
If no, the size should be normal.

Thanks,
 

Hongye Sun [MSFT]
MSDN Subscriber Support in Forum
If you have any feedback on our support, please contact msdnmg @ microsoft.com

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.

Answer 2

Oh, seems we are struck by the famous MS bloat! I have 10 years work by 6 programmers sitting in the TFSVersionControl db taking up 200K and the sharepoint that we don't use is taking up over 1 Gig!

The script showed that AllLinks and AllDocStreams are indeed the space hogs. However unused size was only 0.4Mb and 17MB respectively.

Looking forward to new version of tfs where there is no need for Sharepoint. It is just a upkeep headache and is no use if you are using many projects  with a small team.

Regards.
J.