All DMV/DMF and Catalog Views

From http://technet.microsoft.com/en-us/library/ms188754.aspx

1.AlwaysOn Availability Group Dynamic Management Views and Functions

sys.dm_hadr_auto_page_repair
sys.dm_hadr_cluster_networks
sys.dm_hadr_availability_group_states
sys.dm_hadr_database_replica_cluster_states
sys.dm_hadr_availability_replica_cluster_nodes
sys.dm_hadr_database_replica_states
sys.dm_hadr_availability_replica_cluster_states
sys.dm_hadr_instance_node_map
sys.dm_hadr_availability_replica_states
sys.dm_hadr_name_id_map
sys.dm_hadr_cluster
sys.dm_tcp_listener_states
sys.dm_hadr_cluster_members

2.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_group_stats
sys.dm_db_missing_index_groups

3.Change Data Capture Related Dynamic Management Views
sys.dm_cdc_log_scan_sessions
sys.dm_cdc_errors
sys.dm_repl_traninfo

4.I/O Related Dynamic Management Views and Functions
sys.dm_io_backup_tapes
sys.dm_io_cluster_shared_drives
sys.dm_io_pending_io_requests
sys.dm_io_virtual_file_stats

5.Change Tracking Related Dynamic Management Views
sys.dm_tran_commit_table

6.Object Related Dynamic Management Views and Functions
sys.dm_sql_referenced_entities
sys.dm_sql_referencing_entities
sys.dm_db_stats_properties

7.Common Language Runtime Related Dynamic Management Views

sys.dm_clr_appdomains
sys.dm_clr_loaded_assemblies
sys.dm_clr_properties
sys.dm_clr_tasks

8.Query Notifications Related Dynamic Management Views
sys.dm_qn_subscriptions

9.Database Mirroring Related Dynamic Management Views
sys.dm_db_mirroring_connections
sys.dm_db_mirroring_auto_page_repair

10.Replication Related Dynamic Management Views
sys.dm_repl_articles
sys.dm_repl_schemas
sys.dm_repl_tranhash
sys.dm_repl_traninfo

11.Database Related Dynamic Management Views
sys.dm_db_file_space_usage
sys.dm_db_fts_index_physical_stats
sys.dm_db_partition_stats
sys.dm_db_persisted_sku_features
sys.dm_db_session_space_usage
sys.dm_db_task_space_usage
sys.dm_db_uncontained_entities

12.Resource Governor Dynamic Management Views
sys.dm_resource_governor_configuration
sys.dm_resource_governor_workload_groups
sys.dm_resource_governor_resource_pools

13.Execution Related Dynamic Management Views and Functions
sys.dm_exec_background_job_queue
sys.dm_exec_query_memory_grants
sys.dm_exec_background_job_queue
sys.dm_exec_query_optimizer_info
sys.dm_exec_background_job_queue_stats
sys.dm_exec_query_plan
sys.dm_exec_cached_plans
sys.dm_exec_query_resource_semaphores
sys.dm_exec_cached_plan_dependent_objects
sys.dm_exec_query_stats
sys.dm_exec_connections
sys.dm_exec_requests
sys.dm_exec_cursors
sys.dm_exec_sessions
sys.dm_exec_describe_first_result_set
sys.dm_exec_sql_text
sys.dm_exec_describe_first_result_set_for_object
sys.dm_exec_text_query_plan
sys.dm_exec_plan_attributes
sys.dm_exec_trigger_stats
sys.dm_exec_procedure_stats
sys.dm_exec_xml_handles

14.Security Related Dynamic Management Views
sys.dm_audit_actions
sys.dm_cryptographic_provider_properties
sys.dm_audit_class_type_map
sys.dm_cryptographic_provider_sessions
sys.dm_cryptographic_provider_algorithms
sys.dm_database_encryption_keys
sys.dm_cryptographic_provider_keys
sys.dm_server_audit_status

15.Extended Events Dynamic Management Views
sys.dm_xe_map_values
sys.dm_xe_session_events
sys.dm_xe_object_columns
sys.dm_xe_session_object_columns
sys.dm_xe_objects
sys.dm_xe_session_targets
sys.dm_xe_packages
sys.dm_xe_sessions
sys.dm_xe_session_event_actions

16.Service Broker Related Dynamic Management Views
sys.dm_broker_activated_tasks
sys.dm_broker_connections
sys.dm_broker_forwarded_messages
sys.dm_broker_queue_monitors

17.Filestream and FileTable Dynamic Management Views

sys.dm_filestream_file_io_handles --Displays the currently open transactional file handles.
sys.dm_filestream_file_io_requests --Displays current file input and file output requests.
sys.dm_filestream_non_transacted_handles --Displays the currently open non-transactional file handles to FileTable data.

