seawalt的专栏

<br />SELECT TOP 10<br />   total_worker_time/execution_count AS avg_cpu_cost, plan_handle,<br />   execution_count,<br />   (SELECT SUBSTRING(text, statement_start_offset/2 + 1,<br />      (CASE WHEN statement_end_offset = -1<br />         THEN LEN(CONVER

1.SELECT TOP 10 total_worker_time/execution_count AS avg_cpu_cost, plan_handle, execution_count, (SELECT SUBSTRING(text, statement_start_offset/2 + 1, (CASE WHEN statement_end_offset = -1 THEN LEN(CONVERT(nvarchar(max), text))

SELECT TOP 10 plan_generation_num, execution_count, (SELECT SUBSTRING(text, statement_start_offset/2 + 1, (CASE WHEN statement_end_offset = -1 THEN LEN(CONVERT(nvarchar(max),text)) * 2 ELSE statement_end_offset END - s

SELECT   SUM(multi_pages_kb + virtual_memory_committed_kb + shared_memory_committed_kb      + awe_allocated_kb) AS [Used by BPool, Kb]FROM sys.dm_os_memory_clerksWHERE type = 'MEMORYCLERK_SQLBUFFERPOOL'

SELECT   DBS.database_id,   DBS.name,   file_id,   io_stall_read_ms,   io_stall_write_msFROM sys.dm_io_virtual_file_stats(NULL, NULL) IO_FilesJOIN SYS.DATABASES DBSON IO_FILES.database_id=dbs.database_id

SELECT TOP 10   (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_phys_reads,   execution_count,   (SELECT SUBSTRING(text, statement_s

SELECT t1.object_id, t2.user_seeks, t2.user_scans,   t1.equality_columns, t1.inequality_columnsFROM sys.dm_db_missing_index_details AS t1,   sys.dm_db_missing_index_group_stats AS t2,   sys.dm_db_missing_index_groups AS t3WHERE database_id = DB_ID()   AND

WITH Waits AS( SELECT wait_type, wait_time_ms / 1000. AS wait_time_s, 100. * wait_time_ms / SUM(wait_time_ms) OVER() AS pct, ROW_NUMBER() OVER(ORDER BY wait_time_ms DESC) AS rn FROM sys.dm_os_wait_stats WHERE wait_type NOT LI