物理读取页面最多的100条语句
- SELECT TOP 100
-
- qs.total_physical_reads,qs.execution_count,
-
- qs.total_physical_reads /qs.execution_count as avg_io,
-
- qt.text, db_name(qt.dbid) as dbname, qt.objectid
-
- FROM sys.dm_exec_query_stats qs
-
- cross apply sys.dm_exec_sql_text(qs.sql_handle) as qt
-
- ORDER BY qs.total_physical_reads desc
-
- GO
|
逻辑读取页面最多的100条语句
- SELECT TOP 100
-
- qs.total_logical_reads,qs.execution_count,
-
- qs.total_logical_reads /qs.execution_count as avg_io,
-
- qt.text, db_name(qt.dbid) as dbname
-
- FROM sys.dm_exec_query_stats qs
-
- cross apply sys.dm_exec_sql_text(qs.sql_handle) as qt
-
- ORDER BY qs.total_logical_reads desc
-
- GO
|
找出这些语句然后经可以用语句调优的方式来进行调优了。
b、如果你认为语句已经没有调优的空间了,或者像快速的提高服务器性能就只能增加物理内存了。