SP_CONFIGURE 'max server memory',58*1024 GO RECONFIGURE WITH OVERRIDE GO 方法二:使用以下语句查找出什么语句读 内存很高,查处查询语句或过程在进行优化 SELECT SS.SUM_EXECUTION_COUNT, T.TEXT, SS.SUM_TOTAL_ELAPSED_TIME, SS.SUM_TOTAL_WORKER_TIME, SS.SUM_TOTAL_LOGICAL_READS, SS.SUM_TOTAL_LOGICAL_WRITES FROM (SELECTS.PLAN_HANDLE, SUM(S.EXECUTION_COUNT)SUM_EXECUTION_COUNT, SUM(S.TOTAL_ELAPSED_TIME)SUM_TOTAL_ELAPSED_TIME, SUM(S.TOTAL_WORKER_TIME)SUM_TOTAL_WORKER_TIME, SUM(S.TOTAL_LOGICAL_READS)SUM_TOTAL_LOGICAL_READS, SUM(S.TOTAL_LOGICAL_WRITES)SUM_TOTAL_LOGICAL_WRITES FROM SYS.DM_EXEC_QUERY_STATSS GROUP BY S.PLAN_HANDLE ) AS SS CROSS APPLY SYS.dm_exec_sql_text(SS.PLAN_HANDLE)T ORDER BY SUM_TOTAL_LOGICAL_READS DESC 注:以上语句只能在兼容模式为90,100下执行。 方法三:如果临时数据多话的增加.ndf数据文件,将临时数据放进去 |