.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
MarieAdela
Imran Ghani
Post New Web Links

Random slow search queries

Posted By:      Posted Date: October 11, 2010    Points: 0   Category :SharePoint
 

Hi all,

I've been noticing some erratic behavior from our query servers with some searches taking unusually long time to execute. Digging through logs doesn't really show anything, except for entries like :

10/11/2010 13:14:21.53     w3wp.exe (0x1390)   ...    Entering monitored scope (RefinementManager.GetRefinement(Dictionary<string, ictionary<string, RefinementDataElement>>, XmlDocument, int)) 

10/11/2010 13:14:31.69     w3wp.exe (0x1390)    ...   Leaving Monitored Scope (RefinementManager.GetRefinement(Dictionary<string, Dictionary<string, RefinementDataElement>>, XmlDocument, int)). Execution Time=10150.0660000084    

So it took at least 10 seconds to run this search, while others may take less than half a second. Any ideas what that might be?

Thanks!






View Complete Post


More Related Resource Links

FAST search query is slow...

  
Hi, we are using fast search for sharepoint 2010. We are crawling an external data source and this is used for search queries. we have around 30 metadata properties and all are full-text indexed. however, the search operation is slow for a database of 5k records in intranet (webserver and database server are in different geographic regions). typically a 100 item search takes 9-10 sec. it get worse over internet and the search query varies from 10-45 sec for 100 items. Any pointers will be helpful. thanks.  

Sharepoint search 2010 related queries configuration

  
I am looking to enable the search related queries webpart for sharepoint 2010.  I am looking for instructions/documentation to configure this webpart.  Is there any out there?

Search results page showing random characters instead of item's description

  
I have an email-enabled document library that a few Japanese people email PDF files into (all external to the company). When I search for any PDF file sent from particular email addresses, the search results page displays random characters instead of the item's description. Here is an example: From Screen shots These characters don't appear for all email senders, just some of them. Our MOSS site is in English and we don't have any language packs installed. The PDF file contents are also in English. Can anyone point me towards a solution for this?

SPS 2010 Search :: Search Topology Queries?

  

Hi All,

I have search topology as shown below.

Check if this is ok : -

 (sERVER1)  WFE    (sERVER2)  WFE

(sERVER 3)  QUERY      (sERVER4) QUERY 

(sERVER5) cRAWL AND cENTRAL aDMINISTRATION         (sERVER 6)   cRAWL

(sERVER 7) aPPLICATION sERVER                   (sERVER 8) MYSITE

 

I guess will work good.

I have a query here : -

Query 1) As I have 2 Query server , is that i need to assign a virtual IP pointing to these two query server and load balance them?

 Query 2 As I have 2 Crawl server , is that i need to assign a virtual IP pointing to these two query server and load balance them?

If we need not to put them in load balance then how will the two server handle the request?

 Thanks,

MAnoj verma


manoj.verma

Custom search queries not logging except to Search Service Application

  

Hi,

I have written custom web controls that run specialised search queries under SharePoint Server 2010, using both FullTExtSQL syntax and (more recently) Keyword syntax, using both the object model and the Search web service.

Unlike the OOTB microsoft search webparts, which log to the web analytics section of the individual site collections, my controls only log the queries performed to the Web Analytics section of the Search service application (within Central Administration).

I have looked at the OOTB webparts using relflector, and followed the Federated search process for how the queries get logged, and I can't see any reason why my controls are ignored. (The QUeryInfo object is built and the information logged when the Query is executed, so it should be done when my custom queries are executed.)

Could anyone enlighten me as to what is going on here?

Thanks,

Jonathan

 


Slow performance with SQL Server 2005 executing parameterized queries with LIKE and an aggregate com

  

We have a slow-performing query and, after some analysis, have narrowed the cause down to using parametrized queries in conjunction with LIKE and aggregate comparisons used in the WHERE clause.  If we use a non-parametrized query (but keep the WHERE clause the same) the query performs much faster and, in fact, executes a different plan.  Using OPTIMIZE FOR UNKNOWN is not an option for us as we are using SQL Server 2005.  Obviously, we'd like to use parametrized queries to prevent SQL injection but the slow perf is unacceptable.  We need the LIKE to support wildcard scenarios.  If we need to we'll use dynamic SQL (scrubbed as much as we can) in lieu of parametrized queries.  We're wondering, however, is there another option that would give us the perf without sacrificing safety?  I can provide a sample database, query, plans, etc. if necessary...I'm assuming SQL Server generates a less efficient plan with the parametrized query as it can't make any assumptions about the parameter values...

Mike Bouck


Slow performance with SQL Server 2005 executing parameterized queries with LIKE and an aggregate com

  

We have a slow-performing query and, after some analysis, have narrowed the cause down to using parametrized queries in conjunction with LIKE and aggregate comparisons used in the WHERE clause.  If we use a non-parametrized query (but keep the WHERE clause the same) the query performs much faster and, in fact, executes a different plan.  Using OPTIMIZE FOR UNKNOWN is not an option for us as we are using SQL Server 2005.  Obviously, we'd like to use parametrized queries to prevent SQL injection but the slow perf is unacceptable.  We need the LIKE to support wildcard scenarios.  If we need to we'll use dynamic SQL (scrubbed as much as we can) in lieu of parametrized queries.  We're wondering, however, is there another option that would give us the perf without sacrificing safety?  I can provide a sample database, query, plans, etc. if necessary...I'm assuming SQL Server generates a less efficient plan with the parametrized query as it can't make any assumptions about the parameter values...

