SQLSERVER 查表得读写次数

SQLSERVER 表读写比例查询

最新推荐文章于 2023-04-10 17:26:54 发布

原创

最新推荐文章于 2023-04-10 17:26:54 发布 · 1.8k 阅读

1 ·

CC 4.0 BY-SA版权

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

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 W