United States (English)

Home Library Learn Samples Downloads Support Community Forums

MSDN Library

Servers and Enterprise Development

SQL Server

SQL Server 2005

Product Documentation

SQL Server 2005 Documentation

SQL Server 2005 Books Online

SQL Server Language Reference

Transact-SQL Reference

System Views (Transact-SQL)

Dynamic Management Views and Functions

Index-Related Dynamic Management Views and Functions

sys.dm_db_index_operational_stats

sys.dm_db_index_physical_stats

sys.dm_db_index_usage_stats

sys.dm_db_missing_index_columns

sys.dm_db_missing_index_details

sys.dm_db_missing_index_groups

sys.dm_db_missing_index_group_stats

Minimize

0 out of 1 rated this helpful - Rate this topic

Index-Related Dynamic Management Views and Functions

SQL Server 2005

This section contains the following dynamic management objects.

sys.dm_db_index_operational_stats	sys.dm_db_index_physical_stats
sys.dm_db_index_usage_stats	sys.dm_db_missing_index_columns
sys.dm_db_missing_index_details	sys.dm_db_missing_index_group_stats
sys.dm_db_missing_index_groups

Reference

Dynamic Management Views and Functions
Dynamic Management Views and Functions
System Views (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

© 2013 Microsoft. All rights reserved.