What's new in Denali CTP3, DMV-wise?

August 7, 2011 22:33 by Matt Whitfield

Ok, so for researching what's new in Denali CTP3, and therefore what schema inspector has to cope with, I have had to look at the DMV differences between CTP3 and 2008. So, here's a summary of the differences. I'm not going to replicate BOL here, just provide a simple lookup for 'what's new?'.

So, DMVs that are in Denali CTP3 but not 2008:

  • [sys].[availability_group_listener_ip_addresses]
  • [sys].[availability_group_listeners]
  • [sys].[availability_groups]
  • [sys].[availability_read_only_routing_lists]
  • [sys].[availability_replicas]
  • [sys].[column_store_dictionaries]
  • [sys].[column_store_index_stats]
  • [sys].[column_store_segments]
  • [sys].[database_filestream_options]
  • [sys].[dm_db_fts_index_physical_stats]
  • [sys].[dm_db_log_space_usage]
  • [sys].[dm_db_uncontained_entities]
  • [sys].[dm_filestream_non_transacted_handles]
  • [sys].[dm_fts_semantic_similarity_population]
  • [sys].[dm_hadr_auto_page_repair]
  • [sys].[dm_hadr_availability_group_states]
  • [sys].[dm_hadr_availability_replica_states]
  • [sys].[dm_hadr_cluster]
  • [sys].[dm_hadr_cluster_members]
  • [sys].[dm_hadr_cluster_networks]
  • [sys].[dm_hadr_database_replica_cluster_states]
  • [sys].[dm_hadr_database_replica_states]
  • [sys].[dm_hadr_instance_node_map]
  • [sys].[dm_hadr_name_id_map]
  • [sys].[dm_logpool_hashentries]
  • [sys].[dm_logpool_stats]
  • [sys].[dm_os_cluster_properties]
  • [sys].[dm_os_memory_broker_clerks]
  • [sys].[dm_os_server_diagnostics_log_configurations]
  • [sys].[dm_os_windows_info]
  • [sys].[dm_server_memory_dumps]
  • [sys].[dm_server_registry]
  • [sys].[dm_server_services]
  • [sys].[dm_tcp_listener_states]
  • [sys].[filetable_system_defined_objects]
  • [sys].[filetables]
  • [sys].[fulltext_semantic_language_statistics_database]
  • [sys].[fulltext_semantic_languages]
  • [sys].[registered_search_properties]
  • [sys].[registered_search_property_lists]
  • [sys].[sequences]

DMVs that are in 2008 but not Denali CTP3:

  • [sys].[database_principal_aliases]

