Documentation Index
Fetch the complete documentation index at: /llms.txt
Use this file to discover all available pages before exploring further.
Grant QueryComment read-only access to a self-hosted SQL Server instance.
USE master;
CREATE LOGIN querycomment WITH PASSWORD = 'replace-with-strong-password';
CREATE USER querycomment FOR LOGIN querycomment;
GRANT CONNECT ANY DATABASE TO querycomment;
GRANT VIEW SERVER STATE TO querycomment;
GRANT VIEW ANY DEFINITION TO querycomment;
VIEW SERVER PERFORMANCE STATE instead of VIEW SERVER STATE. The collector requires one of these server-state permissions to read statement statistics and query text.
querycomment login to a monitored database, then run:
SELECT TOP (1)
query_hash,
execution_count,
total_elapsed_time
FROM sys.dm_exec_query_stats;
SELECT TOP (1) sql_text.text
FROM sys.dm_exec_query_stats AS query_stats
CROSS APPLY sys.dm_exec_sql_text(query_stats.sql_handle) AS sql_text;