View Complete Post
Hi - I have a query which is running very slow under a certain condition. I have 2 tables, Employees and EmployeeGroups. Employee has employees personal information and employeegroups has a mapping of each employee to the group it belongs to. One employee
can be a part of multiple groups. The problem is with the below query.
SELECT emp_GUID, emp_firstname,emp_LastName
FROM Employee E join EmployeeGroups ON Emp_Guid=EMG_Emp_GUID
where EMG_GUID In ('multiple group GUIDs') and emp_Lastname like 'abc%'
EMG_Emp_GUID - Employee id of the employee
EMG_GUID - ID of the group employee belongs to.
The query runs well with less number of groups but it slows down as the number of groups i.e data increases. The tables is well indexed.
I am running out of ideas on this. Need help.
Jared Parsons demonstrates a technique to achieve maximum performance from LINQ queries on large sets of data in order to create a responsive user interface.
MSDN Magazine August 2008
We have a monitoring tool set to check to see if the home pages for our 3 web apps load in under 60 seconds every 10 minutes. All 3 web apps load in under 3 seconds on every 10 minute check except for one exception. One check every
day one of the web app's home page takes longer than 60 seconds to load. This happens at 11:45PM when there is very little user usage on the environment. The characteristics of this page are as follows: The only thing on
the page is a list view web part which was added by the browser. The page has not been customized with SPD or code at all. The list that it pulls is a simple links list that has 281 items on it. The view
pulls all 281 items and displays them in sets of 100. I cannot find any associated event in the server events and/or SharePoint ULS logs nor are there any daily sharepoint timer jobs running at that time. Our full index happens
at midnight with incremental happening hourly. Our enviroment is 2 WFEs, 1 App/indexer and we have a separate SQL cluster backend.
Could someone lead me possibly in the direction I should take next in my troubleshooting?