该查询展示了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
最低0.47元/天 解锁文章
扫一扫
08-18
8236
8236
09-30
2210
2210
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
