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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics