|
摘要：
-- top 10 引发i/oSELECT (total_logical_reads/execution_count) AS avg_logical_reads,(total_logical_writes/execution_count) AS avg_logical_writes,(total_physical_reads/execution_count) AS avg_physical_reads,execution_count,(SELECT SUBSTRING(text,statement_start_offset/2 +1, (CASE WHEN statement_end_offs 阅读全文
摘要：
--缓冲区池消耗内存总量SELECTSUM(multi_pages_kb + virtual_memory_reserved_kb + shared_memory_reserved_kb +awe_allocated_kb) AS[Used by BPool,kb]FROM sys.dm_os_memory_clerksWHERE type='MEMORYCLERK_SQLBUFFERPOOL'--查询确认哪些内部组件窃取了缓冲区池中大部分的页面SELECTTOP10 type, SUM(single_pages_kb) AS stolen_mem_kbFROM sys.dm_ 阅读全文
摘要：
--检测CPU压力的一个方法是计算运行状态下的工作进程数量，--通过执行如下的DMV查询可以得到这个信息SELECT COUNT(*) AS workers_waiting_for_cpu,t2.scheduler_idFROM sys.dm_os_workers AS t1, sys.dm_os_schedulers AS t2 WHERE t1.state='RUNNABLE' AND t1.scheduler_address = t2.scheduler_address AND t2.scheduler_id<255GROUP BY t2.scheduler_id- 阅读全文
摘要：
http://www.searchdatabase.com.cn/showcontent_35761.htm 阅读全文
|
