SELECT sch.name + '.' + t.name AS [Table Name], i.name AS[Index Name], i.type_desc, ISNULL(user_updates,0) AS [Total Writes], ISNULL(user_seeks +user_scans + user_lookups,0) AS [Total Reads], s.last_user_seek, s.last_user_scan , s.last_user_lookup, ISNULL(user_updates,0) - ISNULL((user_seeks+ user_scans +user_lookups),0)AS [Difference], p.reserved_page_count * 8.0 / 1024 as SpaceInMB FROM sys.indexes AS i WITH (NOLOCK) LEFT OUTERJOIN sys.dm_db_index_usage_statsAS s WITH (NOLOCK) ON s.object_id = i.object_id AND i.index_id = s.index_id AND s.database_id=db_id() AND objectproperty(s.object_id,'IsUserTable') = 1 INNER JOIN sys.tables AS t WITH (NOLOCK) ON i.object_id = t.object_id INNER JOIN sys.schemas AS sch WITH (NOLOCK) ON t.schema_id = sch.schema_id LEFT OUTERJOIN sys.dm_db_partition_stats AS p WITH (NOLOCK) ON i.index_id = p.index_id and i.object_id = p.object_id WHERE (1=1) --AND ISNULL(user_updates,0) >=ISNULL((user_seeks + user_scans + user_lookups),0) --shows all indexesincluding those that have not been used --AND ISNULL(user_updates,0) -ISNULL((user_seeks + user_scans + user_lookups),0)>0 --only shows thoseindexes which have been used --AND i.index_id > 1 -- Only non-first indexes (I.E.non-primary key) --AND i.is_primary_key<>1 -- Only those that are not defined asa Primary Key) --AND i.is_unique_constraint<>1-- Only those that are not classed as "UniqueConstraints". ORDER BY [Table Name],[index name]
免责声明:本站文章均来自网站采集或用户投稿,网站不提供任何软件下载或自行开发的软件!
如有用户或公司发现本站内容信息存在侵权行为,请邮件告知! 858582#qq.com
岱庙资源网 Copyright www.zgmyg.com
暂无“SQL语句实现查询Index使用状况”评论...
更新日志
2024年06月14日
2024年06月14日
- 群星.2001-1哥1姐·滚石2000年国台语双赢总霸主【滚石】【WAV+CUE】
- 林子祥《典藏版》DSD+SBM版[WAV+CUE][600MB]
- 林忆莲《忆情思莲》DSD+SBM版[WAV+CUE][600MB]
- 许嵩《许嵩歌曲合集》[FLAC/分轨][3.5G]
- 世界启元古埃及文明怎么样 古埃及文明选择推荐
- 世界启元穆兰怎么样 世界启元英雄穆兰介绍
- 世界启元尤里乌斯组队阵容大全 尤里乌斯配队推荐
- 群星-《女人40走过的岁月》SRS环绕音效2CD[WAV+CUE]
- 阿杜2005《IDo》[WAV+CUE]
- 阿杜.2018-《我不该躲》台湾首版[WAV+CUE]
- IGN《影之刃零》10分钟实机演示 动作流畅尽显华丽!
- 玩家震怒!IGN法国开团《黑神话:悟空》登贴吧热议榜
- 仅剩9小时:《黑神话》收藏版京东预约量已破41万!
- 翁倩玉.1971-鏡中的你【海山】【FLAC分轨】
- 王娟.2013-梦湖【树音乐】【WAV+CUE】