Backlog: intermittent timeouts/log outs when using backlog

   ASP_function: OOFunctionsSql.SetRSParamsCursor
   error_description: Query timeout expired
   error_id: 49039
   error_number: -2147217871
   error_source: Microsoft SQL Server Native Client 11.0
   log_type: exception
   logfrom_location: Website-ASP
   sql: EXEC RPM_GET_BACKLOG_PAGINATION_DATA '','SET NOCOUNT ON; select distinct GroupID as ProgramID into #tempPrograms from tblIterationReportGroup where GroupID in (606);  DROP TABLE IF EXISTS #tPortfolioRankDisplay;  SELECT RequestID, ROW_NUMBER() OVER (ORDER BY BacklogType, ReleasePortfolioRank, Title) AS PortfolioRank_Display  INTO #tPortfolioRankDisplay  FROM tblRequests where ReleaseID = 247 select * into #features from  ( select 1 AS ItemSortType, RequestID, Rank, FeatureRank, ReleaseRank, tblRequests.ProductID AS ProgramID  from tblRequests  where RequestID > 0   and tblRequests.ProductID in ( select * from #tempPrograms ) And (tblRequests.ReleaseID = 247)  union  select 2 as ItemSortType, t1.RequestID, t2.Rank as P_Rank, t2.FeatureRank as P_FeatureRank, 9999 as ReleaseRank, t2.ProgramID from tblRequests t1 inner join tblRequestMultiProgramRel t2 on t1.RequestID = t2.RequestID where t2.ProgramID in ( select * from #tempPrograms ) and t1.ProductID not in ( select * from #tempPrograms ) and t1.InRecycleBin is null  And