DEFINITIONS

Definitions More Info.
Definition ID877
TitleSQL
CategoryNOTES
DefinitionIO sorgulari-yiyen arkadaslar ISMAIL
Definition DescriptionSELECT TOP 20
[Total IO] = (qs.total_logical_reads + qs.total_logical_writes)
, [Average IO] = (qs.total_logical_reads + qs.last_logical_writes) / qs.execution_count
, qs.execution_count
, qt.text AS [Parent Query]
, DB_NAME(qt.dbid) AS DatabaseName
, qp.query_plan
FROM sys.dm_exec_query_stats qs
CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) as qt
CROSS APPLY sys.dm_exec_query_plan(qs.plan_handle) qp
-- ORDER BY [Total IO] DESC uzun surdugunden kapattim
RecordBycunay
Record Date08-09-2018 10:27:35
Düzenle
Kopyala
Sil