Huge MSSCrawlURLLog table causing very large database - how to reduce the size?
In our MOSS 2007 environment we have two WFE servers. These two servers are also WSS Search server. One of these databases is about 6GB, but the other is 62GB and increasing real fast. In the SQL 2005 Management Studio I ran the Disk Usage By Top Tables report (right click database > Reports > Disk Usage By Top Tables). The report showed that the MSSCrawlURLLog table is THE table that is causing this huge database, it is 50GB in size. I am now wondering what is causing this issue and better yet, how I can solve this issue.Does anyone know how it is possible that this table grows so fast and how I can reduce the size, as the database is quickly filling up our drive.Regards,Yorick
June 25th, 2009 9:05pm
Just in Case if you need the Query..I usually use this to shrink my Configuration Database
USEDatabaseNameGODBCCSHRINKFILE(<TransactionLogName>,1)BACKUPLOG<DatabaseName>WITHTRUNCATE_ONLYDBCCSHRINKFILE(<TransactionLogName>,1)
TransactionLogName is your config database ldf file name without .ldf extension. DatabaseName is your wss config database name. Thanks,Anu
Free Windows Admin Tool Kit Click here and download it now
June 26th, 2009 8:44am
Hi guys,Thanks for the reply, unfortunately the data and transaction log files are not having any free space. So truncating these files will not help. The WSS_Search.mdf file is about 65GB now and still growing. When checking which table is usingthe most capacity, the MSSCrawlURLLog table is return (55GB at the moment). Does anyone have a clue why this table is solarge? I know editting directly in SharePoint databases is not supported, sohow can I reduce the size of this database?Regards,Yorick
June 26th, 2009 10:10am
One thing you might want to check over is your crawls. It might not be configured properly.Take a look at this post for things to check.http://admincompanion.mindsharp.com/BillBlog/Lists/Posts/Post.aspx?ID=83SharePoint's green status ball of doom...
Free Windows Admin Tool Kit Click here and download it now
June 26th, 2009 7:52pm
In Sharepoint 2010 I had to "Index reset"Under Central Administration / Manage Service application / Search Service Application . On the left hand side options I choose Index Reset. This emptied all the logs which was 60GB!!!! this is a quick fix but i
am still researching why it has grown so much. I suspect because i am using incremental every 5 minuts and there are many errors...
August 20th, 2010 3:01pm