摘要:
SETTRANSACTIONISOLATIONLEVELREADUNCOMMITTEDSELECTTOP20ROUND(s.avg_total_user_cost*s.avg_user_impact*(s.user_seeks+s.user_scans),0)AS[TotalCost],s.avg_user_impact,d.statementASTableName,d.equality_columns,d.inequality_columns,d.included_columnsFROMsys.dm_db_missing_index_groupsgINNERJOINsys.dm_db_mis 阅读全文
摘要:
SETTRANSACTIONISOLATIONLEVELREADUNCOMMITTEDSELECTTOP20CAST(qs.total_elapsed_time/1000000.0ASDECIMAL(28,2))AS[TotalElapsedDuration(s)],qs.execution_count,SUBSTRING(qt.text,(qs.statement_start_offset/2)+1,((CASEWHENqs.statement_end_offset=-1THENLEN(CONVERT(NVARCHAR(MAX),qt.text))*2ELSEqs.statement_end 阅读全文