푸팟퐁쿼리

1. Machine Name 2. Instance Name 3. Server Name 4. Service Port 5. Service Account 6. Collation 7. Data Root Directory 8. CPU / Memory Spec 9. DBMS Version 위 메타 정보를 조회하는 쿼리입니다. DECLARE @HkeyLocal NVARCHAR(18) DECLARE @Instance1 VARCHAR(100) DECLARE @Instance2 VARCHAR(100) DECLARE @MSSqlServerRegPath NVARCHAR(200) DECLARE @PortNumber NVARCHAR(100) DECLARE @SQLDataRoot NVARCHAR(100) DECLARE @SQLPa..

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..