[MSSQL] 실행 쿼리 이력 조회
admin 계정으로 실행. SELECT TOP 1000 DB_NAME(ST.DBID) DBNAME , OBJECT_SCHEMA_NAME(OBJECTID, ST.DBID) SCHEMANAME , OBJECT_NAME(OBJECTID, ST.DBID) SPNAME , TEXT , QS.last_worker_time , QS.execution_count , CREATION_TIME , LAST_EXECUTION_TIME , QS.max_worker_time , QS.min_worker_time , QS.total_worker_time , QS.TOTAL_ELAPSED_TIME FROM SYS.DM_EXEC_QUERY_STATS QS CROSS APPLY SYS.DM_EXEC_SQL_TEXT(QS.plan_ha..
2023. 7. 5.