Solved

Sharepoint 2010 Search Database issues

Posted on 2014-07-29
1
156 Views
Last Modified: 2014-11-03
Hello,

I think we have an issue with our sharepoint 2010 search database.   The database I am referring to is the WSS_Search_namehere.   The entire sharepoint server runs fine for 5 mins after server restart or IIS restart, after 5 minutes it comes to a halt.  If I disable the SharePoint Foundation Search Refresh timer job than SharePoint will continue to work perfectly fine.  As soon as I turn this job back on, when the timer hits for that job (set for 5 mins) the whole site stops working again.   When this happens it also causes our TempDB in SQL to grow from a couple MBs to 20 -30 GBs.   Does anyone have any suggestions on how to fix this issue?

Thank you
0
Comment
Question by:danskoit
1 Comment
 
LVL 8

Accepted Solution

by:
Jayaraja Jayaraman earned 500 total points
ID: 40227599
kill the search search and recreate it from scratch
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
MS SQL Delete Query 9 31
TLS/SSL Diable 3DES ciper suites 4 29
TSQL - How to declare table name 26 30
convert null in sql server 12 33
If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
If you don't have the right permissions set for your WordPress location in IIS, you won't be able to perform automatic updates. Here's how to fix the problem.
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question