Performance - Release Vehicle Roadmap - page never fully loads if several programs are associated to a single PI

2/12/21
11:10:38.305 AM	
{ [-]
   ASP_function: OOFunctionsSql.LogToSqlTiming
   correlationid: Ms262geNq3X3+UG4dj2rKEDz3t06Eaka9MMY6IdKaAE=
   customer_db: XXXXX
   log_type: warning
   logfrom_location: Website-ASP
   sql:        SELECT Selected, ID,  [dbo].[getReleaseVehicleTitle](4, JIRAProjectKey, ReleaseDesc, VehicleName, ReleaseID, ?, CONVERT(varchar, VehicleStartDate), Health, StoryID, CONVERT(varchar, VehicleDate)) AS Title  FROM (  SELECT CASE WHEN sv.StoryID IS NOT NULL THEN 'True' ELSE 'False' END AS Selected, v.VehicleName, v.VehicleStartDate, v.Health, VehicleID AS ID, v.ReleaseID, v.VehicleDate, sv.StoryID, r.ReleaseDesc, r.BeginDate as ReleaseBeginDate, t2.ProjectKey as JIRAProjectKey  FROM tblVehicles v JOIN tblRelease r ON v.ReleaseID = r.ReleaseID  INNER JOIN (                SELECT rp.ReleaseID FROM tblReleaseProductRel rp                INNER JOIN (                            SELECT t2.ProductID FROM sysmemberTeamRole t1                            INNER JOIN sysmemberTeamProduct t2 ON t1.TeamID = t2.TeamID                            WHERE UNIQ = 16                           ) x ON x.ProductID = rp.ProductID            )RP ON r.ReleaseID = rp.ReleaseID  LEFT JOIN (select * from tblAgileStoryReleaseVehicle where StoryID=?) sv ON v.VehicleID = sv.ReleaseVehicleID  LEFT JOIN  tblJIRAProjects t2 on v.JiraProjectUniqID = t2.UniqID  WHERE IsNull(v.Status, 0) <= 2  UNION SELECT CASE WHEN sv.StoryID IS NOT NULL THEN 'True' ELSE 'False' END AS Selected, v.VehicleName, v.VehicleStartDate, v.Health, VehicleID AS ID, v.ReleaseID, v.VehicleDate, sv.StoryID, r.ReleaseDesc, r.BeginDate as ReleaseBeginDate, t2.ProjectKey as JIRAProjectKey  FROM tblVehicles v JOIN tblRelease r ON v.ReleaseID = r.ReleaseID  LEFT JOIN tblAgileStoryReleaseVehicle sv ON v.VehicleID = sv.ReleaseVehicleID  LEFT JOIN tblJIRAProjects t2 on v.JiraProjectUniqID = t2.UniqID  WHERE sv.StoryID=?  ) AS rv  ORDER BY rv.Selected DESC, rv.ReleaseBeginDate ASC  OFFSET (?) ROWS FETCH NEXT (?) ROWS ONLY
   sqlCount: 150
   sqlFunction: SetRSParams
   sqlTime: 4177
   timestamp: 2021-02-12T12:10:38.305000-05:00
   url: https://xxxxxx.jiraalign.com:443/AjaxFiles/AjaxDropdown.asp?Type=83&itemId=65392
   urlverb: POST
   user: 16
   version: 10.86.0.13292
}