?
Solved

Sharepoint 2010 Search Database issues

Posted on 2014-07-29
1
Medium Priority
?
164 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:Tim Lewis
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 8

Accepted Solution

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

Featured Post

Percona Live Europe 2017 | Sep 25 - 27, 2017

The Percona Live Open Source Database Conference Europe 2017 is the premier event for the diverse and active European open source database community, as well as businesses that develop and use open source database software.

Question has a verified solution.

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

In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
A recent project that involved parsing Tableau Desktop and Server log files to extract reusable user queries for use in other systems. I chose to use PowerShell to gather the data, and SharePoint to present it...
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…

765 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