Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
WebParts table of Content database is growing rapidly RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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

  • Question
    Sign in to vote
    0
    Sign in to vote

    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
  • Question
    Sign in to vote
    0
    Sign in to vote

    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

  • Question
    Sign in to vote
    0
    Sign in to vote

    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
  • Question
    Sign in to vote
    0
    Sign in to vote

    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