View Complete Post
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?
I am using a LINQ query with multiple joins, the last join does not return any values even though values exist in the database. Below is my code.
when the query returns suiteNameTrg and SuiteTypeTrg are empty, all other values are returned correctly.
string suiteNameTrg = string.Empty;
string suiteTypeTrg = string.Empty;
using (DataClassesDataContext db = new DataClassesDataContext())
var productQuery = from assets in db.ASSETs
join relocatableUnits in db.RELOCATABLE_UNITs on assets.RUID equals relocatableUnits.RUID into assets_units
from relocatableUnits in assets_units.DefaultIfEmpty()
join build in db.BUILDINGs on assets.BUILDING_ID equals build.BUILDING_ID into assets_bins
from build in assets_bins.DefaultIfEmpty()
join test in db.TEST_SUITEs on assets.TEST_SUITE_ID equals test.TEST_SUITE_ID into test_bins
from test in test_bins.DefaultIfEmpty()
join testTrgt in db.TEST_SUITEs on assets.TARGET_TEST_SUITE_ID equals testTrgt.TEST_SUITE_ID into testTrgt_bins
from testTrgt in testTrgt_bins.DefaultIfEmpty()