Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Troubleshooting MSSearch waits in SQL 2005

Posted on 2009-02-09
2
Medium Priority
?
600 Views
Last Modified: 2012-05-06
Our internal website has slowed to a crawl (queries are submitted but time-out), and viewing the performance dashboard reports (http://www.microsoft.com/downloads/details.aspx?FamilyId=1d3a4a0d-7e0c-4730-8204-e419218c1efc) reveals that we have a large number of waits (22 to be exact).  All but one is typed MSSEARCH; the remaining one is typed TRACEWRITE.  Any suggestions for how I should troubleshoot this?

Thanks in advance - this is pretty urgent.
0
Comment
Question by:hennessym
  • 2
2 Comments
 
LVL 31

Accepted Solution

by:
James Murrell earned 2000 total points
ID: 23605264
0
 
LVL 31

Assisted Solution

by:James Murrell
James Murrell earned 2000 total points
ID: 23605286
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Question has a verified solution.

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

I am showing a way to read/import the excel data in table using SQL server 2005... Suppose there is an Excel file "Book1" at location "C:\temp" with column "First Name" and "Last Name". Now to import this Excel data into the table, we will use…
Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…

572 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