SQLSERVER 查表得读写次数

Foliole

于 2018-11-23 11:24:13 发布

阅读量1.7k

点赞数

CC 4.0 BY-SA版权

分类专栏： SQLServer经验总结

本文链接：https://blog.youkuaiyun.com/xiaoye1202/article/details/84379211

该查询展示了SQLSERVER中特定表（'tablename'）的读写操作次数，包括读操作的比例、写操作的比例、总读操作数和总写操作数。通过sys.dm_db_index_usage_stats和sys.indexes系统视图进行统计。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

SELECT OBJECT_SCHEMA_NAME(ddius.object_id) + '.' + OBJECT_NAME(ddius.object_id) AS [Object Name],
CASE WHEN (SUM(user_updates + user_seeks + user_scans + user_lookups)=0) THEN NULL
ELSE CONVERT(DECIMAL(38,2),CAST(SUM(user_seeks + user_scans + user_lookups) AS DECIMAL)
/ CAST(SUM(user_updates + user_seeks + user_scans + user_lookups) AS DECIMAL))
END AS [Proportion of Reads],
CASE WHEN (SUM(user_updates + user_seeks + user_scans + user_lookups)=0) THEN NULL
ELSE CONVERT(DECIMAL(38,2),CAST(SUM(user_updates) AS DECIMAL)
/ CAST(SUM(user_updates + user_seeks + user_scans + user_lookups) AS DECIMAL))
END AS [Proportion of Writes],SUM(user_seeks + user_scans + user_lookups) AS [Total Read Operations],
SUM(user_updates) AS [Total Write Operations]

最低0.47元/天解锁文章