18.SQL Server Operating System Related Dynamic Management Views
sys.dm_os_buffer_descriptors
sys.dm_os_memory_pools
sys.dm_os_child_instances
sys.dm_os_nodes
sys.dm_os_cluster_nodes
sys.dm_os_performance_counters
sys.dm_os_dispatcher_pools
sys.dm_os_process_memory
sys.dm_os_hosts
sys.dm_os_schedulers
sys.dm_os_latch_stats
sys.dm_os_stacks
sys.dm_os_loaded_modules
sys.dm_os_sys_info
sys.dm_os_memory_brokers
sys.dm_os_sys_memory
sys.dm_os_memory_cache_clock_hands
sys.dm_os_tasks
sys.dm_os_memory_cache_counters
sys.dm_os_threads
sys.dm_os_memory_cache_entries
sys.dm_os_virtual_address_dump
sys.dm_os_memory_cache_hash_tables
sys.dm_os_volume_stats
sys.dm_os_memory_clerks
sys.dm_os_wait_stats
sys.dm_os_memory_nodes
sys.dm_os_waiting_tasks
sys.dm_os_memory_objects
sys.dm_os_windows_info
sys.dm_os_workers

19.Full-Text Search and Semantic Search Dynamic Management Views

sys.dm_fts_active_catalogs
Returns information on the full-text catalogs that have some population activity in progress on the server.

sys.dm_fts_fdhosts
Returns information on the current activity of the filter daemon host or hosts on the server instance.

sys.dm_fts_index_keywords_by_document
Returns information about the document-level content of a full-text index for the specified table. A given keyword can appear in several documents.

sys.dm_fts_index_keywords_by_property
Returns all property-related content in the full-text index of a given table. This includes all data that belongs to any property registered by the search property list associated with that full-text index.

sys.dm_fts_index_keywords
Returns information about the content of a full-text index for the specified table.

sys.dm_fts_index_population
Returns information about the full-text index populations currently in progress.

sys.dm_fts_memory_buffers
Returns information about memory buffers belonging to a specific memory pool that are used as part of a full-text crawl or a full-text crawl range.

sys.dm_fts_memory_pools
Returns information about the shared memory pools available to the Full-Text Gatherer component for a full-text crawl or a full-text crawl range.

sys.dm_fts_outstanding_batches
Returns information about each full-text indexing batch.

sys.dm_fts_parser
Returns the final tokenization result after applying a given word breaker, thesaurus, and stoplist combination to a query string input. The output is equivalent to the output if the specified given query string were issued to the Full-Text Engine.

sys.dm_fts_population_ranges
Returns information about the specific ranges related to a full-text index population currently in progress.

sys.dm_fts_semantic_similarity_population
Returns one row of status information about the population of the document similarity index for each similarity index in each table that has an associated semantic index.

20.Transaction Related Dynamic Management Views and Functions

sys.dm_tran_active_snapshot_database_transactions
sys.dm_tran_active_transactions
sys.dm_tran_current_snapshot
sys.dm_tran_current_transaction
sys.dm_tran_database_transactions
sys.dm_tran_locks
sys.dm_tran_session_transactions
sys.dm_tran_top_version_generators
sys.dm_tran_transactions_snapshot
sys.dm_tran_version_store

 

 

From http://technet.microsoft.com/en-us/library/ms173772.aspx
1.AlwaysOn Availability Group Catalog Views

 

sys.availability_databases_cluster
sys.availability_groups_cluster
sys.availability_group_listener_ip_addresses
sys.availability_read_only_routing_lists
sys.availability_group_listeners
sys.availability_replicas
sys.availability_groups

 

2.Linked Servers Catalog Views
sys.linked_logins
sys.servers
sys.remote_logins

 

3.Change Tracking Catalog Views
sys.change_tracking_databases
sys.change_tracking_tables

 

4.Messages (For Errors) Catalog Views
sys.messages

5.CLR Assembly Catalog Views
sys.assemblies
sys.assembly_references
sys.assembly_files

 

6.Object Catalog Views
sys.allocation_units
sys.parameters
sys.assembly_modules
sys.partitions
sys.check_constraints
sys.procedures
sys.columns
sys.sequences
sys.computed_columns
sys.service_queues
sys.default_constraints
sys.sql_dependencies
sys.events
sys.sql_expression_dependencies
sys.event_notifications
sys.sql_modules
sys.extended_procedures
sys.stats
sys.foreign_key_columns
sys.stats_columns
sys.foreign_keys
sys.synonyms
sys.function_order_columns
sys.table_types
sys.identity_columns
sys.tables
sys.index_columns
sys.trigger_event_types
sys.indexes
sys.trigger_events
sys.key_constraints
sys.triggers
sys.numbered_procedure_parameters
sys.views
sys.numbered_procedures
sys.objects

 

7.Databases and Files Catalog Views
sys.backup_devices
sys.database_files
sys.database_mirroring
sys.database_recovery_status
sys.databases
sys.master_files

 

8.Partition Function Catalog Views
sys.partition_functions
sys.partition_range_values
sys.partition_parameters

 

9.Database Mail Views
sysmail_allitems
sysmail_mailattachments
sysmail_event_log
sysmail_sentitems
sysmail_faileditems
sysmail_unsentitems

 

10.Policy-Based Management Views
syspolicy_conditions
syspolicy_policy_group_subscriptions
syspolicy_policies
syspolicy_policy_groups
syspolicy_policy_execution_history
syspolicy_system_health_state
syspolicy_policy_execution_history_details

 

