SQL 2008 has now been fully released for just over a month, and for those who have not been keeping track of additions throughout the CTPs and Release Candidates, here is a bit of useful information: SQL 2008 has 46 new DMVs(as of version 10.0.1442).

If you have a 2005 instance on your box along side your 2008 install, you can run this from your 2008 instance query to take a look at the output:

select name fromsys.all_objectswhere name like'dm_%'

except

select name from [localhost\sql2005instance].master.sys.all_objectswhere name like'dm_%'

Several of these DMVs correspond directly to feature additions such as Filestream, new cryptography features and resource governor, plus several that give more insight into the host OS.

Here is the complete list if you don't have a 2005 instance handy:

dm_audit_actions

dm_audit_class_type_map

dm_cdc_errors

dm_cdc_log_scan_sessions

dm_cryptographic_provider_algorithms

dm_cryptographic_provider_keys

dm_cryptographic_provider_properties

dm_cryptographic_provider_sessions

dm_database_encryption_keys

dm_db_mirroring_auto_page_repair

dm_db_mirroring_past_actions

dm_db_persisted_sku_features

dm_exec_procedure_stats

dm_exec_trigger_stats

dm_filestream_file_io_handles

dm_filestream_file_io_requests

dm_fts_fdhosts

dm_fts_index_keywords

dm_fts_index_keywords_by_document

dm_fts_outstanding_batches

dm_fts_parser

dm_os_dispatcher_pools

dm_os_dispatchers

dm_os_memory_brokers

dm_os_memory_node_access_stats

dm_os_memory_nodes

dm_os_nodes

dm_os_process_memory

dm_os_spinlock_stats

dm_os_sys_memory

dm_resource_governor_configuration

dm_resource_governor_resource_pools

dm_resource_governor_workload_groups

dm_server_audit_status

dm_sql_referenced_entities

dm_sql_referencing_entities

dm_tran_commit_table

dm_xe_map_values

dm_xe_object_columns

dm_xe_objects

dm_xe_packages

dm_xe_session_event_actions

dm_xe_session_events

dm_xe_session_object_columns

dm_xe_session_targets

dm_xe_sessions