查看 SQL server的慢查询SQL

SELECT TOP 100
    qs.total_worker_time / 1000 AS [Total CPU Time (ms)],
    qs.execution_count AS [Execution Count],
    qs.total_worker_time / qs.execution_count / 1000 AS [Average CPU Time (ms)],
    qs.last_execution_time AS [Last Execution Time],
    qs.max_worker_time / 1000 AS [Max CPU Time (ms)],
    SUBSTRING(qt.text, qs.statement_start_offset / 2 + 1,
        (CASE WHEN qs.statement_end_offset = -1 THEN DATALENGTH(qt.text)
            ELSE qs.statement_end_offset END - qs.statement_start_offset) / 2 + 1) AS [Query Text],
    qt.text AS [Complete Query Text],
    DB_NAME(qt.dbid) AS [Database Name],
    OBJECT_NAME(qt.objectid, qt.dbid) AS [Object Name]
FROM sys.dm_exec_query_stats qs WITH (NOLOCK)
CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) AS qt
WHERE 
    qs.execution_count > 1
    AND qt.dbid = DB_ID('big_data') -- 替换为你的数据库名称
ORDER BY qs.total_worker_time DESC;

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值