11.Database Mirroring Catalog Views
sys.database_mirroring_witnesses .

 

12.Resource Governor Catalog Views
sys.resource_governor_configuration
sys.resource_governor_workload_groups
sys.resource_governor_resource_pools

 

13.Data Collector Views
syscollector_collection_items
syscollector_collection_sets
syscollector_collector_types
syscollector_config_store
syscollector_execution_log
syscollector_execution_log_full
syscollector_execution_stats

 

14.Scalar Types Catalog Views
sys.assembly_types
sys.types

 

15.Data Spaces
sys.data_spaces
sys.filegroups
sys.destination_data_spaces
sys.partition_schemes

 

16.Schemas Catalog Views
sys.schemas

 

17.Endpoints Catalog Views
sys.database_mirroring_endpoints
sys.service_broker_endpoints
sys.endpoints
sys.soap_endpoints
sys.endpoint_webmethods
sys.tcp_endpoints
sys.http_endpoints

 

18.Security Catalog Views

 

Database-Level Views
sys.database_permissions
sys.database_role_members
sys.database_principals
sys.master_key_passwords
Server-Level Views
sys.server_permissions
sys.sql_logins
sys.server_principals
sys.system_components_surface_area_configuration
sys.server_role_members
Encryption Views
sys.asymmetric_keys
sys.crypt_properties
sys.certificates
sys.key_encryptions
sys.credentials
sys.symmetric_keys
sys.cryptographic_providers
SQL Server Audit Views
sys.server_audits
sys.server_file_audits
sys.server_audit_specifications
sys.server_audit_specification_details
sys.database_audit_specifications
sys.database_audit_specification_details _specification_details

 

19.Extended Events Catalog Views
sys.server_event_sessions
sys.server_event_session_fields
sys.server_event_session_actions
sys.server_event_session_targets
sys.server_event_session_events

 

20.Service Broker Catalog Views
sys.conversation_endpoints
sys.service_contract_usages
sys.conversation_groups
sys.service_contracts
sys.conversation_priorities
sys.service_message_types
sys.message_type_xml_schema_collection_usages
sys.service_queue_usages
sys.remote_service_bindings
sys.service_queues
sys.routes
sys.services
sys.service_contract_message_usages
sys.transmission_queue

 

21.Extended Properties Catalog Views
sys.extended_properties

 

22.Server-wide Configuration Catalog Views
sys.configurations
sys.trace_columns
sys.fulltext_languages
sys.trace_events
sys.traces
sys.trace_event_bindings
sys.trace_categories
sys.trace_subclass_values

 

23.FileTable Catalog Views

 

sys.database_filestream_options
Displays information about the level of non-transactional access to FILESTREAM data in FileTables that is enabled. Contains one row for each database in the SQL Server instance.

 

sys.filetable_system_defined_objects
Displays a list of the system-defined objects that are related to FileTables. Contains one row for each system-defined object.

 

sys.filetables
Returns a row for each FileTable. Inherits from sys.tables.

 

24.XML Schemas (XML Type System) Catalog Views
sys.column_xml_schema_collection_usage
sys.parameter_xml_schema_collection_usages
sys.selective_xml_index_paths
sys.xml_schema_attributes
sys.xml_schema_model_groups
sys.xml_schema_component_placements
sys.xml_schema_collections
sys.xml_schema_components
sys.xml_schema_namespaces
sys.xml_schema_elements
sys.xml_schema_types
sys.xml_schema_facets
sys.xml_schema_wildcard_namespaces
sys.xml_indexes
sys.xml_schema_wildcards

 

25.Full-Text Search and Semantic Search Catalog Views

 

sys.fulltext_catalogs
Contains a row for each full-text catalog.

 

sys.fulltext_document_types
Returns a row for each document type that is available for full-text indexing operations. Each row represents the IFilter interface that is registered in the instance of SQL Server.

 

sys.fulltext_index_catalog_usages
Returns a row for each full-text catalog to full-text index reference.

 

sys.fulltext_index_columns
Contains a row for each column that is part of a full-text index.

 

sys.fulltext_index_fragments
Contains a row for each full-text index fragment in every table that contains a full-text index.

 

sys.fulltext_indexes
Contains a row per full-text index of a tabular object.

 

sys.fulltext_languages
Contains one row per language whose word breakers are registered with SQL Server. Each row displays the LCID and name of the language.
sys.fulltext_stoplists
Contains a row per full-text stoplist in the database.

 

sys.fulltext_stopwords
Contains a row per stopword for all stoplists in the database.

 

sys.fulltext_system_stopwords
Provides access to the system stoplist.

 

sys.registered_search_properties
Contains a row for each search property contained by any search property list on the current database.

 

sys.registered_search_property_lists
Contains a row for each search property list on the current database.

 

sys.fulltext_semantic_language_statistics_database
Returns a row about the semantic language statistics database installed on the current instance of SQL Server.

 

sys.fulltext_semantic_languages
Returns a row for each language whose statistics model is registered with the instance of SQL Server. When a language model is registered, that language is enabled for semantic indexing.