locked
WebParts table of Content database is growing rapidly RRS feed

  • Question

  • I am using MS Project Server 2007 with SQL Server 2005.

    The problem is that the wss_content database of our site is growing rapidly. It has been grown to ~60 GB. When I looked into each table, I found that it is only because of WebParts table as this table is keeping data of about ~45GB. 

    It is a big issue as I don’t have much space left in my hard disk now.

    Can you please inform me that how can I control the size of this table?
    Anything that I can do from MS Project/Sharepoint configuration? Or any useless data that I can delete from the WebParts table?
     

    I will appreciate your response.

    Thanks!!

    Thursday, July 28, 2011 5:13 AM

Answers

  • Just a quick check :

    1. Check the size of the WSS content database in physical directory. Do you see the ldf & mdf files & what is the size of the ldf & Mdf for WSScontent db.
    Did you try iwth DBCC Shrink to shrink the Transcation logs
    http://support.microsoft.com/kb/907511/en-us
    2, Do you have any custom web parts developed, If yes, run through the code & see if the code is efficient.


    Thanks, Amit Khare |EPM Consultant| Blog: http://amitkhare82.blogspot.com http://www.linkedin.com/in/amitkhare82
    Thursday, July 28, 2011 12:16 PM
  • Hi,

    In addition to Amit's suggestions...

    You should also be aware that direct edits to the table are not supported and may result in data loss, or an unsupported environment.

    I would have a look at the content in the SharePoint parts of your Project Server, specifically any views within the /PWA and Project workspacess which I believe the Webparts table is used to store. Do you have any large views with complex filters, grouping etc?


    Alex Burton
    www.epmsource.com | Twitter
    Project Server TechCenter | Project Developer Center | Project Server Help | Project Product Page
    Friday, July 29, 2011 12:30 PM

All replies

  • Just a quick check :

    1. Check the size of the WSS content database in physical directory. Do you see the ldf & mdf files & what is the size of the ldf & Mdf for WSScontent db.
    Did you try iwth DBCC Shrink to shrink the Transcation logs
    http://support.microsoft.com/kb/907511/en-us
    2, Do you have any custom web parts developed, If yes, run through the code & see if the code is efficient.


    Thanks, Amit Khare |EPM Consultant| Blog: http://amitkhare82.blogspot.com http://www.linkedin.com/in/amitkhare82
    Thursday, July 28, 2011 12:16 PM
  • Hi,

    In addition to Amit's suggestions...

    You should also be aware that direct edits to the table are not supported and may result in data loss, or an unsupported environment.

    I would have a look at the content in the SharePoint parts of your Project Server, specifically any views within the /PWA and Project workspacess which I believe the Webparts table is used to store. Do you have any large views with complex filters, grouping etc?


    Alex Burton
    www.epmsource.com | Twitter
    Project Server TechCenter | Project Developer Center | Project Server Help | Project Product Page
    Friday, July 29, 2011 12:30 PM