服务器内存占用居高不下,sql server2008服务器内存居高不下

这是分页的语句。

set @totalPage=@Total/@PageSize --页总数

set @nowtotal=@totalPage * @PageSize

if(@nowtotal

--表示少一页

set @totalPage=@totalPage+1

--取最大页数

if(@PageIndex>@totalPage)

set @PageIndex=@totalPage

SELECT [FID],[FEducationID],[FUserID],[FUserName],[FGraduateInstitutions],[FStudyStartDate],[FStudyEndDate],[FStudyTypeID],[FStudyTypeName],[FDegreeID],[FDegreeName],[FEducationBackgroundID],[FEducationBackgroundName],[FProfessionalID],[FProfessionalName],[FCountryID],[FCountryName],[FCityID],[FCityName],[FSAPStartDate],[FSAPEndDate],[FSynchronizationLockID],[FIsSAPData],[FInactivateDate],[FCreateBy],[FCreationDate],[FLastUpdateBy],[FLastUpdateDate] FROM

(

SELECT [FID],[FEducationID],[FUserID],[FUserName],[FGraduateInstitutions],[FStudyStartDate],[FStudyEndDate],[FStudyTypeID],[FStudyTypeName],[FDegreeID],[FDegreeName],[FEducationBackgroundID],[FEducationBackgroundName],[FProfessionalID],[FProfessionalName],[FCountryID],[FCountryName],[FCityID],[FCityName],[FSAPStartDate],[FSAPEndDate],[FSynchronizationLockID],[FIsSAPData],[FInactivateDate],[FCreateBy],[FCreationDate],[FLastUpdateBy],[FLastUpdateDate],ROW_NUMBER() OVER (ORDER BY FID) AS RowNumber FROM TB_UUM_Education  WHERE FInactivateDate IS NULL

) AS A WHERE A.RowNumber

BETWEEN ((@PageIndex-1) * @PageSize+1 ) AND (@PageIndex * @PageSize)

很多很频繁