Mike Bouck


Search Server 2010 slow crawls on CMS 2.0

  
My client is crawling a CMS 2.0 installation with SharePoint Search Server 2010 and we are noticing that crawls on this content source for roughly 250K pages can take anywhere between 1-3 days.  As a comparison, our WSS 3.0 farm, with roughly 150K items, finishes a full crawl in slightly under 7 hours.

I am trying to troubleshoot why the CMS crawl is taking so long.  We have a small farm configuration with a dedicated DB server (which is a cental server for all applications requiring databases organization wide), a single crawl server hosting CA and the crawler component and two WFE/query servers that have one index partition spread over both of them.  All servers are virtualized Windows 2008 SP2 64-bit instances.

The CPU on the crawl server is pinned at 100% during crawls, usually consumed between various msdmn.exe processes and the mssearch.exe process.  The crawl server consistently uses roughly 3GB of the 4GB of allocated memory (I have advised them to at least double the amout of RAM, though Microsoft's recommendation of 16 GB per server would be the best practice.  This request is in process and it takes the organization a couple of weeks to fulfill any hardware upgrade requests!).

Here are some steps I have taken in an attempt to alleviate the slowdown

People search for AD user is very slow

  

People search for AD user is very slow, takes about 40 seconds to find a user. We are runing MOSS 2007 SP2 (64 bit win 2008 STD) and have 2003 AD. DC is local to the MOSS serers. Network and DNS are ok too. What esle can I do to fix this issue. 


Slow fulltext search

  

Hello,

I have a problem with full text search. It runs very slow. Originaly I thought that our server doesn't have enough memory to cache full text catalog and has to read it from the disk every time. But I ran single containstable statement on the server and it returned results instantly. So I guess the problem is in joining containstable results with other tables, Views.  I understand that containstable runs separately and the query is passed to MS Search Engine which returns results to SQL and merges them with the rest of the query. But I am not able to figure out what exactly causes the entire query to slow down. I also noticed that Order By rank desc slows down performance even further. But I need to show most relevant results first. Also, similar query without containstable works quite well. Below is the simplified version of my query along with the execution plan. Please help me to understand/solve this problem. We have SQL 2005 Workgroup edition, Windows 2003 server Standard edition. 4GB ram. Database size 55GB. Full text catalog size 600 Mb.

Eugene.

select top 60 
rn = ROW_NUMBER() OVER (ORDER BY key_tbl.rank desc),
productslocation_pid, min(ProductsLocation_price) minprice,
max(ProductsLocation_price) maxprice, count(*) BCNT, rank
from containstable (products, txtcat, 'video') as key_tbl
inner j

People search for AD user is very slow

  

People search for AD user is very slow, takes about 40 seconds to find a user. We have Sharepoibnt 2010.

I'v found this article

http://social.technet.microsoft.com/F...8f9e4883f9

But We have trust with other computer, which is in the other country. We don't delete it.

What way can you offer?


Search Queries in VB.net Help Required!

  

hi

im trying to perform a search query using drop down boxes with a button named search. I want it to bring up the data that is searched for. I dont know where to start from, i have looked around for some coding and different ways to do it but they seem complicated, this is the bit of ASP that is my weakness, need some assistance and guidance. below is the code for the page;

 

<%@ Page Language="VB" MasterPageFile="~/MasterPage.master" AutoEventWireup="false" CodeFile="ForSale.aspx.vb" Inherits="Users_ForSale" title="Properties For Sale" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">
    </asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
        
        <h3>Properties For Sale</h3>
        <h5>
            <asp:Label ID="lblTown" runat="server" Text="Town:"></asp:Label>
            <asp:DropDownList ID="ddlTownSearch" runat="server">
                <asp:ListItem></asp:ListItem>
                <asp:ListItem>Chadderton</asp:ListItem>
                <asp:ListItem Value="Failsworth"></asp:ListItem>
                <asp:ListItem>Oldham</asp:ListItem>
                <asp:ListItem>Royton</asp:ListItem>
                <asp:ListItem&

Search is very very slow.

  

Hi,

I am having a 2- Server(App n DB) topology on which MOSS 2007 has been installed.

We are having users around 2000. We are facing issue with the search functionality, which is very slow. Infact its not returning any results and just pauses.

I have checked out the Admin site - Search Adminsitration. I have seen couple of errors in Active Crawls content source. But dont know how to acces them.

Please help me out with same.

Thanks

Falgun



MS SQL Server: Search All Tables, Columns & Rows For Data or Keyword Query

  
If you need to search your entire database for specific data, this query will come in handy.

So when a client needs a custom report or some sort of custom development using Great Plains, most of the time I will have to track down the data in the system by running this query and find the table(s) it is in.

SharePoint Gets Search Analytics

  
Microsoft's SharePoint Portal Server 2003 was sold into a large number of organizations based solely on the strength of the search tool. Organizations hungered for a way to find the data they had generated.

Using SharePoint Search feature in ASP.Net Application

  
Integrating ASP.Net application in to MOSS 2007 to utilize SharePoint Enterprise Search Feature can be done by using Business Data Search.

Get more then google search from here

  
Just make it home page and enjoy more then google search you not only get google result and prizes for searching but also free ebooks and link from here like orkut,facebook,twitter,yahoomail etc...

Thanks
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend