Database Statistics Timer Job got hangs on initialized state
Hi All, Env: MOSS 2007 SP2 64 bit architecture, 4 wfe and1 app server, wins server 2003, Sql 2005 . I have a site collection in web app which is reached 50 GB. Due to this, the Site collection is not opening. All other Site collection are opening well excepted this one with 50 GB database. All Site collection in this Web app has their own Content Database. I have checked the Timer job status and the Database statistics for the Web app having this Site collection is hangs on 50% initialized and this is happening for only one particular server "Server 4" instead of other 3 servers. If i follow this steps on Server 4: 1. Stop Windows SharePoint Services Timer on Windows Services 2. Go to C:\Documents and Settings\All Users\Application Data\Microsoft\SharePoint\Config on front-end server 3. Clear xml files from the above folder. 4. Open cache.ini file and restart the number into 1 5. Start Windows SharePoint Services Timer on Windows Services it aborted the timer Job and the Site collection start working and everything is fine. I have changed this timer Job to scheduled on Sunday. and i have the issue after this timer jobs runs and hangs on some X% to initialized. How can i avoid this initialized situation? Does anyone know How long it will take to finish this Job? Is there any changes i have to make on the Web.config or iis website? Is there any issue if i stop this timer Job? Please give me some inside for this issue. Thanks in Advance. Aniket
June 25th, 2012 1:30am

HI, First of all as your content db has reached 50 GB, I would suggest you to split it up for better performance. You can refer this http://technet.microsoft.com/en-us/library/cc825326.aspx for the same. This will then improve the job performance. I hope this will help you out. Thanks, Rahul Rashu
Free Windows Admin Tool Kit Click here and download it now
June 25th, 2012 11:46pm

HI, First of all as your content db has reached 50 GB, I would suggest you to split it up for better performance. You can refer this http://technet.microsoft.com/en-us/library/cc825326.aspx for the same. This will then improve the job performance. I hope this will help you out. Thanks, Rahul Rashu
June 26th, 2012 12:04am

Hi, That link is for moving multiple site collections from 1 DB to the specific database. i already have a SC with Specific DB. so i think the above link doesnt work in this case.Aniket
Free Windows Admin Tool Kit Click here and download it now
June 26th, 2012 1:00am

Hi, That link is for moving multiple site collections from 1 DB to the specific database. i already have a SC with Specific DB. so i think the above link doesnt work in this case.Aniket
June 26th, 2012 1:18am

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

Other recent topics Other recent topics