DMVs columns that are in Denali CTP3 but not 2008:

  • [sys].[change_tracking_databases].[max_cleanup_version]
  • [sys].[data_spaces].[is_system]
  • [sys].[database_principals].[authentication_type]
  • [sys].[database_principals].[authentication_type_desc]
  • [sys].[database_principals].[default_language_lcid]
  • [sys].[database_principals].[default_language_name]
  • [sys].[databases].[containment]
  • [sys].[databases].[containment_desc]
  • [sys].[databases].[default_fulltext_language_lcid]
  • [sys].[databases].[default_fulltext_language_name]
  • [sys].[databases].[default_language_lcid]
  • [sys].[databases].[default_language_name]
  • [sys].[databases].[group_database_id]
  • [sys].[databases].[is_nested_triggers_on]
  • [sys].[databases].[is_transform_noise_words_on]
  • [sys].[databases].[replica_id]
  • [sys].[databases].[target_recovery_time_in_seconds]
  • [sys].[databases].[two_digit_year_cutoff]
  • [sys].[dm_clr_appdomains].[compatibility_level]
  • [sys].[dm_clr_appdomains].[survived_memory_kb]
  • [sys].[dm_clr_appdomains].[total_allocated_memory_kb]
  • [sys].[dm_clr_appdomains].[total_processor_time_ms]
  • [sys].[dm_database_encryption_keys].[encryptor_type]
  • [sys].[dm_db_file_space_usage].[allocated_extent_page_count]
  • [sys].[dm_db_file_space_usage].[filegroup_id]
  • [sys].[dm_db_file_space_usage].[total_page_count]
  • [sys].[dm_db_task_space_usage].[is_remote_task]
  • [sys].[dm_db_task_space_usage].[task_address]
  • [sys].[dm_exec_cached_plans].[parent_plan_handle]
  • [sys].[dm_exec_query_stats].[last_rows]
  • [sys].[dm_exec_query_stats].[max_rows]
  • [sys].[dm_exec_query_stats].[min_rows]
  • [sys].[dm_exec_query_stats].[total_rows]
  • [sys].[dm_exec_sessions].[authenticating_database_id]
  • [sys].[dm_exec_sessions].[database_id]
  • [sys].[dm_exec_sessions].[open_transaction_count]
  • [sys].[dm_os_buffer_descriptors].[read_microsec]
  • [sys].[dm_os_cluster_nodes].[is_current_owner]
  • [sys].[dm_os_cluster_nodes].[status]
  • [sys].[dm_os_cluster_nodes].[status_description]
  • [sys].[dm_os_memory_cache_counters].[pages_in_use_kb]
  • [sys].[dm_os_memory_cache_counters].[pages_kb]
  • [sys].[dm_os_memory_cache_entries].[pages_kb]
  • [sys].[dm_os_memory_clerks].[page_size_in_bytes]
  • [sys].[dm_os_memory_clerks].[pages_kb]
  • [sys].[dm_os_memory_nodes].[cpu_affinity_mask]
  • [sys].[dm_os_memory_nodes].[foreign_committed_kb]
  • [sys].[dm_os_memory_nodes].[online_scheduler_mask]
  • [sys].[dm_os_memory_nodes].[pages_kb]
  • [sys].[dm_os_memory_nodes].[processor_group]
  • [sys].[dm_os_memory_objects].[max_pages_in_bytes]
  • [sys].[dm_os_memory_objects].[pages_in_bytes]
  • [sys].[dm_os_nodes].[online_scheduler_mask]
  • [sys].[dm_os_nodes].[processor_group]
  • [sys].[dm_os_sys_info].[affinity_type]
  • [sys].[dm_os_sys_info].[affinity_type_desc]
  • [sys].[dm_os_sys_info].[committed_kb]
  • [sys].[dm_os_sys_info].[committed_target_kb]
  • [sys].[dm_os_sys_info].[physical_memory_kb]
  • [sys].[dm_os_sys_info].[process_kernel_time_ms]
  • [sys].[dm_os_sys_info].[process_user_time_ms]
  • [sys].[dm_os_sys_info].[time_source]
  • [sys].[dm_os_sys_info].[time_source_desc]
  • [sys].[dm_os_sys_info].[virtual_machine_type]
  • [sys].[dm_os_sys_info].[virtual_machine_type_desc]
  • [sys].[dm_os_sys_info].[virtual_memory_kb]
  • [sys].[dm_os_sys_info].[visible_target_kb]
  • [sys].[dm_os_threads].[processor_group]
  • [sys].[dm_os_worker_local_storage].[federatedxact_address]
  • [sys].[dm_os_worker_local_storage].[query_driver_address]
  • [sys].[dm_os_workers].[processor_group]
  • [sys].[dm_tran_session_transactions].[open_transaction_count]
  • [sys].[filegroups].[is_system]
  • [sys].[fulltext_index_columns].[statistical_semantics]
  • [sys].[fulltext_indexes].[property_list_id]
  • [sys].[partition_functions].[is_system]
  • [sys].[partition_schemes].[is_system]
  • [sys].[server_audits].[predicate]
  • [sys].[server_event_session_events].[predicate_xml]
  • [sys].[server_file_audits].[max_files]
  • [sys].[server_file_audits].[predicate]
  • [sys].[server_principals].[is_fixed_role]
  • [sys].[server_principals].[owning_principal_id]
  • [sys].[server_trigger_events].[is_trigger_event]
  • [sys].[service_queues].[is_poison_message_handling_enabled]
  • [sys].[stats].[is_temporary]
  • [sys].[system_internals_partition_columns].[default_value]
  • [sys].[system_internals_partition_columns].[has_default]
  • [sys].[system_internals_partitions].[is_sereplicated]
  • [sys].[tables].[is_filetable]
  • [sys].[trigger_events].[is_trigger_event]

DMVs columns that are in 2008 but not Denali CTP3:

  • [sys].[dm_os_memory_cache_counters].[multi_pages_in_use_kb]
  • [sys].[dm_os_memory_cache_counters].[multi_pages_kb]
  • [sys].[dm_os_memory_cache_counters].[single_pages_in_use_kb]
  • [sys].[dm_os_memory_cache_counters].[single_pages_kb]
  • [sys].[dm_os_memory_cache_entries].[pages_allocated_count]
  • [sys].[dm_os_memory_clerks].[multi_pages_kb]
  • [sys].[dm_os_memory_clerks].[page_size_bytes]
  • [sys].[dm_os_memory_clerks].[single_pages_kb]
  • [sys].[dm_os_memory_nodes].[multi_pages_kb]
  • [sys].[dm_os_memory_nodes].[single_pages_kb]
  • [sys].[dm_os_memory_objects].[max_pages_allocated_count]
  • [sys].[dm_os_memory_objects].[pages_allocated_count]
  • [sys].[dm_os_sys_info].[bpool_commit_target]
  • [sys].[dm_os_sys_info].[bpool_committed]
  • [sys].[dm_os_sys_info].[bpool_visible]
  • [sys].[dm_os_sys_info].[physical_memory_in_bytes]
  • [sys].[dm_os_sys_info].[virtual_memory_in_bytes]
  • [sys].[dm_os_workers].[locale]

So, some neat stuff added. I'm not surprised to see database_principal_aliases disappear, but I was a little surprised to see some of the dm_os* stuff disappear... Interesting, Mr. Bond, very interesting.

Tags:

metadata

Comments

8/19/2011 9:04:39 AM #

pingback

Pingback from simranjindal.wordpress.comDMV changes in Denali CTP3 « Simran Jindal's Blog

simranjindal.wordpress.com

Add comment



(Will show your Gravatar icon)



  Country flag

biuquote
  • Comment
  • Preview
Loading



CAPTCHA image




Data Space Analyser

Tag cloud

Calendar

<<  December 2014  >>
MoTuWeThFrSaSu
24252627282930
1234567
891011121314
15161718192021
22232425262728
2930311234

View posts in large calendar