푸팟퐁쿼리

SELECT OBJECT_SCHEMA_NAME(a2.object_id) AS SchemaName, a2.name AS TableName, a1.rows as [RowCount], CAST(ROUND(((a1.reserved + ISNULL(a4.reserved,0)) * 8) / 1024.00 / 1024.00, 2) AS NUMERIC(36, 2)) AS ReservedSize_GB, CAST(ROUND(a1.data * 8 / 1024.00 / 1024.00 , 2) AS NUMERIC(36, 2)) AS DataSize_GB, CAST(ROUND((CASE WHEN (a1.used + ISNULL(a4.used,0)) > a1.data THEN (a1.used + ISNULL(a4.used,0)) ..

SELECT TOP 50 query_stats.query_hash AS 'Query Hash', SUM(query_stats.total_worker_time) / SUM(query_stats.execution_count) AS 'Avg CPU Time', SUM(query_stats.total_logical_reads) / SUM(query_stats.execution_count) AS 'Avg logical Read', SUM(query_stats.total_worker_time) / SUM(query_stats.execution_count) AS 'Avg Worker time', MIN(query_stats.statement_text) AS 'Statement Text', MIN(DB_NAME(que..

1. 특정 DB 안에서만 찾을 경우 SELECT OBJECT_NAME(object_id), OBJECT_DEFINITION(object_id) FROM sys.procedures WHERE OBJECT_DEFINITION(object_id) LIKE '%MERGE%' 2. 장비 내에 모든 DB 대상으로 찾을 경우 DROP TABLE IF EXISTS #TblSearchProcedure GO SELECT TOP 0 OBJECT_NAME(object_id) AS _object_name, OBJECT_DEFINITION(object_id) as _object_definition INTO #TblSearchProcedure FROM sys.procedures WHERE OBJECT_DEFINITION(objec..

drop table if exists dbo.Event_Data go select n.value('(@timestamp)[1]', 'datetime2') AS [utc_timestamp], n.value('(action[@name="sql_text"]/value)[1]', 'nvarchar(2000)') as sql_text, ISNULL(n.value('(action[@name="batch_text"]/value)[1]', 'nvarchar(100)'),'') as batch_text, n.value('(action[@name="client_app_name"]/value)[1]', 'nvarchar(100)') as client_app_name, n.value('(action[@name="client_..

SELECT sqltext.TEXT, req.session_id, req.status, req.command, req.cpu_time, req.total_elapsed_time, DB_NAME(database_id) AS dbName FROM sys.dm_exec_requests req CROSS APPLY sys.dm_exec_sql_text(sql_handle) AS sqltext