Ferramenta Dev7
Diagnóstico Rápido (SQL Server)

Cole o JSON gerado pelo script de leitura para obter um relatório técnico inicial com score, waits relevantes, queries filtradas e sugestões de índice.
Passo 1 — Copie e execute o script no seu SQL Server (somente leitura)

O script consulta apenas DMVs e retorna um JSON. Os dados ficam no seu navegador e não são enviados para servidores externos.
-- Dev7 Solucoes - Diagnostico Rapido SQL Server
-- Script somente leitura. Nao altera objetos, dados ou configuracoes.
SET NOCOUNT ON;

;WITH server_info AS (
    SELECT
        CAST(SERVERPROPERTY('ServerName') AS nvarchar(256)) AS server_name,
        CAST(SERVERPROPERTY('Edition') AS nvarchar(256)) AS edition,
        CAST(SERVERPROPERTY('ProductVersion') AS nvarchar(128)) AS product_version,
        CAST(si.sqlserver_start_time AS datetime2(0)) AS sqlserver_start_time,
        DATEDIFF(HOUR, si.sqlserver_start_time, SYSDATETIME()) AS uptime_hours
    FROM sys.dm_os_sys_info AS si
),
os_info AS (
    SELECT TOP (1)
        wi.windows_release,
        wi.windows_service_pack_level,
        wi.windows_sku,
        wi.os_language_version,
        CAST(si.sqlserver_start_time AS datetime2(0)) AS sqlserver_start_time
    FROM sys.dm_os_windows_info AS wi
    CROSS JOIN sys.dm_os_sys_info AS si
),
waits_filtered AS (
    SELECT TOP (50)
        ws.wait_type,
        ws.waiting_tasks_count,
        ws.wait_time_ms,
        ws.signal_wait_time_ms,
        (ws.wait_time_ms - ws.signal_wait_time_ms) AS resource_wait_time_ms
    FROM sys.dm_os_wait_stats AS ws
    WHERE ws.wait_time_ms > 0
      AND ws.wait_type NOT LIKE 'SLEEP%'
      AND ws.wait_type NOT LIKE 'QDS_%'
      AND ws.wait_type NOT LIKE 'XE_%'
      AND ws.wait_type NOT IN (
            'SOS_WORK_DISPATCHER',
            'ONDEMAND_TASK_QUEUE',
            'SQLTRACE_INCREMENTAL_FLUSH_SLEEP',
            'DIRTY_PAGE_POLL',
            'PWAIT_ALL_COMPONENTS_INITIALIZED',
            'LAZYWRITER_SLEEP',
            'CHECKPOINT_QUEUE',
            'SP_SERVER_DIAGNOSTICS_SLEEP',
            'LOGMGR_QUEUE',
            'CLR_AUTO_EVENT',
            'DISPATCHER_QUEUE_SEMAPHORE',
            'REQUEST_FOR_DEADLOCK_SEARCH'
      )
    ORDER BY ws.wait_time_ms DESC
),
queries_ranked AS (
    SELECT TOP (50)
        DB_NAME(CONVERT(int, pa.value)) AS database_name,
        CAST(qs.query_hash AS varbinary(8)) AS query_hash,
        qs.execution_count,
        CAST(qs.total_elapsed_time / 1000.0 AS decimal(19,2)) AS total_elapsed_ms,
        CAST(qs.total_worker_time / 1000.0 AS decimal(19,2)) AS total_cpu_ms,
        qs.total_logical_reads,
        qs.last_execution_time,
        CAST(st.text AS nvarchar(max)) AS query_text
    FROM sys.dm_exec_query_stats AS qs
    CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) AS st
    OUTER APPLY sys.dm_exec_plan_attributes(qs.plan_handle) AS pa
    WHERE pa.attribute = 'dbid'
    ORDER BY qs.total_elapsed_time DESC
),
missing_indexes_ranked AS (
    SELECT TOP (50)
        DB_NAME(mid.database_id) AS database_name,
        OBJECT_SCHEMA_NAME(mid.object_id, mid.database_id) AS schema_name,
        OBJECT_NAME(mid.object_id, mid.database_id) AS table_name,
        mid.statement,
        mid.equality_columns,
        mid.inequality_columns,
        mid.included_columns,
        migs.user_seeks,
        migs.user_scans,
        CAST(migs.avg_total_user_cost AS decimal(19,2)) AS avg_total_user_cost,
        CAST(migs.avg_user_impact AS decimal(19,2)) AS avg_user_impact,
        CAST(
            (migs.user_seeks + migs.user_scans)
            * migs.avg_total_user_cost
            * (migs.avg_user_impact / 100.0) AS decimal(19,2)
        ) AS score
    FROM sys.dm_db_missing_index_group_stats AS migs
    INNER JOIN sys.dm_db_missing_index_groups AS mig
        ON migs.group_handle = mig.index_group_handle
    INNER JOIN sys.dm_db_missing_index_details AS mid
        ON mig.index_handle = mid.index_handle
    ORDER BY score DESC
),
files_master AS (
    SELECT
        DB_NAME(mf.database_id) AS database_name,
        mf.name AS logical_name,
        mf.physical_name,
        mf.type_desc,
        CAST(mf.size * 8.0 / 1024 AS decimal(19,2)) AS size_mb,
        CAST(mf.max_size * 8.0 / 1024 AS decimal(19,2)) AS max_size_mb,
        mf.is_percent_growth,
        mf.growth
    FROM sys.master_files AS mf
),
files_tempdb AS (
    SELECT
        df.name AS logical_name,
        df.physical_name,
        df.type_desc,
        CAST(df.size * 8.0 / 1024 AS decimal(19,2)) AS size_mb,
        CAST(df.max_size * 8.0 / 1024 AS decimal(19,2)) AS max_size_mb,
        df.is_percent_growth,
        df.growth
    FROM tempdb.sys.database_files AS df
)
SELECT
(
    SELECT
        (SELECT * FROM server_info FOR JSON PATH, WITHOUT_ARRAY_WRAPPER) AS server,
        (SELECT * FROM os_info FOR JSON PATH, WITHOUT_ARRAY_WRAPPER) AS os,
        (SELECT * FROM waits_filtered FOR JSON PATH) AS waits_top,
        (SELECT * FROM queries_ranked FOR JSON PATH) AS top_queries,
        (SELECT * FROM missing_indexes_ranked FOR JSON PATH) AS missing_indexes,
        (SELECT * FROM files_master FOR JSON PATH) AS db_files,
        (SELECT * FROM files_tempdb FOR JSON PATH) AS tempdb_files
    FOR JSON PATH, WITHOUT_ARRAY_WRAPPER
) AS diagnostico_json;
Diagnóstico Rápido (SQL Server)

Passo 1 — Copie e execute o script no seu SQL Server (somente leitura)

Passo 2 — Cole aqui o JSON gerado
